Get specific columns from excel

Hello my dear friends,

I have this INSANE issue. But first of all let me explain:

  1. I have and excel sheet with 88 columns
  2. I want to extract 6 columns from it with the specific names, because the order of the columns changes every time
  3. I have tried multiple methods method:
    3.1. dt.Select("[CN]" + “” + “[CN1]” + “” + …
    3.2 . dt.Select(“CN” + “” + “CN1” + “” + …
    3.3. dt.Select(“CN” + “CN1” + …
    3.4 And all the other tipes with ’ and “”

If you can please help me.

Apologies for the tag, because my version is 2018.2.3, but I didn’t find more relevant topic.


Hi @Phoenixxx

U can use dtout.Select("[Id]="+customerid.ToString+"").CopyToDatatable()

Instead of spaces and blanks

Ashwin S

Hey @AshwinS2

Thank you for the fast reply.

customerid is the name of the second column. it is not a variable.
I am missing something basic, I think?


Hi @Phoenixxx

You can use DataView to achieve this.
Sample code is attached for your reference.

SelectColumn.xaml (10.4 KB)


1 Like

@Phoenixxx per my understanding you want to extract only those 6 columns into 1 dt. If yes then
You can use the below :slight_smile:
If not then can you explain it

1 Like

Much appreciated @ImPratham45 . Thank you a lot!


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