Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

very urgent.............pls advice

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

All you need to do is first read the file using GUI_UPLOAD

use GUI_DOWNLOAD FM and download as tab delimited file

-Pavan

Former Member
0 Kudos

Can you not simply save the file as tab delimited instead of writing a program?

-Cheers

former_member156446
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

former_member191735
Active Contributor
0 Kudos

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.