Extracting a 2 dimensional array of values from a range of Excel Values.

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Is this possible? I am currently retrieving the values cell by cell
which is terrible in terms of execution speed. If I could access the
data with one call to the interop Excel object that would be great.

Am I correct in thinking that Value2 is a wrapper around a 2 dimesional
array?

Greg.
 
Hi, missed the rest of your post but...
You can access Excel using OLEDB ADO connections. Works great and you
can retrive a named range or sheet etc.
The excel files is returned as a DataSet object which can be accessed
with Tabels representing sheets, and rows as rows.
Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting single dimensional array out of two dimensional array 5
copy a 2 dimensional array to a range 2
2-dimensional array population 1
Unsolved: property Cells[row, col] (2 dimensional array as string) 5
copy 1 dimensional to 2 dimensional array with actual int values 3
High performance arrays in C# 16
2 dimensional array 3
Seach for a value in multi-dimensional array in 2005/2008 6

Back
Top