New user help and Excel read question (Interop and OleDb)
 

Forgive me I'm a new user. I can't find how to search the newsgroups
only the forums.

I'm trying Excel Interop to read Excel spreadsheets using C#.
I'm "simply" loading the entire contents of the spreadsheet into RA
for manipulation.
All cell contents are loaded as strings, into a string[][].
I realize I'm not making full use of this Interop like most of you are
but the choices seem limited for C#-Excel interaction.
Cycling through cell by cell is painfully slow!
What are my other options?

I also tried using OleDb which is incredibly fast, but it also seems t
"assume" data types and reads in long number strings a
scientific-format numbers!
Is there a way around this data-type assuming by OleDb?
OleDb really seems like the ideal application for reading my Exce
sheets, and the fastest.

Thanks everyone!

Mar

--
sporadicPosted from http://www.pcreview.co.uk/ newsgroup acces