Hi all knowledgable people,
can you please help with the question. Can’t find the solution on the forum.
I use Read cell activity, to get from one cell and write to another cell.
I get an error: “Read Cell Value: TypeConverter cannot convert from System.String.”
The source cell contains simple string value.
When I make it in 2 activities, it works.
But why it doesn’t with only one activty.
Thank you!
The read cell activity works to read the value and store in a variable.
The second one you used is correct.
The read cell and write cell activities should be use to read the value and write the value and there is an another option you can use copy paste activity.
Regards
You can use the below activity if required:
Source field provied the
CYDCPFile.Sheet("Schedule2").Cell("D13)
Destination should be given as
BCS_file.Sheet("Notebook").Cell("A5")
Regards
Hi @Volodymyr_Myshko The read cell value is used to retrieve particular cell value from the excel and the save to option is used for saving the particular cell value in a string variable.
If you need to read a particular cell value from excel then use read cell and store it in a variable and to write it in a new cell use write cell activity .
In write cell pass the string variable in what to write tab and the cell value in where to write.
Regards,
Sreejith S S
Thank you all. I got it, we better use read cell to store the value in variable, rather than save it in excel.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.