Excel chart download?

[Former Member]

Hi,

i'am searching for a method to download a table from R/3 to an excel file and to create in this excel file one folder with the data and one with a chart of these data.

Is something like this possible?

Thanx

Tony

[Former Member]

Hi use this function module

ALSM_EXCEL_TO_INTERNAL_TABLE

reward if helpful

vivekanand

[Former Member]

Hi Vivekanand

I suppose ALSM_EXCEL_TO_INTERNAL_TABLE IS USED TO upload excel files to internal table, please correct me if i am wrong.

Regards

Tharanath

[Former Member]

Hi there,

I don't know whatis your exact requirement but you can download the contents of a table into excel sheet and then you can create chart or graph i think.

For doing this select System->list->save->spreadsheet. and give the location where exactly you want to store the excel sheet.

Reward points if useful.

Regards

Tharanatha

[Former Member]

Hi,

i want to write a report, which dowloads the result in an excel file.

In this Excel file the data should be shown as table, and as chart in a seperate slider.

Thanx

Tony

[Former Member]

Hi

GUI_UPLOAD is normally used to upload text files. For uploading excel file, its better to use ALSM_EXCEL_TO_INTERNAL_TABLE.

For Excel Downloading with COloured COlumns

Please use FM “XXL_FULL_API”.

You can refer report program XXLFTEST or XXLTTEST.

EXCEL_OLE_STANDARD_DAT Just calls MS_EXCEL_OLE_STANDARD_DAT

SLPC OLE - PC interface MS_EXCEL_OLE_STANDARD_DAT Downloads internal table and opens it in MS Excel. Example.

KCDE Data transfer from PC files KCD_EXCEL_OLE_TO_INT_CONVERT Uploads an *.xls file to internal table (max cell length = 32). Example. This function uses a range selection and copy-paste technique, therefore it quite fast.Q

There is another Example 2 that reads data from Excel file cell by cell.b

ALSMEX FI-AA Legacy Data Transfer w/ Excel

ALSM_EXCEL_TO_INTERNAL_TABLE the same as KCD_EXCEL_OLE_TO_INT_CONVERT but max cell length = 50

FTBU_CONV General conversion

FTBU_START_EXCEL just [download internal table to file and] start Excel (w/o OLE). See also WS_EXCEL

The TXXL function group uses the DLLs and other files installed with SAPGUI in directory: ...\Program Files\SAP\FrontEnd\SAPgui\xxl\

Can work both with Excel and Lotus 1-2-3:

TXXL EXCEL - list viewer interface

XXL_FULL_API Output Excel list viewer list SAP examples:

XXLFTEST (XXL Test Environment / XXL_FULL_API Example)

XXLTTEST (XXL Interface: Test Program for Formats and Types (also XXL_FULL_API))

XXLSTEST (XXL Test Environment / XXL_SIMPLE_API Example)

XXL_SIMPLE_API Output list viewer list with reduced functions

XXL_CHECK_API Examble of use in customer reports:

if question = 'STARTABLE'

and return_code <> 0

then "Download to Excel" button has to be excluded from a pf-status

In fact, the return_code is always set to 0 in the FM source code s.

check

http://www.geocities.com/victorav15/sapr3/abapfun.html#ole

Reward all helpfull answers

Regards

Pavan