Reading headers- excel

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

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
Regards,
LNV

@Anjali_Rani

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

Cheers

Hi All, its not resolving


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

@Anjali_Rani

Did you try with the above approach?

Also please check if there is an extra space after state of or before legal

Cheers

Yes, i tried, no extra spaces, but the thing is “of” is coming as an keyword. Maybe this causing an issue

@Anjali_Rani

Try printing the column name and checkhow it prints dt.Columns(index).ColumnName

Cheers

Have you tried my xaml file?

YES, that is also not working

image
, 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
Regards,
LNV

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
:slight_smile:

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.