# How do I concatenate an excel file Tabs, using loop flow variable

**URL:** <https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162>\
**Category:** KNIME Analytics Platform\
**Tags:** flow-variables\
**Created:** [February 9, 2024, 2:09pm UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162 "2024-02-09T14:09:14Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![RamyHussein](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ramyhussein/32/60553_2.png) [@RamyHussein](https://forum.knime.com/u/RamyHussein)\
**Post date:** [February 9, 2024, 2:09pm UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/1 "2024-02-09T14:09:14Z")

</div>

Dears,  
I have a file an **Excel on one SharePoint** contains many tabs, and each tab have the same Column.  
I need to concatenate all tabs in **another SharePoint List** different site & it is List not excel.  
How can i use Loop for this thing? would you please share screenshot about flow?

---

<div class="post-metadata">

**Author:** ![knimediger](https://forum-cdn.knime.com/user_avatar/forum.knime.com/knimediger/32/19981_2.png) [@knimediger](https://forum.knime.com/u/knimediger)\
**Post date:** [February 10, 2024, 10:35pm UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/2 "2024-02-10T22:35:46Z")

</div>

@RamyHussein

Here’s a quick first idea how to solve your requirement:

1. Read in all tabs (one by one)
2. Use the Concatenate Node [Concatenate – KNIME Community Hub](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.append.row.AppendedRowsNodeFactory) to bring all tables into one

---

<div class="post-metadata">

**Author:** ![hmfa](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/9fc29f/32.png) [@hmfa](https://forum.knime.com/u/hmfa)\
**Post date:** [February 10, 2024, 10:53pm UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/3 "2024-02-10T22:53:56Z")

</div>

Hi.  
Some ideas.

Look at this examples to read your excel file from sharepoint

> **[Microsoft SharePoint Data Access – knime](https://hub.knime.com/knime/spaces/Examples/01_Data_Access/06_ZIP_and_Remote_Files/07_Microsoft_Sharepoint_Data_Access~DWEfzzxqw197SKyQ/current-state)**
>
> This workflow demonstrates the usage of the Microsoft Authentication and SharePoint Online Connector nodes to connect to your personal SharePoint file system. …

Read all sheets

> [@Knime 4.5.1 how to read all sheet in excel](https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135/5):
>
> @bruno29a ,yes, You are right, 1,data from office 365 one drive(sharepoint) file. 2,So I don’t know how to set excel read node. no input data.

And write as list

> **[SharePoint Online List Writer](https://hub.knime.com/knime/extensions/org.knime.features.ext.office365.sharepointlist/latest/org.knime.ext.sharepoint.lists.node.writer.SharepointListWriterNodeFactory)**
>
> This node writes a KNIME table to a SharePoint list. Notes: Writing tables with more than a few hundred rows can take long time. Overwriting an existing table …

Br

---

<div class="post-metadata">

**Author:** ![RamyHussein](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ramyhussein/32/60553_2.png) [@RamyHussein](https://forum.knime.com/u/RamyHussein)\
**Post date:** [February 12, 2024, 10:35am UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/4 "2024-02-12T10:35:47Z")

</div>

Thanks, i found the solution here  
[https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135?u=ramyhussein](https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135)

---

<div class="post-metadata">

**Author:** ![RamyHussein](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ramyhussein/32/60553_2.png) [@RamyHussein](https://forum.knime.com/u/RamyHussein)\
**Post date:** [February 12, 2024, 10:36am UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/5 "2024-02-12T10:36:27Z")

</div>

Yes i did that before,  
but i finally find that loop here  
[https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135?u=ramyhussein](https://forum.knime.com/t/knime-4-5-1-how-to-read-all-sheet-in-excel/40135)

---

<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:** [February 19, 2024, 10:37am UTC](https://forum.knime.com/t/how-do-i-concatenate-an-excel-file-tabs-using-loop-flow-variable/77162/6 "2024-02-19T10:37:00Z")

</div>

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