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?

Fifteen Stars TRF
Fifteen 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.

 

Highlighted
Fifteen Stars TRF
Fifteen 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

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Modern Data Engineering in the Cloud

Learn about modern data engineering in the Cloud

Watch Now

How to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud reg...

Learn how to deploy Talend Jobs as Docker images to Amazon, Azure and Google Cloud registries

Blog

Talend API Services Publish to Talend Cloud

Learn how to publish your API Services to Talend Cloud

Watch Now