Reading headers- excel

Hi guys,
I am working on Excel, and have to read headers but this header is not readable.
Please help.

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


Hi All, its not resolving

Wen i am reading this column value individually , its coming like this


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 dt.Columns(index).ColumnName


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.
Thank you. :slight_smile:

These 2 problems are similar, but this is different from your original question

It’s giving an error in my original code , sorry, Can you please help me here

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.