In talend how can we change file extension from xlsb to xlsx? Do we need to write script or any custom component does this functionality? Can someone please help on this?
Thanks so much for your quick reply. I am getting the below error message when i used tfilecopy component to change extension, couldn't open .xlsx file.
xlsb is for Excel binary format.
Changing the extension to xlsx tells this is a standard Excel file but it is not.
This the reason why Excel cannot open the file.
What if you try to change the extension by yourself from Windows?
I'm afraid you'll get the same result.
Not sure the is a solution available on the shelf.
Maybe you can found a piece of Java code to solve this case.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn about modern data engineering in the Cloud
Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries
Learn how to publish your API Services to Talend Cloud