CODEWITHSUNDEEP
.net-3.5excel-2003
Tim
Tim

Reputation: 11

How to open Excel 2003 using .NET 3.5?

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?

Upvotes: 1

Views: 345

Answers (2)

Buggieboy
Buggieboy

Reputation: 4696

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

Upvotes: 1

SLaks
SLaks

Reputation: 887225

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.

Upvotes: 0

Related Questions