Read Excel Column without column name

Help Studio
, ,
1

I m trying to read excel column data. but i m also getting column name after fetching the data.

Below is the snap
image
Here English is the column name that i do not want to have in results.

Below is the linq query i have used

ReadDT.DefaultView.ToTable(False,“English”)

2

@tejas.kotharkar

It is just displaying the column name …but it is the name but not the value in the column…

Cheers

3

Yes, I would not like to have the column name(English) as i want to process the data in some application.

4

@tejas.kotharkar

Use this

string.Join(vbLf,dt.AsEnumerable.Select(Function(a) a("English").ToString).ToList)
5

@tejas.kotharkar

So what is the issue now?

It is only a column name and it is not coming in data also

Cheers

6

Hi @tejas.kotharkar

If you are using the Read Range workbook activity to read the excel and store in a datatable.
Then open the properties of Read Range workbook activity and uncheck the add headers option.

Then you didn’t get the headers in the datatable.

Hope it helps!!

7

Check the add headers box in read range activity after that you will not get the column name in your data.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.