Dynamically how to uploadExce With Parameters.

[vijay_kumar49]

Hi Friends,

I need some helping hand on a task requirement,

Requirement:

Need to create a Java Application (uploadExcel) which converts to the uploadExcel.jar file in NWDS.

Wanted to reuse upload Excel functionality in the Webdynpro Java, will use as jar and with parameters.

forExample:-

uploadExcel.import_excel_file ( temp_excel_file, 5,25); --> In Webdynpro Java

uploadExcel Java application Method:

import_excel_file ( (temp_excel_file,  num_of_coll,num_of_rows  )

{

1. Give me the some hints how can I Read the data from Excel and set the Data to Node.

2. How Read the Data(Rows/Columns) from Excel Dynamically in JAVA.

}

　

Could you please let me know how can I achieve this requirement.

Thanks in advance for your cooperation and support.

Regards

Vijay Kalluri

[Former Member]

Hi,

As Jun has already said, there are lots of explanations on how to upload Excel files with Java both here on SCN and on the wider internet via Google.  I have always used POI and found it to be easy to work with.

I'd suggest you do some more searching and background reading on this and then come back with some more detailed questions if/when you get stuck.

Cheers,

G.

[junwu]

using jxl or apahce poi to read excel, just google, plenty of code.

after extracting the data from excel, you can set to node with basic context api, do you know web dynpro?