Export data to excel

[Former Member]

Dear experts,

I have an application where I am displaying vendor details output in a view.

Now my requirement is to export those details of vendor to excel.

Please guide me the step by step procedure to export those data into excel.

Regards,

Mamai.

[vijay_kumar49 · Accepted solution]

Hi Mami,

First u should include jxl.jar API in ur classpath.

ind a Resource variable to FileUpload UI. Then from the Fileupload UI, u can get the Sheet variable as

[Uploading excel file using WebDynpro for Java|http://wiki.sdn.sap.com/wiki/x/BIHrBg]

[Exporting Context Data into Excel Using the Web Dynpro Binary Cache|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353]

[Web Dynpro Java - Exporting Table Data Using On-Demand Streams - SAP NW 7.0|http://wiki.sdn.sap.com/wiki/x/0mQ]

I hope this is help full for you,

Regards

Vijay

Edited by: VijaySAPEP on Aug 3, 2011 3:32 PM

Edited by: Jason Lax on Dec 28, 2011 2:32 PM (Optimized URLs)

[Former Member · Accepted solution]

Hi,

Could u pls tell me where do I get jxl.jar ??

Regards,

Mamai.

[vijay_kumar49 · Accepted solution]

Hi Mami,

U can download jxl.jar file : http://www.java2s.com/Code/Jar/JKL/Downloadjxljar.htm

you are creating the Application by using DC's u can follow these Steps

You cant just add any external jar file into a DC project.

There is only one way to add a external jar file is by using external library project.

1.create an external library project type DC.

2. put your external jar file into its lib folder.

3. create its public part of type SDA...and API.

4. just use SDA public part into your webdynpro project as used DC.

4. and when you deploy your webdynpro project on server, this file will also get deployed... remember to use SDA public part..

Regards

Hope this is help full for you,

Regards

Vijay

[Former Member]

Hi,

You can use Apache POI to generate excel file. Please find below link for the detail: http://www.sapgeek.net/2010/10/web-dynpro-java-generate-the-excel-file/

Please find http://www.sapgeek.net/sap-tutorial/web-dynpro-java-tutorial/ for other Web Dynpro tutorials.

Regards,

Andy