How to open Excel 2003 using .NET 3.5?

Question

I'd like to open EXCEL 2003 from a .NET 3.5 application and manipulate each cell in the Excel sheet. Any one does that?

Answer 1

Not sure what you mean by "manipulate". If you want to transfer data to the cells, this Microsoft article should get you going:

http://support.microsoft.com/kb/306023

Answer 2

There are a number of ways to do this.

You can use COM Interop to control Excel and open and manipulate a spreadsheet. This should be avoided where possible.

You can use OleDb to open an Excel spreadsheet as an SQL database. This will be fast and efficient, but might not be powerful enough for you. Example

You can buy a third-party Excel component, from vendors like Aspose or SyncFusion. This will cost money.