I want to add sheet in excel file.

[mythxAHIR]

Hi All,
Good Afternoon,
I have a problem in knime work flow i want add sheet in a excel file but the condition is that sheet name must be according name not by default value.
Please help me.
For Example:
MY Current Excel File:

I want Output Like this by knime:

[mlauber71]

@mythxAHIR you can choose a specific name for an Excel sheet and you can opt to overwrite the whole Excel file or just the specific sheet if it already exists. If there are problems (within a larger jobs or loop you might be able to force the use of a specific name):

There is a free book and several videos for people coming from Excel to KNIME. You might want to take a look and familiarize yourself with the concepts behind KNIME.

From Excel to KNIME - written by Kathrin Melcher:

From Excel to KNIME | KNIME

and there is this video by the author

First Steps into KNIME Analytics Platforms for Excel Users

KNIME and Excel - what you can and cannot do

Excel Reader - Transformation -Removing Columns Multiple Sheets

@mb7846 I think we would first have to establish what you and and cannot do with generic Excel functions in KNIME right now you can load almost all Excel sheets in various settings (all sheets from one file at once if they have the same structure), loop thru a lot of Excel files, read all sheet names to make decisions about them and so on. So you can import all kinds of dats from Excel then you can EXPORT data either by writing a new file or replacing a single sheet (which will be a plain data…

An finally I have created a (large) collection abot a lot of use cases and examples about KNIME and Excel (some are advanced) that I have come by over the years - you might explore them as well

Import EXCEL - a meta workflow trying to answer questions about importing...