I need to analyse an XLS file but it contains multiple sheets and I can use only first sheet or selected sheet like one by one in XLS Reader. is there a solution for multiple sheet with XLS Reader or different way ? Also I saw a lot of question about the same problem but I couldn't see solution. Could you help me pelase ?
I solved the issue with ms sql query. the xls file imported to SQL database with tables(sheet) then I used an sql query for export all required data for knime xls reader.
As others noted a new reader is a welcome change though. :) (Also Writer... Like adding conditional formatting, or just writing the HiLite/color properties information, support for multiple sheets, etc.)