topic Re: Function EXPORT_TO_SPREADSHEET? How does it work? in Application Development and Automation Discussions

Function EXPORT_TO_SPREADSHEET? How does it work?

Former Member — Mon, 27 Mar 2006 13:11:34 GMT

Hi all again.

I have another problem...I am trying to use the function EXPORT_TO_SPREADSHEET, but for any reason the excel document (that I want to use like a template) is not filled with the data that I put in the data_table of the function? Does somebody has a working example of this function?

Thanks again,

Marcelo Moreira

Re: Function EXPORT_TO_SPREADSHEET? How does it work?

Former Member — Mon, 27 Mar 2006 13:20:07 GMT

Hi Marcelo,

if your aim is to download data in an internal table into an excel file, then you can use the function module GUI_DOWNLOAD as an alternative.

Re: Function EXPORT_TO_SPREADSHEET? How does it work?

Former Member — Mon, 27 Mar 2006 13:30:09 GMT

Hi Ravi,

In fact my aim is it to download an internal table to an Excel, but I need to use an Template document. I what to fill the corresponding field of the template with data from my internal table.

Anyway I am going to try your idea. Thank you.

Re: Function EXPORT_TO_SPREADSHEET? How does it work?

Former Member — Mon, 27 Mar 2006 13:31:29 GMT

Hi marcelo,

1. I what to fill the corresponding field of the template with data from my internal table.

For that, u will have to use ole technology,

where we can open excel as an object,

and MANIPULATE the contents,

CELL WISE.

2. I don't think there is any FM,

where u can work with templates.

3. GUI_DOWNLOAD is the best way

to put the raw data of internal table

into excel, AS IT IS.

4. But working with templates,

ie. manipulating cell wise with ole technology

will be quite cumbersome for anybody !

regards,

amit m.

Re: Function EXPORT_TO_SPREADSHEET? How does it work?

krzysztof_murkowski2 — Fri, 01 Feb 2013 13:43:30 GMT

You can find an example how to use function EXPORT_TO_SPREADSHEET here:

http://www.kerum.pl/infodepot/00038

regards,

Kris