Error reading macro-excel(xlsm) file having formula cells in it

Five Stars

Error reading macro-excel(xlsm) file having formula cells in it

Hi,

I am using custom components(tfileexcelworkbookopen-->tfileExcelSheetList-->tfileExcelSheetInput) to read a xlsm file.

It is giving the following error : "java.lang.Exception:Read column Inventory_Date in row number=1 failedSmiley Frustratedpecified named range 'WM_TableFormID' does not exist in the current workbook. ".

 

The problem is it is reading the cell's formula instead of reading the real data.

Please suggest.

 

Thanks

skp

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.