Same column name in excel

[Gokul_Murali]

Hello guys i have an excel with 2 column having same name so iam getting an error
below mentioned

This is the excel column

So how can i avoid the error instead of renaming the file

[AJ_Ask]

Hi @Gokul_Murali

You can read it, but without headers property checked. When processing, you should skip 1st row.

–now this dt will have default column name as column1, column2,…
and if we want to access any column we can do that only with column index and it starts from 0 for first column like this inside the FOR EACH ROW loop
row(0).ToString
row(1).ToString\

Hope this helps

[jast1631 (Jagravi Trivedi)]

Read range workbook activity instead of this
Or use modern excel scope activity and use column index for getting your values in further steps @Gokul_Murali

[Gokul_Murali]

In for each i can use the index instead of column name but in the read range itself it is showing error

[Gokul_Murali]

Let me try that and will post the update here

[Gokul_Murali]

@jast1631

Even if i use the modern activity iam getting the same error.

[jast1631 (Jagravi Trivedi)]

What you can do is
Read without header
And have a build table activity and inside build table have the exact names and the table which is generated use this further to store the data which is read from excel file
Try this
Hope this helps

[AJ_Ask]

Remove tick of has herders

[Kismet_Tosun (Kısmet Tosun)]

@Gokul_Murali ,I have a workflow.

Firstly check it.

Given;

Result:

Just give path and sheetname

Some logs turkish.

[Gokul_Murali]

@Kismet_Tosun
@AJ_Ask
@jast1631

Thanks guys