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 failedpecified 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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.