# Writing Data in excel using template in specific cells from single row

**URL:** <https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507>\
**Category:** Get Help & Discuss\
**Created:** [June 29, 2018, 4:37am UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507 "2018-06-29T04:37:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shital\_Nair](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@Shital\_Nair](https://community.automationedge.com/u/Shital_Nair)\
**Post date:** [June 29, 2018, 4:37am UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507/1 "2018-06-29T04:37:57Z")

</div>

Hi,

I want read data from input excel and want to write it in excel template. In template the data should go in specific cell. The cells in template is not in single row, it is at different rows and columns like forms.

---

<div class="post-metadata">

**Author:** ![aditya.devi](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@aditya.devi](https://community.automationedge.com/u/aditya.devi)\
**Post date:** [July 30, 2021, 11:57am UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507/2 "2021-07-30T11:57:16Z")

</div>

Hi,  
You can use Microsoft Excel Writer,  
in **File & Sheet** tab  
for If output file exists select Use Existing file for writing.  
for If sheet exists in output file select write to existing sheet  
in \*\ ***Content** tab  
Start writing at cell pass cell number from previous step or from environment variable in which data needs to insert.

---

<div class="post-metadata">

**Author:** ![MukulJadhav](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@MukulJadhav](https://community.automationedge.com/u/MukulJadhav)\
**Post date:** [December 3, 2024, 7:28am UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507/3 "2024-12-03T07:28:45Z")

</div>

Hi,  
I have two columns in an Excel sheet: emp\_id and Total\_hours. I want to use the SUM formula in the Total\_hours column to calculate the total dynamically, regardless of the number of rows. How can I achieve this dynamically when the number of rows is unknown?

---

<div class="post-metadata">

**Author:** ![wllmdjngh](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.automationedge.com/wllmdjngh/32/952_2.png) [@wllmdjngh](https://community.automationedge.com/u/wllmdjngh)\
**Post date:** [December 3, 2024, 12:07pm UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507/4 "2024-12-03T12:07:18Z")

</div>

Hi MukulJadhav.  
Although you could manage Excel sheets through AutomationEdge, it is rather complex to implement.  
AET reads all data from a Sheet then writes to a different sheet in the same/other file where you can insert the data and formula you would like to use. When you open the file, it will recalculate if automatic calculation is activated.  
AET manages all data in memory which makes it ideal to manage large volumes of data efficiently.

---

<div class="post-metadata">

**Author:** ![MukulJadhav](https://avatars.discourse-cdn.com/v4/letter/m/d6d6ee/32.png) [@MukulJadhav](https://community.automationedge.com/u/MukulJadhav)\
**Post date:** [December 6, 2024, 5:48am UTC](https://community.automationedge.com/t/writing-data-in-excel-using-template-in-specific-cells-from-single-row/507/5 "2024-12-06T05:48:59Z")

</div>

thanks that was helpful