Reading from Excel (Range into multidimensional Array)

Houman

Hello,

How would I read from an Excel sheet and load the marked selection (Area) into an multidimensional array? A column in Excel could itself be a multi dimensional array since it would contain more than just one value.

The idea (not sure how good or bad this is) is right now is to do a for loop through all the Excel.Area (selected fields) and add the content of that field to the multi dimensional array. Since the multi dimensional array is of type object[,] and therefore non-generic there is no convenient add() method to it. All of it needs to be done manually.

Any idea if this approach is ok or if it could be done more efficientlty?

Many Thanks,
Houman

2 Replies

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

Suchit Khanna17y ago
The idea is somewhat right but in case of large excel sheets(containing large data), performance will take a hit becoz of for loops.... So If you have a fixed template of Excel Documents to be processed that would not change better idea would be to go directly and process the excel file using range function else if you have excel sheets with no fixed template and large amount of data to be processed better go for SELECT query specifying the range of excel sheet to be queried and taking the data in DataSet for processing....
Suchit Khanna17y ago
The idea is somewhat right but in case of large excel sheets(containing large data), performance will take a hit becoz of for loops.... So If you have a fixed template of Excel Documents to be processed that would not change better idea would be to go directly and process the excel file using range function else if you have excel sheets with no fixed template and large amount of data to be processed better go for SELECT query specifying the range of excel sheet to be queried and taking the data in DataSet for processing....