"GUI DOWNLOAD" problem

[Former Member]

Hello gurus,

I searched the whole forum but i did not find any solution to my problem.

I want ti export an internal table to excel format.

i use the function "GUI DOWNLOAD".

but when i save the file it's tab delimited . i open it with the excel and when i try to save it, it pop ups the message :

"the file may contains feautures that are not compatible with Text (Tab Delimited)"

So i saved as xls type.

And i notices that it has a difference at the size, the xls is bigger...

1. why is that difference ?

2. what should i do to get automatically from SAP the xls file type ?

Thx in advance.

[Former Member]

That message is just a warning.

As long as you don't use any sort of formating, saving the data as tab delimited is ok.

The difference in size is because a tab delimited excel file is just a plain text file, while a .xls file is more complex (it saves formating, graphics, etc.)

If you want a real .xls file you can use OLE but it has it drawbacks.

[Former Member]

I've always advised users to open downloaded "Excel" files with Windows Explorer, since that results in automatic invocation of the import wizard and puts the tab-delimited download file into an Excel Worksheet. If you do this, the user needs to change the file settings when they save, from tab-delimited (.txt) to Excel Worksheet (.xls or .xlsx).

[StMou]

Hi,

SAP create tab delimited xls file. You can open with excel but after you should save in xls format.

See OO (class) or Office inplace to save in excel (standard) format.

Rgds

[kesavadas_thekkillath]

Im not sure...Just try downloading it in DAT format

[Former Member]

Hello All,

When I enter my mail address , automatically mail comes to my INBOX.

But the file format is  : ( . htm )

When I am extracting file from htm to .xls , it gets converted.

But problem is that , there there has been some blank spaces in the cells due to which i am unable to through the formulas.

Please suggest me how can i change the file type in the above screenshot.

If file gets downloaded into Excel directly, blank spaces might be eliminated.