Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

Regarding file upload

Former Member
0 Kudos


I am uploading an Excel file onto presentation and application server.

I want some of the columns in the Excel file to be colored.

is this possible.

if so please let me know how this can be achieved.

Any help is appreciated.


Ravi G


Active Contributor
0 Kudos

For Excel Upload

FM GUI_UPLOAD(Presentation server) or open dataset(application server).<b>

You can upload coloured columns</b>

<b>For Excel Downloading with COloured COlumns</b>

Please use FM “XXL_FULL_API”.

You can refer report program XXLFTEST or XXLTTEST.

Message was edited by:

Prashant Patil

Former Member
0 Kudos


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

<b>ALSM_EXCEL_TO_INTERNAL_TABLE</b> the same as KCD_EXCEL_OLE_TO_INT_CONVERT but max cell length = 50

<b>FTBU_CONV </b> General conversion

<b>FTBU_START_EXCEL </b> 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

<b>XXL_FULL_API </b> Output Excel list viewer list SAP examples:

<b>XXLFTEST</b> (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)

<b>XXL_SIMPLE_API </b> Output list viewer list with reduced functions

<b>XXL_CHECK_API </b> 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.


Reward points if useful..............