Get specific columns from excel

[Phoenixxx]

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.

Regards,
Phoenix

[AshwinS2 (Ashwin S)]

Hi @Phoenixxx

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

Instead of spaces and blanks

Thanks
Ashwin S

[Phoenixxx]

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?

BR,
Phoenix

[pratikg (Pratik Gaikwad)]

Hi @Phoenixxx

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

SelectColumn.xaml (10.4 KB)

Thanks,
pratik

[ImPratham45 (Prathamesh Patil)]

@Phoenixxx per my understanding you want to extract only those 6 columns into 1 dt. If yes then
You can use the below
Dt.defaultview.Totable(False,“ColumnName1”,“ColumnName2”)
If not then can you explain it

[Phoenixxx]

Much appreciated @ImPratham45 . Thank you a lot!

[ImPratham45 (Prathamesh Patil)]

Welcome:blush: