File Conversion From XLS format to TEXT format

[Former Member]

Dear All,

Could You please let me know if there is any standard program that can be used to convert XLS format input file to TEXT format..Other wise could you provide me a code for that .

Thanks & Regards

Avik.

[Former Member]

Hi...

use TEXT_CONVERT_XLS_TO_SAP as suggested by nitin..that from that internal table

use GUI_download to convert that into text..

regards

vivek

[Former Member]

Hi Avik,

Try FM TEXT_CONVERT_XLS_TO_SAP

Regards,

Nitin.

[Former Member]

Hi...

use TEXT_CONVERT_XLS_TO_SAP as suggested by nitin..that from that internal table

use GUI_download to convert that into text..

regards

vivek

[Former Member]

Hi,

try these below Funtion Modules,

TEXT_CONVERT_CSV_TO_SAP

TEXT_CONVERT_TEX_TO_SAP

TEXT_CONVERT_TXT_TO_SAP

TEXT_CONVERT_XLS_TO_SAP

TEXT_CONVERT_XML_TO_SAP

Regards,

Anki Reddy

[Former Member]

hi

just open the file in excel and save as "text tab delimited file" and give the file extention as .txt.

hope this helps

regards

Aakash Banga

[Former Member]

thank you

[Former Member]

Hi,

Upload Excel file and download GUI_DOWNLOAD as txt file.

Regards

Md.MahaboobKhan

[Former Member]

Avik,

If your query has been resolved, please close the thread.

Regards,

Nitin.

[Former Member]

Thanks all for the inputs .

Actually my req is to covert XLS to SWIFT MT940 format in text file does any body has a sample pgm that does it

It will be a real help.