I have downloaded a Excel file from the HSCIC website, and that file has three different sheets. I saved this file in a CSV format in Excel and imported it on KNIME through the file reader node. However, the problem is that I can only view one sheet, is there any chance I can have access to all the excel sheets in KNIME at once, is there a node I need to use for this.
As far as I know, saving files to CSV format in Excel will only save the current sheet. In order to preserve all sheets while saving, you should use the XLS format.
The XLS Reader node allows to select which sheet is being read. You can read multiple sheets from the same file by feeding the file path as a flow variable into multiple XLS Reader nodes.
I don't know however if there's a way in KNIME to dynamically get the number of sheets in a given XLS file, in order to loop over all sheets. Maybe someone else is able to help here.