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?

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.