Excel range adress is Null or Emty error

[sekhar_talasila]

Hi Team
Can any help me why am getting below error while adding sum of 3 columns into 4th column !

[fernando_zuluaga]

Hi @sekhar_talasila

Looks like you are trying to access an index that does not exist in your datatable, remember that datatables always start from index 0, for columns and rows, so your index to sum should be (0,1,2) and write in the index 3

Regards!

[sekhar_talasila]

Hi @fernando_zuluaga index correct only(5) , in above screenshot its visible from index 2 only.

[fernando_zuluaga]

Well, when using write cell we should pass the address of the cell that we want to write, and you are passing the index, not the address. an address should be (“A1”) and you are passing (1)

you can sum all the values and store in the datatable at the current index, and then just write back the data

or else, instead a for each row activity, use the For Each Excel Row activity, sum the values and write the result in the current index

Regards

[sekhar_talasila]

SOrry to bother you can you make program and share for this activity counting first 3columns value and type into 4th column for the respective row.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Hi

You can try below steps
1.Use Excel Process Scope
2.Use Excel File
3. Use For Each Excel Row
4. Inside For each use Write Cell Activity

Properties for Write cell

Cint(CurrentRow.ByField("KKK").ToString)+Cint(CurrentRow.ByField("LLL").ToString)+Cint(CurrentRow.ByField("MMM").ToString)

Excel.Sheet("Sheet1").Cell(CurrentRow.ByField("Total").Address)

Hope this helps

Regards

[sekhar_talasila]

Thank you so much bro it really worked