I am trying to appending 10 sheets of a single excel. When I tried, the first sheet is getting appended 10 times, instead of the data of 10 sheets. Attaching the workflow and the data used. Please help me in resolving the issue.
Reading sheets.knwf (23.4 KB)
Welcome to KNIME Forum. First of all tnx for uploading your wf. Unfortunatly it is empty. I think because you forget to uncheck the checkbox before uploading.
I added some node to your wf, see Reading sheets_v2.knwf (105.0 KB).
And I think you were almost there, using the Path and Sheet names as flowvariables.
The Read Excel Sheet Names gives you the Path and Sheet flow variable you used in the Excel reader.
In the Excel reader itself go for:
And in the Data Area tab, see if unchecking “Use Values in Row” gives a better result.
Hope this helps
gr. Hans
1 Like
Hans was a minute quicker than me 
You can also check out this workflow here, were I addressed a similar topic
2 Likes
Hi HansS and ActionAndi,
Its still not working with my excel sheet.
I once again sharing my working unchecking the reset option.
Once again thanks for the help.
Warm Regards,
Kavitha
@kavitha_kurup we still cannot follow your example since the data is not in a folder we can access. You can try and force the name of the sheet like this:
There still is a ticket out there AP-18133
Attaching the data.
SalesGL_Conso_V2.xlsx (2.9 MB)
@kavitha_kurup it seems the structure of your sheets is not the same. Sometimes the values start in a different row. You might have to indemnify the rows that are not compatible and eliminate them. Or the “Total” Lines might have to be removed.
Key is to identify the areas where you want to import the data from
Also at the end allow for changing schemas. And maybe deal with the results later
