Excel COM objects or OleDb

I need to display a lot of cells from a lot of excel files to huge of text label, so what is the best way (Excel COM objects or OleDb), and how can I do?

Please help me!
JameMeckAsked:
Who is Participating?
 
k_swapnilCommented:
If you can save you excel file as a .csv, then I would suggest you to go with normal file handling techniques. This will save a lot of memory which is used while dealing with COM libraries like Excel etc.

else you can go ahaed with the links suggested by Senz79 for Excel automation.

Thx!
Swaps...
0
 
Miguel OzConnect With a Mentor Software EngineerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.