Regarding file upload

Former Member — Wed, 12 Sep 2007 04:14:50 GMT

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

Re: Regarding file upload

Former Member — Wed, 12 Sep 2007 04:16:27 GMT

For Excel Upload

FM GUI_UPLOAD(Presentation server) or open dataset(application server).

You can upload coloured columns

For Excel Downloading with COloured COlumns

Please use FM “XXL_FULL_API”.

You can refer report program XXLFTEST or XXLTTEST.

Message was edited by:

Prashant Patil

Re: Regarding file upload

Former Member — Wed, 12 Sep 2007 04:19:59 GMT

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 points if useful..............

Regards

Minal

topic Re: Regarding file upload in Application Development and Automation Discussions

Regarding file upload

Re: Regarding file upload

Re: Regarding file upload