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

Get Help & Discuss
1

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.

1 Like
2

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.

3

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?

4

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.

1 Like
5

thanks that was helpful