How to set Excel header as Datatable column name

[kaliraj1982 (Kali Raj)]

How to set Excel header as Datatable column name ?

If I choose add header and I could not get the records based on column name. Its saying column nname not belongs to table

If I remove add header and now Datatable columns comes as below column0 column1 column2 …

I need excel header as column in datatable

[Jan_Brian_Despi]

Hi @kaliraj1982,

Are you using the Read Range activity?

[aisling.bai]

@kaliraj1982

Its saying column nname not belongs to table

Hi @kaliraj1982，

“Its saying column nname not belongs to table ” ----- Have you checked the column name you used in other activity?
Assuming you need to use it in ‘Write Line’ activity, like row(“column name”), please check the words spelling or any space.

Thanks,
Aisling

[kaliraj1982 (Kali Raj)]

Yes.

[kaliraj1982 (Kali Raj)]

But, I need to get columns dynamically. Because, Sometimes we are having nearly 100 columsn in excel. So its not feesible to do like that…

[Jan_Brian_Despi]

Please try checking the column names if it matches. Sometimes a single space can make a difference
Or you can use column indexes

[kaliraj1982 (Kali Raj)]

Yes. Checked. Same issue. Actually, I if remove add header and now I can get values based on Column0,column1 like that. But, since its columns are changing dynamicaaly. Thats not worked out.

[Jan_Brian_Despi]

Can you send the excel file?
If it contains sensitive information, please replace it with dummy values

[kaliraj1982 (Kali Raj)]

Actually, I am working in client VDI. I am not supposed to do the same. Here the excel columns positioning also not same always. Like it will come like below

1. ID Name Prodcut groupcode materioal code Bank location code amount
2. Bank location code amount ID Name Prodcut groupcode materioal code
3. Amount ID Name Bank location code Prodcut groupcode materioal code

Nearly 100 columns . Everytime changing the postions.

[kaliraj1982 (Kali Raj)]

Datatable using LINQ

1.Read Excel(3 Sheets - PrevMonth(Columns: ID,Product,Citya and Sales), CurrentMonth(ID,Product,Citya and Sales) and Comments(ID,Product,City and Commets). 2.Need to store all in Datatables. 3.Concatenate Columns ID,Product,City as “Product Details” Column and Sum Sales GroupBy Product Details and stored in “Amount” Column. 4.Remove duplicates. 5.Compare Previous month sales Amount and Current Month Sales amount. Please find attached excel for the more infoSample_Input_Data.xlsx (14.9 KB)

I shared dummy records in above post. Please check

[neethulg (Neethu)]

1. Try to copy paste the column name in excel in a notepad.
2. now paste the column name you provided in the code just below the pasted column name from excel. It may be because of a small space which is not much noticeable.

Also try manually changing the column names without any space. I mean to check whether the space in between the column names is creating the issue. change manually the column names in excel like below and try your operation( If the columns names are all separate then ignore)

Your columns : 1. ID Name Prodcut groupcode materioal code Bank location code amount (10 columns)

1. ID Name Prodcut_groupcode materioal_code Bank_locationcode amount (6 columns)