Function EXPORT_TO_SPREADSHEET? How does it work?

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

MM

[Former Member]

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.

[krzysztof_murkowski2]

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

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

regards,

Kris