# Create data table for every sheet

**URL:** <https://forum.uipath.com/t/create-data-table-for-every-sheet/198190>\
**Category:** Academy Feedback\
**Tags:** datatable, question, excel, activities\
**Created:** [28. Februar 2020 um 08:07 UTC](https://forum.uipath.com/t/create-data-table-for-every-sheet/198190 "2020-02-28T08:07:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AditiGandhi](https://avatars.discourse-cdn.com/v4/letter/a/ad7895/32.png) [@AditiGandhi](https://forum.uipath.com/u/AditiGandhi)\
**Post date:** [28. Februar 2020 um 08:07 UTC](https://forum.uipath.com/t/create-data-table-for-every-sheet/198190/1 "2020-02-28T08:07:51Z")

</div>

Hello,

I have an excel with multiple number of sheets. I want to read the excel and store the data of every sheet into different datatable. The name of datatable should be in sequence.  
I want this to be done in for each loop. I am using for each loop for every sheet but when i use read range to read I am not able to create datatable with the sheetname.

For example : I have Excel.xlsx with 3 sheets namely 2014,performance,result.  
I want three datatable with names dt1,dt2,dt3.

---

<div class="post-metadata">

**Author:** ![supermanPunch](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/supermanpunch/32/133652_2.png) [@supermanPunch](https://forum.uipath.com/u/supermanPunch)\
**Post date:** [28. Februar 2020 um 09:49 UTC](https://forum.uipath.com/t/create-data-table-for-every-sheet/198190/2 "2020-02-28T09:49:52Z")

</div>

@AditiGandhi I don’t think we can create a Dynamic Datatable based on the number of Sheets, We can reuse one Datatable but not Create another Datatable

Have you Tried using List Of Datatable where you can add the Datatable after you read each Sheet, and I think you might be able to Access it using ListVar(0) as DT1, ListVar(1) as DT2 and so on

I haven’t tried it, But i think it’s possible 😅

---

<div class="post-metadata">

**Author:** ![Priyanka\_Ramesh](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/priyanka_ramesh/32/87375_2.png) [@Priyanka\_Ramesh](https://forum.uipath.com/u/Priyanka_Ramesh)\
**Post date:** [28. Februar 2020 um 10:17 UTC](https://forum.uipath.com/t/create-data-table-for-every-sheet/198190/3 "2020-02-28T10:17:20Z")

</div>

I couldn’t create the name as Dt1,dt2,dt3 etc . But Kept as Dynamic .[Excel\_SHeet\_perDT.xaml](https://forum.uipath.com/uploads/short-url/wqgxkiVWwKpz0rkJ2YpDS5SubnK.xaml) (16.7 KB) [Sample.xlsx](https://forum.uipath.com/uploads/short-url/8KInEiMBBoVJWctUThmqYvpSimM.xlsx) (9.0 KB)