My code works like this I load an Excel worksheet into a datatable this table is then loaded into my datagridview control. If I leave autogeneratetables = true it creates extra columns. So I set it to false but now it doesn't load anything. Is there not away to bind datatable colunms to the dataviewgrid by column index instead of by name. I need it to work this way because the spreadsheet column index will always be the same but the name of the header column in that sheet does change.
If some code needs to be submitted just let me know. Thanks.