EXPORT_TO_SPREADSHEET

[Former Member]

Hi

Do you know how to fill parameter RANGES of EXPORT_TO_SPREADSHEET

function module?

[former_member181995]

Why Don't you use GUI_DOWNLOAD instead of EXPORT_TO_SPREADSHEET?

or morover you may use standard as well List>Export>Spreadsheet from report output..

[Former Member]

I must transfer internal table data into excel file beginning from concrete cell.

[Former Member]

Hi Marat,

Check this link for documentation for SOI_DIMENSION_TABLE. The Ranges is of type SOI_DIMENSION_TABLE

http://help.sap.com/saphelp_nw04/helpdata/en/71/489218e5b411d2bdc3080009b4534c/frameset.htm

Check the program in the below link to know how to fill data in Ranges. In this program IT_DIMENSION and ET_DIMENSION are of type SOI_DIMENSION_TABLE

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60938938-de6f-2910-2080-fc80d38e...

Cheers,

Kothand

[Former Member]

hi ,

try this...

use GUI_DOWNLOAD with WRITE_FIELD_SEPARATOR = 'X' .

and give ".XLS" extension to the file ....