How to read xlsm Files in Talend Studio

Highlighted

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.
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?

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

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read