Can we convert .xlsx file to .csv in SAP HANA?

[nvdora]

Can we convert .xlsx file to .csv in SAP HANA?

if yes, can anyone guide me to solve this issue,

Thanks inadvance.

[pfefferf]

Can you add some information to your question in what context you wanna do that (XS Classic, XS Advanced, directly on DB layer ...)?

[nvdora]

Hi Florian Pfeffer,

thanks for your reply...

actually my scenario is like this, I have 10000+ records in Excel sheet located in local system, from there I need to get the path of the file and want to convert it into .csv and want to use IMPORT FROM statement in HANA to import data into HANA database table.

So, is there any chance in HANA database that converts .xlsx to .csv programatically?

[pfefferf]

Related to your comments I'm not really sure if you wanna do the conversion really in the HANA layer itself and not on the operating system/file level.

Of course in XS Advanced you can use some free modules (Java, Node, ...) which do a conversion after you uploaded the excel file. But then you should directly store the data instead of saving the data back to the file system and import it using IMPORT FROM.

Maybe you can check also if it is an option - if you wanna use IMPORT FROM - to convert your excel file directly on file system level. There are a lot of free tools for Linux to do the conversion (e.g. ssconvert) after the the excel file changes (e.g. inotifywait).

If you would have available the Smart Data Integration option in your HANA environment you could also use the SDI Excel Adapter, which would allow you to access your excel file via a virtual table.

Regards,
Florian