Reading an Excel file with Multiple Tabs

[kmarrs901]

I have an Excel file I want to read that has several tabs. I want to take that Excel file and create different CSV files for each of the tabs. Do I need to use multiple Excel Reader nodes or can one node do that? Or should I put it all in a container. I am trying to get it where I am only executing it once if that is possible.

[takbb]

Hi @kmarrs901 , take a look at this workflow

Read all sheets from an XLS file in a loop – knime

(Ignore the mention of “XML” in the description. I think that is a typo)

You can use the sheet name to use for the csv output file name inside the loop (probably using String Manipulation (variable) and String to Path nodes to create the csv file name as a path variable and then attach Csv Writer inside the loop.

Hope that points you in the right direction.

[mlauber71]

@kmarrs901 you could also take a look at this example:

I want solution of this problem

@mythxAHIR you might want to take a look at this example and see if you can adapt that. At the core the sheet name will be inserted as a column. You should have all the elements that you would need to combine the elements accoring to your needs: [image]