Link to home
Start Free TrialLog in
Avatar of JameMeck
JameMeckFlag for United States of America

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Senz79
Senz79
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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...
SOLUTION
Avatar of Miguel Oz
Miguel Oz
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial