# Export to multiple (different) cells in Excel

**URL:** <https://forum.dynamobim.com/t/export-to-multiple-different-cells-in-excel/97591>\
**Category:** Revit\
**Tags:** revit, python, dynamo\
**Created:** [January 29, 2024, 12:08pm UTC](https://forum.dynamobim.com/t/export-to-multiple-different-cells-in-excel/97591 "2024-01-29T12:08:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sander.nalesMRTG9](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@sander.nalesMRTG9](https://forum.dynamobim.com/u/sander.nalesMRTG9)\
**Post date:** [January 29, 2024, 12:08pm UTC](https://forum.dynamobim.com/t/export-to-multiple-different-cells-in-excel/97591/1 "2024-01-29T12:08:13Z")

</div>

I want to export sheet data to an excel file. But the function Data.ExportToExcel writes a zero-length string to a cell when no data is exported. For Example:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/4/64a3d9ba373c552079f1cd0bf7fe2e3989a0a372.png)  
Here I import a list on row 5: [“A long string”, “”, Data, Data]  
But I also want to import the Name and date at the top in column 2.

The problem is that after dynamo writes the data, Excel will translate “” to a zero-Length value.  
Now the long string is not readeble because it gets overwrited.  
Does some one have a sollution to this? Changing the tamplate is not a option.

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [January 29, 2024, 12:11pm UTC](https://forum.dynamobim.com/t/export-to-multiple-different-cells-in-excel/97591/2 "2024-01-29T12:11:38Z")

</div>

> [@sander.nalesMRTG9](#):
>
> Does some one have a sollution to this?

offhand I have two.

I believe the OpenXML nodes for excel interoperability support exporting to a particular starting cell. So you can use the function a few times and not overwrite the previous data.

You could also write out to a new sheet and read the data into the correct location by referencing the data in the new sheet.
