Knowledge Management

Question:
hai all,
im working in 4.6c , i have a problem in downloading data to xls file in application server. i used tranfer but i get all the datas in a single column .
thanx in advance
arvind
Answer:
/forums/viewtopic.php?t=59290&highlight=download+xls

Answer:
If saving to the application server, you need to insert delimiters yourself before the transfer command. You could insert commas or tabs between each field.
Three possible ways to do this:
create structure where every second field is a character.
concatenate all the fields together separatd by comma. If the fields are a text fields, you can use FM SAP_CONVERT_TO_CSV_FORMAT, but be careful as this does not cope with a comma in one of the text fields
Michael
Answer:
or call function module WS_DOWNLOAD, specifying WK1 output....(see documentation for other export settings), naming the internal table, advise your users to open the downloaded file with Windows Explorer, not Excel, which will result in automatic import into an Excel Workbook. Be sure to check your return code...download will fail if drive/folder don't exist or if a file with the same name is already open on the user's desktop.
_________________
D.