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.