topic Re: uploading excel from application server in Application Development and Automation Discussions

uploading excel from application server

Former Member — Tue, 18 Jul 2006 06:30:31 GMT

Is there any way to upload excel file from application server to database tables? Also, is there any way to rename an excel file in the application server to xls file?

Re: uploading excel from application server

naimesh_patel — Tue, 18 Jul 2006 06:33:26 GMT

Hello,

You need to use OPEN DATASET to read the data.

and for renaming:

1. read data into your program

2. put data back into new file

3. delete old file with DELETE DATASET.

regards,

Naimesh

Re: uploading excel from application server

Former Member — Tue, 18 Jul 2006 06:34:37 GMT

You can use ALSM_EXCEL_TO_INT_TABLE function to upload a excel to internal tablt from your app server. Then you can save it to the database table.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: uploading excel from application server

Former Member — Tue, 18 Jul 2006 07:32:48 GMT

Rename the file like this.

Slight midifications required.

CONCATENATE w_saptempdir

'/'

it_matfile

INTO w_saptempdir.

CONCATENATE w_sapfldir

'/'

it_matfile

INTO w_sapfldir.

TRANSLATE: w_saptempdir TO LOWER CASE,

w_sapfldir TO LOWER CASE.

CONCATENATE 'mv' w_saptempdir w_sapfldir INTO var-parcom SEPARATED BY

space.

CALL 'SYSTEM'

ID 'COMMAND' FIELD var-parcom

ID 'TAB' FIELD tabl-sys.