Copy Paste functionality between excel and web dynpro

[Former Member]

Dear Experts,

I have multiple entry screens in my web dynpro application and data needs to be copy/pasted between excel files and these applications. Is there any possibility of doing this? I know a cells content can be copied but if we have multiple cells in excel can this be copied to multiple cells in the web dynpro application? Is there some interface i can use for this?

thanks and regards,

dilanke

[Abhinav_Sharma · Accepted solution]

Hello,

Yes there are APIs using which you can transfer the data between excel file and webdynpro. JXL, JExcel etc are some of the APIs. Refer [http://jexcelapi.sourceforge.net/resources/javadocs/index.html|http://jexcelapi.sourceforge.net/resources/javadocs/index.html]

and

[http://wiki.sdn.sap.com/wiki/display/WDJava/UploadingexcelfileusingWebDynproforJava|http://wiki.sdn.sap.com/wiki/display/WDJava/UploadingexcelfileusingWebDynproforJava]

Hope this will help you.

Abhinav

[Former Member]

Hi,

Thank you. I'm using JExcel to do this.

Thanks,

Dilanke