How can i choose the column name

[Cathrine]

i have a question. when i try to read datatable from the excel and use “select” to choose data, i meet the exception"Cannot find column [证件号码]."，but actually it exists

so how can i choose the column name? thanks a lot

[Manjuts90]

@Cathrine There might be space before or after the column name. Try once by giving space after or before once.

Before using above options try this please use System.String inside single quote like ‘System.String’ in the select statement.

[HareeshMR (Hareesh Madasi)]

Hi @Cathrine,

Assuming your data table as “dt”.
If you want to get particular column, try this
→ dt.Columns(“your column Name”)

Regards,
Hareesh