when i try to convert a particualr column value to string i am getting error saying
“Compiler error(s) encountered processing expression “row(Fisrt). ToString”. Option Strict On disallows late binding.”
@RaviTejaKuna try like below once.
i am still getting the error saying Compiler error(s) encountered processing expression “convert.ToString(row(First))”.
Option Strict On disallows late binding.
Could you please upload your workflow ? So that i could get what exactly you want to do.
could you please upload more informative screenshot or it would be really better if you can upload file.
because with this i really could not able to understand anything
So if I understand you correctly you have excel sheet which has a bunch of data in rows. You need to convert the data given in the rows to string.
Is this correct?
If yes, what is the type of data in the row? Also can you paste the exact expression that you are using to convert to string?
this is the solution for your query. If your expression is “row(Fisrt). ToString" then you need to assign a numeric value to the row index.
try this workflow,
it converts whole column to string
convert particular value to string of datatable
if your columnName is “First” then it should be mentioned as follows:
row(“First”).toString …You were missing this so you may faced and error or other wise u can use the rowIndex to fetch the value.
the code above will return string of a row with each column delimited(separated) by a comma, you can use string split activity, set separator to comma and index the column you want from the array returned by the string split activity.