Is there a way to convert without xlsm file to xlsx file in Talend?

[Anonymous]

Using POI libraries I have an idea this can be done and after developing that jar file can be run via Talend.

But using POI librariress the work that have to be done will be high if we are working with multple templates.

So please help me the best,efficiency and less re work way to overcome from Talend perspective?

please find the bellow mention,  my previous related post link

https://community.talend.com/t5/Design-and-Development/How-to-read-XLSM-files-from-Talen-Open-Studio...

[Anonymous]

Hi,

    There are no standard utilities to convert the xlsm to xlsx sheets but you can embed the programmatic code to a Talend routine where you can pass the file name and path as parameters and you will get the modified file path as result set.

     I saw a below article where the underlying conversion code is available. I will have to 

https://www.experts-exchange.com/articles/8269/Convert-between-Excel-file-formats-XLS-XLSX-XLSM-with...

Another option is to go by API route where you can pass the details to third party API and it will provide the results (like below).

https://products.aspose.com/cells/java

You can integrate the details with Talend API capabilities in Cloud.

Either way, you will have to do some customization from your end to solve this use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[samT]

Hi Nikhil, Is it possible you can help me to get that code which I can place in the routine to convert .xlsm to .xls or .xlsx... API route not possible for me due to controls within our environment. The expert exchange site says to download the link to try but cannot find the attachement. Please if you can share some info would be highly appreciated. Thanks Sam