How to read xlsm Files in Talend Studio

How to read xlsm Files in Talend Studio

Hi,
I'm having an xlsm file with 10 sheet.I need to add the values from the database to the Sheet1 of that file.tFileOututExcel is not supporting this.Is there any other component that servers my requirement.I've seen ExcelWorkBookOpen component.But,I'm unable to insert the data using that.Can anyone suggest me in this.I'm using 5.0.2 version
Thanks
Krishna
Moderator

Re: How to read xlsm Files in Talend Studio

Hi,
So far, we don't have such component to support .xlsm file in talend. There are only .xls file and xlsx file can be supported by talend.
It suggested that you should report an issue for your new feature on talend Bug tracker
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: How to read xlsm Files in Talend Studio

HI !
I need processed data into the .xlsm format of Excel 2007
It can?

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch