Excel Column name is giving error


#1

when I am using Row(0).tostring in type into , its working fine but whenever I am wrtitng Row(“Title”).tostring. it is giving an error Column “title” does not exist in the table
can someone tell me how to solve this issue


#2

Hi @Amarjeet

If you are using Excel activity scope to open excel files or if you are dealing with csv files as well then in properties please make sure you have checked the add header property.

Let me know if you have any doubts on this.

Regards…!!


#3

Hi akshay,

I m using Excel scope and checked Add Headers Check Box. Still I m getting this error.


#4

Hi @Amarjeet

Are you sure that this column is named “Title”?

Use “row(0)” is a good practice. Think about use that.

Regards.