12-27-2007 5:49 PM
Please advice any FM that takes excel sheet file from local drive and convert the data present in excel sheet into text tab delimited as the output.......My input file should be excell sheet only.......i will call gui upload to get the file.but later after uploading i need the output to be displayed in text tab delimited file
Edited by: sapuser acc on Dec 27, 2007 7:11 PM
12-27-2007 5:53 PM
All you need to do is first read the file using GUI_UPLOAD
use GUI_DOWNLOAD FM and download as tab delimited file
-Pavan
12-27-2007 6:01 PM
Can you not simply save the file as tab delimited instead of writing a program?
-Cheers
12-27-2007 6:06 PM
in excel also you can do it...
In excel save as > in save as type choose -- text (tab delimited) and save.. u will have a tab delimited file.
you can use that tab delimited file as input to ur program.. in gui_download
12-27-2007 6:09 PM
Hi,
To the above FM's you can also use UPLOAD_FILES FM to reads the file from the presentation or application server, and transfers the data to the internal table
You can also download the files from SAP to an excel sheet by using FM DOWNLOAD_TO_XXL..
Please reward me with points if my reply is useful to you.
Thanks & Regards,
Ravi kanth yechuri.
12-27-2007 11:28 PM
Simply save as tab delimeted text file. Why do you need to write a program to do that since microsoft itself does this.
If it is from application server then you might have to think about writing new program to do that. I would recommend you to simply save as tab delemeted file on PC itself.