How to Export to Excel

[Former Member]

I have a scenario as follows :

I am developing an application in which I am using a dictionary table.I will fetch this data using the model binding and display it on my view.

But I have made a button on this view whcih converts this table data into Excel format.

Can anyone tell me how to do this conversion for this button.

Thanx in advance

[Former Member · Accepted solution]

Hi,

one PDF is availabe in the SDN by the name Exporting Context Data into Excel Using the Web Dynpro Binary Cache.

Hope this may help you.

Regards,

Deepak

[Former Member · Accepted solution]

thanx for ur answer

But where are we getting the data from???

I want the data to come from the model using JDBC links .

And when i click on the button , it shud give me a excel sheet which has all the table values in excel format...

Plz reply

[sureshmandalapu6 · Accepted solution]

Hi pankaj mathur ,

You are getting the data from your context and uploading into an Excel file. You need to get the data from from model by using JDBC and after u got the data, you need to follow the above given links.

Thanks

suresh

[Former Member]

First you must get the data from Database and add to context.

Please see this link for Export to Excel function

Regards

Vinod V

[Former Member]

hi

[Enhanced File Upload - Uploading and Processing Excel Sheets|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4591] [original link is broken] [original link is broken] [original link is broken];

[Enhancing Tables in WebDynpro Java u2013 Custom built Table Utilities|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3596] [original link is broken] [original link is broken] [original link is broken]; In this refer Creating an Excel file section

Mandeep Virk