I am working on Excel, and have to read headers but this header is not readable.
Hi @Anjali_Rani ,
Please check range
Or share your file, I will test
Robot can read all type header
I created a file have header same you
But no error
test.xaml (12.2 KB)
You can try, hope it help
Can you please tell what do you mean it is not readable?
Did you try to access the column as below?
CurrentRow("State of" + vbCrlf + "Legal Residence").ToString
Did you try with the above approach?
Also please check if there is an extra space after state of or before legal
Yes, i tried, no extra spaces, but the thing is “of” is coming as an keyword. Maybe this causing an issue
Try printing the column name and checkhow it prints
Have you tried my xaml file?
YES, that is also not working
, this the printed name,
its written in excel like: State Of(Alt+Enter) Legal residense
Yes, my file is same
1.xlsx (8.6 KB)
Can you share your file?
I will test it
Got It, thank you it worked.
Actually , while applying this in if condition it was went on 2nd line
,So I thought it’s wrong. But it’s working.
These 2 problems are similar, but this is different from your original question
this step, what is your requirement?
Looks like the picture was taken with my phone, I can’t see it clearly
My requirement is , i have to apply if condition in multiple column values, if that column value is not blank then proceed,
But while putting this column name , its went on second line and throwing error as
“String constant must end with double quote”
Hi @Anjali_Rani ,
I tried check value of it’s not empty
You can use If, check row.Item(“Sate of
Legal Residence”).ToString is not empty
Is what I understand the same as your request?
test.xaml (14.4 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.