Reading an excelfile

J

Jorgen

What is the most efficient way to retrieve Excel data in C# ?
I’ve found three alternatives so far:
• ADO.NET
• OpenXML
• Interop

(It is also necessary to retrieve the color formatting in excel)

TIA
- Jorgen
 
C

Cindy M.

Hi =?Utf-8?B?Sm9yZ2Vu?=,
What is the most efficient way to retrieve Excel data in C# ?
I’ve found three alternatives so far:
• ADO.NET
• OpenXML
• Interop

(It is also necessary to retrieve the color formatting in excel)
Click to expand...
Assuming the Excel 2007 XML file type, OpenXML would be most
efficient.

A data base connection will not return any formatting information,
only data.

Interop will be (comparatively) very slow.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :)
 

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

a problem with variable number of parameters. 1
Help with conditional formatting in Excel 2010 8
How to use a variable as an argument in .FliiDown 4
Excel 2007 not calculating margins & print area correctly 6
variable length arguments 4
Auto copy data rows between sheets depending on date entry 3
Add 31 records w/ consecutive dates w/ command button? 2
Change Gradient Fill Colors of Bar Chart data points 2

Top