Reading Excel file for Linux Application Server

[Former Member]

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]

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]

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

[Former Member]

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