Export data to MS Excel in Adobe interactive form

[Former Member]

Hello Experts,

I am using Webdynpro Java and ALCD 8.2. Can anyone help me out with functionality of Exporting adobe form data to excel file.

Thanks in advance,

Swami

[Former Member]

I don't know how this could be done from the pdf, but you can do it server-side. Check this links:

[http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/edc2f3c2-0401-0010-8898-acd5b6a94353]

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4210] [original link is broken] [original link is broken] [original link is broken];

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2666] [original link is broken] [original link is broken] [original link is broken];

Regards, Aldo.

[Former Member]

Hi Swami,

When you say exporting data to a excel spread sheet.

Does that mean once the form is generated then user should able to export to excel, if so below is the link for that.

http://forums.adobe.com/thread/709565?tstart=1

if its like for an interactive forms where user submits data the on submit event if you want to publish the form data to a spread sheet, I believ there should be a lot of posts on generating CSV files from ABAP code. this is also possible from WDJ provided if you have the respective jar files (on submit even, read data from the context, process to required format, call the excel API and write to it.)

If from ABAP handler the post from the other blogger here might help.

does this help, let me know if you are looking for something more specific.

Cheers,

Sai

[Former Member]

Hi Sai,

Thanks for the help. My requirement is like i need to keep a button on interactive form and click on that the data available on table should get exported to Excel.

I tested with the first option provided by you but merging XML data files into a spreadsheet option is not available when using Interactive form.

Is there any other way to implement scenario i am trying with?

Regards,

Swami

[OttoGold]

There is no way of sending the data to the webservice or SAP backend. You need the form to be able to save another file?

Well, what I would do: create a blank excel file and save it as XML type spreadsheet. The start scripting in the form like this:

- load the content of the XML spreahseet into the memory

- find the right place where you want to put your variables (I would use some placeholders like XXX in the XML file which will make it easier for you to find the right place where to put the data)

- save

this would produce Excel spreadhseet. Or you can go for CSV.

Cheers Otto