GUI_DOWNLOAD in Excel format

[Former Member]

Hi Gurus,

I am using GUI_DOWNLOAD for excel (.XLS) format

I Used

*FILETYPE = 'ASC' / DAT

WRITE_FIELD_SEPARATOR = 'X'

My problem is the data not getting proper excel format.

thanking you.

Subash

[Former Member]

GUI Download doesn't know what an Excel file is....download into a .csv (comma-delimited) or tab-delimited (.txt) file and import into excel from the desktop file, with Windows Explorer or Excel.

[former_member979210]

You can create a file with extension .xls,
but in fact the file contains only plain text, but when you open a file by using ms.excel,  it will be generated so that it becomes a table.