Pasting data from Excel sheet to Table in web dynpro View

[Amey-Mogare]

Hii All,

Is it possible to copy data ( some rows) from Excel sheet and paste in table in a view?

I tried doing this, but only first element is getting pasted..

Does anybody know how to do this?

Is there any way to perform similar thing?

Pls help.

regards,

Amey

[Former Member · Accepted solution]

Hi,

Copy paste may work if you have that many rows in your table(not sure).

One thing you can do is upload the excel and then populate the context of the node bound to the table by fetching data from the excel

For this you can make use of JXL or APACHE POI.

Regards

Ayyapparaj

[Amey-Mogare · Accepted solution]

Ya, u r correct. I tried copy and pasting 10 lines frm excel into table having 10 rows, but it didnt worked.

Only first entry is getting pasted in first row in table..

Can you please elaborate on use of JXL or APACHE POI with Web Dynpro??

regards,

Amey

[venkatakalyan_karanam]

Hi

Please go through the following thread

Regards

Kalyan

[Amey-Mogare]

Hii,

Thank you all for prompt replies..

What I found in all those links is that uploading the excel file is mandatory task.

Is there any way to copy and paste from excel sheet without uploading file?

regards,

Amey