09-12-2007 5:14 AM
Hi,
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.
Regards,
Ravi G
09-12-2007 5:16 AM
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
09-12-2007 5:19 AM
<b>EXCEL_OLE_STANDARD_DAT</b> 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
<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.
check
http://www.geocities.com/victorav15/sapr3/abapfun.html#ole
Reward points if useful..............
Regards
Minal