# Continental package working on a multiplesheet output

**URL:** <https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164>\
**Category:** KNIME Analytics Platform\
**Tags:** continental\
**Created:** [June 15, 2022, 5:19am UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164 "2022-06-15T05:19:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tano](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/c2a13f/32.png) [@Tano](https://forum.knime.com/u/Tano)\
**Post date:** [June 15, 2022, 5:19am UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164/1 "2022-06-15T05:19:08Z")

</div>

Hi,  
I love everything about knime except for the formatting part (coloring, merging the cells … giving a title to the sheet …and so on) which often remains manual.  
Almost always in my worflows I condense multiple related reports on the same output excel sheet by adding them as sheets to the same file (and adding multiple data table input ports to Excel Writer).  
I understand that Continental would allow to automate formatting but it doesn’t work (or I can’t get it to work ) on an ouptut file that has multiple sheets, do you have any advice? Have you got the same problem?

---

<div class="post-metadata">

**Author:** ![wkhan](https://forum-cdn.knime.com/user_avatar/forum.knime.com/wkhan/32/20159_2.png) [@wkhan](https://forum.knime.com/u/wkhan)\
**Post date:** [June 15, 2022, 2:46pm UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164/2 "2022-06-15T14:46:21Z")

</div>

Hi @Tano,

Welcome to the forum. Have you tried using: [XLS Sheet Selector – KNIME Hub](https://kni.me/n/EKWXQwefWkJF0us8) to select the sheet you want to work with?

Regards,  
Wali

---

<div class="post-metadata">

**Author:** ![Tano](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/c2a13f/32.png) [@Tano](https://forum.knime.com/u/Tano)\
**Post date:** [June 16, 2022, 6:20am UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164/3 "2022-06-16T06:20:41Z")

</div>

Hi @wkhan , no I do not.  
Please, can you share an example of this application node with some Continental Node that leads to formatting an Excel with multiple sheet? Thank you!

---

<div class="post-metadata">

**Author:** ![wkhan](https://forum-cdn.knime.com/user_avatar/forum.knime.com/wkhan/32/20159_2.png) [@wkhan](https://forum.knime.com/u/wkhan)\
**Post date:** [June 16, 2022, 3:53pm UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164/4 "2022-06-16T15:53:21Z")

</div>

If you scroll to the bottom of the page I linked you will see a few example workflows. Here is one in particular:

> **[23\_XLS\_MultipleSheetsViaLoop – knime](https://hub.knime.com/knime/spaces/Examples/latest/99_Community/05_Continental_Nodes_for_KNIME/02_XLS_Formatter/01_Tutorials/23_XLS_MultipleSheetsViaLoop~n_ipdUY8BCC-NwO7)**
>
> This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow directory for details.

Regards,  
Wali

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [September 14, 2022, 3:53pm UTC](https://forum.knime.com/t/continental-package-working-on-a-multiplesheet-output/44164/5 "2022-09-14T15:53:21Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
