# I want solution of this problem **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [May 23, 2022, 7:11am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376 "2022-05-23T07:11:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mythxAHIR](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mythxahir/32/39985_2.png) [@mythxAHIR](https://forum.knime.com/u/mythxAHIR)\ **Post date:** [May 23, 2022, 7:11am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/1 "2022-05-23T07:11:11Z")
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. ---
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [May 23, 2022, 7:23am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/2 "2022-05-23T07:23:49Z")
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? ---
**Author:** ![mythxAHIR](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mythxahir/32/39985_2.png) [@mythxAHIR](https://forum.knime.com/u/mythxAHIR)\ **Post date:** [May 23, 2022, 7:37am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/3 "2022-05-23T07:37:24Z")
Yes. No, I want to add sheet names as column name in all sheet. ---
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [May 23, 2022, 7:54am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/4 "2022-05-23T07:54:17Z")
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](https://forum-cdn.knime.com/uploads/default/original/3X/9/c/9cefec8e254a33ace84e2d42b2a670ee4a69f257.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/2/923a585a54951fc49d81285e8205f4d761d07895.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/6/06c97fe85441b36c4478b8fe380fb909bbceeaf3.png) You’d want to produce something like this? … ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/d/cd3bfcea2166b6e8f73719b142b364a113a175fe.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/d/6db3ab8e5534e8f2d47a13ccc1b2b716ccae10fb.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/e/3ed0c087c578cb8e592dc62489651b57fab0534d.png) 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. ---
**Author:** ![mythxAHIR](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mythxahir/32/39985_2.png) [@mythxAHIR](https://forum.knime.com/u/mythxAHIR)\ **Post date:** [May 24, 2022, 12:41pm UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/5 "2022-05-24T12:41:02Z")
Yes, But all i want to do in KNIME. ---
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [May 24, 2022, 2:29pm UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/6 "2022-05-24T14:29:10Z")
@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](https://kni.me/w/zDsvqAhP4BgUr37R) that you would need to combine the elements accoring to your needs: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/3/236d1865958fe7610eae86525f71bbbd728eddda.png) > **[Read the sheet names from an existing excel file and add the sheet name as a...](https://hub.knime.com/mlauber71/spaces/Forum/latest/2022/kn_forum_43376_excel_sheet_names_as_column~X581zhevHB312F5-)** > > Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file ---
**Author:** ![Iris](https://forum-cdn.knime.com/user_avatar/forum.knime.com/iris/32/14_2.png) [@Iris](https://forum.knime.com/u/Iris)\ **Post date:** [May 25, 2022, 9:53am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/7 "2022-05-25T09:53:59Z")
3 posts were split to a new topic: [HTML Table Extracting](https://forum.knime.com/t/html-table-extracting/43475) ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [June 1, 2022, 9:54am UTC](https://forum.knime.com/t/i-want-solution-of-this-problem/43376/8 "2022-06-01T09:54:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.