# Export to Excel using new feature "create table": bug with empty content

**URL:** <https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774>\
**Category:** Support\
**Created:** [July 12, 2022, 6:10pm UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774 "2022-07-12T18:10:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RJO](https://community.easymorph.com/user_avatar/community.easymorph.com/rjo/32/4084_2.png) [@RJO](https://community.easymorph.com/u/RJO)\
**Post date:** [July 12, 2022, 6:10pm UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774/1 "2022-07-12T18:10:38Z")

</div>

Hi,

I'm using this new feature because it has a double advantage : first if easymorph builds a table then you can easily build a visualisation based on the table, second it can be easily imported in Power BI Service which needs a table.

Problem : if the excel is empty. I have a first message :

 ![image](https://community.easymorph.com/uploads/default/original/2X/d/d7a8817778f5b06a29f669fa5c322b2fb552ede5.png)

Then there's a kind of lock :

 ![image](https://community.easymorph.com/uploads/default/original/2X/9/9443d7db6b4a92ca94e9146b7c4b829c0c19c47a.png)

And after Excel propose to delete the table :

 ![image](https://community.easymorph.com/uploads/default/original/2X/8/86b7c83170b1c327d113a85cb08a09949048a3dc.png)

Maybe you should avoid to create a table when there's no data to output ?

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [July 12, 2022, 7:31pm UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774/2 "2022-07-12T19:31:50Z")

</div>

Hi Romain,

I replicated this issue (except for the lock message). Thank you for pointing it out.

We are planning to fix it shortly.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [July 15, 2022, 1:08pm UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774/3 "2022-07-15T13:08:36Z")

</div>

Hi Romain,

We fixed this issue in the latest version. In Excel, when a user either deletes all the data rows in a table or creates a new table with only a headers row, the table is resized to have a single empty data row. So from now on, when the input dataset has columns but has no rows, EasyMorph will create an Excel table with a headers row and a single empty row.

You can get the latest version from our download page.

---

<div class="post-metadata">

**Author:** ![RJO](https://community.easymorph.com/user_avatar/community.easymorph.com/rjo/32/4084_2.png) [@RJO](https://community.easymorph.com/u/RJO)\
**Post date:** [July 19, 2022, 9:23am UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774/4 "2022-07-19T09:23:43Z")

</div>

Very good solution and seems to work, thanks !

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [July 19, 2022, 12:06pm UTC](https://community.easymorph.com/t/export-to-excel-using-new-feature-create-table-bug-with-empty-content/3774/5 "2022-07-19T12:06:05Z")

</div>

You are welcome!