Loading

Column from Excel Sheet

Angelina Erin

Hi

Can anyone tell me if we are using ADO.NET then can we we get more than 255 column from Excel sheet.If yes then how?

Thanks in Advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs15y ago
Use of ADO .Net cannot affect how Excel works. Spreadsheets are not designed to be databases. Due to the design of spreadsheets, users of spreadsheets could become highly irritated by spreadsheets with many columns. Computers are much faster now than when spreadsheets were designed, so the excessive processing is less likely to be a problem but it is logical to limit the number of columns.