topic Re: Reading Excel file for Linux Application Server in Application Development and Automation Discussions

Reading Excel file for Linux Application Server

Former Member — Mon, 04 Jun 2012 10:42:23 GMT

Dear SDNers,

I m trying to read the excel file content into internal table from my application server which is installed on Linux.

I used below statements for the same.

open DATASET ld_file FOR INPUT IN TEXT MODE ENCODING NON-UNICODE IGNORING CONVERSION ERRORS.

read DATASET ld_file into wa_string.

wa_string is having all junk data like #############>#################'e#####################

But its giving me some junk data into internal table. Not the actual data.

Please let me know is it possible to read ms-excel data from linux application server?

If not, then what is the alternate to do the same.

Regards,

Venkat

Former Member — Mon, 04 Jun 2012 10:57:40 GMT

Hi Venkat

Have you tried just using.

OPEN DATASET p_file FOR INPUT IN TEXT MODE ENCODING DEFAULT.

Else you can look at the FM ALSM_EXCEL_TO_INTERNAL_TAB to convert binary.

Hope this helps

Vic

Former Member — Mon, 04 Jun 2012 11:33:17 GMT

I have tried it..Even though it is giving same junk values..

Former Member — Tue, 05 Jun 2012 07:20:37 GMT

Hi Nath

Don't know if you found a solution as yet.

But have you tried the FM TEXT_CONVERT_XLS_TO_SAP?

Regards

Vic