Hi,
I am facing an issue while reading data from multiple sheets of a .xls file.The tab/sheets are having different metadata or column definitions, so we are selecting the option "All sheets" in tFileinputExcel component.But we end up with having data in the output, only up to the first sheet's columns.
The scenario is : in a excel file we have three tabs - in tab1 we have 3 columns,in tab2 5 and in tab3 10.My desired output is all the columns appended from all the sheets, irrespective of the metadata.The sheet names are not known and header names are also unavailable.We are simply feeding random number of hedaers(100 columns) for metadata of tFileinputExcel component.
We can achieve the required output if the source file extension is : .xlsx but not for .xls.
Any suggestion on this?
