topic Re: Excel type while uploading in Application Development and Automation Discussions

Excel type while uploading

Former Member — Fri, 27 Apr 2007 11:56:11 GMT

What is the File type used to upload Excel file into Internal table using WS_UPLOAD. apart from ASC.

Please help me.

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 11:58:46 GMT

yes it is ASC

u can use ALSM_EXCEL_TO_INTERNAL_TABLE FM instead of that

and also chk TEXT_CONVERT_XLS_TO_SAP

Message was edited by:

Chandrasekhar Jagarlamudi

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 12:01:05 GMT

Hi,

we can use ASC file type in FM UP_UPLOAD.

reaward if it helpful

Thanks

Vana

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 12:02:39 GMT

Hi,

The other file type is 'DAT'.

You can save the excel file as Tab delimited flat file and with the above file type

you can upload the contents.

Reward if useful.

Thanks,

USR

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 12:02:53 GMT

'ASC' : ASCII file

The file is loaded line by line in the transferred table and this should

have one-column and be of the type C. The file size is returned in the

parameter FILELENGTH.

'TRU' : ASCII file + line wrap

If a line in a file does not fit into a row in a table, then the row is

filled completely, and the rest of the line is written to the next row

in the table. Words are not split, instead they are put into the next

row of the table.

'BIN' : Binary file

The file is loaded into the transferred table which should have

one-column and be of the type X. The table is filled line by line in

this case. In this case, the last line need not necessarily be

completely filled. For this reason, the parameter FILELENGTH must be

used during further processing. The table may be a maximum of 1022

characters 'wide'!

'DAT' : ASCII file with tab formatting

The file is loaded line by line into the transferred table. Tabs in the

file mean a change of field.

The file size is returned in the parameter FILELENGTH.

Reward points if helpful.

Regards

Nilesh

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 12:02:55 GMT

Hi..

U can also use .BIN (binary file) and .DAT files also,

from SAP help..

File type (ASCII, binary ...)

Possible values

'ASC' : ASCII file

The file is loaded line by line in the transferred table and this should have one-column and be of the type C. The file size is returned in the parameter FILELENGTH.

'TRU' : ASCII file + line wrap

If a line in a file does not fit into a row in a table, then the row is filled completely, and the rest of the line is written to the next row in the table. Words are not split, instead they are put into the next row of the table.

'BIN' : Binary file

The file is loaded into the transferred table which should have one-column and be of the type X. The table is filled line by line in this case. In this case, the last line need not necessarily be completely filled. For this reason, the parameter FILELENGTH must be used during further processing. The table may be a maximum of 1022 characters 'wide'!

'DAT' : ASCII file with tab formatting

The file is loaded line by line into the transferred table. Tabs in the file mean a change of field.

The file size is returned in the parameter FILELENGTH.

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 12:09:44 GMT

good

default is ASC , you can give TXT also.

thanks

mrutyun^

Re: Excel type while uploading

Former Member — Fri, 27 Apr 2007 13:20:24 GMT

Hi,

File type is ASC. Check the following link:

http://www.sap-img.com/abap/upload-direct-excel.htm

Regards,

Bhaskar