Read data from excel using loop

[Jess]

Hi,

I am trying to do a simple task in which I have to read two columns with three rows. I need to read the two cell values for eg A1 and B1, calculate their sum using calculator and store the sum in C1. I have tried hard but not able to do it. Can you help me in that. I have tried using loop but I am not getting any positive result.

Thanks in advance.

[water]

Why not let Excel do the job? Insert the formula into C1. 

[Jess]

Actually I am new to this Autoit and I have been assigned this task.

 

[Jess]

Doing this job for a single row is easy but when there are two or more rows, it is not working. Please help me.

[water]

Use _Excel_RangeWrite to write the formula to C1. Then use _Excel_RangeCopyPaste to copy C1 to all the other rows. 

[water]

You are overcomplicating things. Why use Calculator to add two values? Just do it in Excel (script incomplete):

_Excel_RangeWrite($oWorkbook, Default, "=SUM(A1:B1)", "C1", False) ; Write the formula to C1
_Excel_RangeCopyPaste($oWorksheet, "C1", "C2:C3") ; Copy the formula to C2 and C3

 

Edited August 9, 2017 by water