Problem :: I have a excel in which there are more then one sheet name and i want to create another excel file in which i can write all the sheet name as column name and in all the sheet.

@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] [image] Read the sheet names from an existing excel file and add the sheet name as a... Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file

Hi @mythxAHIR , To confirm understanding, you currently have a single excel file and that file contains multiple sheets. You want to create a new excel file that contains a single sheet which is simply a list of the sheet names from your original file, in a single column. Is that correct?

Yes. No, I want to add sheet names as column name in all sheet.

Thanks for the update, but I’m still slightly puzzled, so maybe we can work with an example. Are you saying that the new excel file contains everything from the original excel, but additionally has a column on each sheet containing the sheet name? If for example you had a spreadsheet as follows, with three sheets “Sheet1”, “Sheet2”, “Sheet3”, [image][image][image] You’d want to produce something like this? … [image][image][image] Is that right? How complex is your original excel? Is it purely tabular data which could be read in and rewritten in entirety, or is it more of a “document”, where there is any information in the sheets that is not in a purely tabular form. I think that is likely to make a big difference to the ease with which what you want can be achieved.

Yes, But all i want to do in KNIME.

KNIME Forum Archive

I want solution of this problem

KNIME Analytics Platform

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled