Talend how to change file extension from xlsb to xlsx

Five Stars

Talend how to change file extension from xlsb to xlsx

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?

Highlighted
Forteen Stars TRF
Forteen Stars

Re: Talend how to change file extension from xlsb to xlsx

The standard component tFileCopy may be used to rename a file while copying it.
There is also a tFileRename component on Talend Exchange.

TRF
Five Stars

Re: Talend how to change file extension from xlsb to xlsx

Hi,

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.

 

Forteen Stars TRF
Forteen Stars

Re: Talend how to change file extension from xlsb to xlsx

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.

Maybe...


TRF