Read Excel sheet data in WebDynpro Java Application

[Anmol_Kumar]

Hi,

Can someone please tell me how to read an excel file data in a webdynpro Java application?

Thanks

[Former Member · Accepted solution]

You have to first have the file either in the application or using the upload UI element. Then, you can read the file using standar java code through the io library. Just google how to read a file using java

And if you're planning to read an excel file (in excel format, not something like csv), you can use a specializaed java library like http://poi.apache.org/spreadsheet/index.html ... simply import it to the project and follow the instructions

[Former Member]

Hi Anmol,

You can check the below blogs to solve your requirements.

[Reading Multiple Sheets of Excel Sheet from Java|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4183] [original link is broken] [original link is broken] [original link is broken];

[Reading Excel Sheet from Java without using any Framework|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4113] [original link is broken] [original link is broken] [original link is broken];

Thanks,

MS