work with a lot column

[ekhtiari]

Summary of the issue

i have a file with 250 column
if i want to work with this file i must write a command for a column to read or write.
is there any way to read all of column with data and map to a class use by header or index?
thanks

[VahidN]

It has methods like LoadFromDataTable or LoadFromCollection.

P.S.
Don't forget this news.

[ekhtiari]

is there any way to read complete data from excel and map to class ? something like automapper ?

[VahidN]

Here is a sample about how to read an excel file. After reading it, use it, map it, etc.