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
@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.
Assuming your data table as “dt”.
If you want to get particular column, try this
→ dt.Columns(“your column Name”)