Hi, I am trying to read the value of a single cell and store it in a string variable with the read cell activity (Workbook, not using excel application scope). However, entering any cell ID into the cell input will return “cannot convert from system.double”.
Is there any other activity that can do this
Welcome to the community!!
For the cell property of the read cell activity, you have to give the cell ID as a string.
if using a variable to hold the number it should be like
“A” + RowNumberVariable.ToString
Hi, thank you for the welcome!
im using a integer variable (sum) but still doesn’t work
The highlighted part in blue, here you have to mention the variable for the value you read… It cannot be string like that. Just add a variable to hold the value and it should work fine
The highlighted part in blue is the sheet name of the excel file and the sum is the row number im holding in a variable
oops sorry… I was just confused… ignore my previous comment…
Can I see the properties panel of the read cell activity?
HI Sir, I have fixed the error by changing my output variable from a string type to a double type and it worked.
Thank you as I looked at it again and realised.
Have a good day
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.