Reading an excel file without Microsoft Office installed

[Former Member]

Hello,

Im looking for a way to read an excel file (XLS) without Microsoft Office installed on the server,

The server in question is the SAP application server, and installing office on it is very problematic.

All the methods i have found so far take into account that I have Office installed on the computer running the code, whether its the abap function 'ALSM_EXCEL_TO_INTERNAL_TABLE' or JAVA api's which create an ODBC driver or something.

is this possible in another way?

thanks in advance,

[p_2_5_6_9_6_0]

Hi,

Its not possible without MS Office. A free alternative is OpenOffice or an open source library like POI.

If possible you can use a .csv file instead of an excel file for your processing. (Probably not helpful - but I just thought that I would mention it).

Thanks.

p256960

[Former Member]

Hi,

May be of use for you https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0cc41cb-9576-2b10-99a6-ab90ef28...

Regards

Ayyapparaj

[former_member182374]

Hi Udi,

What about Apache POI?

http://poi.apache.org/spreadsheet/index.html

Omri