How to read / write Excel file using C#?

**prasad.vk** · October 20th, 2010, 12:21 AM

I want to read values from excel file and the results should be printed in that same excel file.
I am using VS 2005 and MS Office 2003.

Thanks in Advance!

**Zaccheus** · October 20th, 2010, 05:22 AM

Is this article any help? http://support.microsoft.com/kb/302084

**Donald Green** · February 12th, 2013, 03:26 AM

You can use a 3rd party libraries to work with Excel files in C#. For example you may look for this .Net component.

**SummiRS** · February 20th, 2013, 03:38 AM

Workbook book = new Workbook();
book.LoadFromFile("..\\..\\test.xlsx",ExcelVersion.Version97to2003);
book.Worksheets[0].Range["A7"].Value = "abc";

I use an Excel library this project introduces: http://spreadsheet.codeplex.com/

**BioPhysEngr** · February 20th, 2013, 11:53 PM

My strategy has been to always avoid excel files like the plague and write CSV (or TSV) files (link) to work with programatically. Alas, that is not always an option. But if, in your case, it is: consider it!

**CM2013** · March 22nd, 2013, 05:55 PM

There are Excel libs that can be imported to the program - these are standard stuff that are available in the internet and need not be posted in forums unless theres something to discuss CG does not create any languages or software - the MSDN is for that. CG allows one to brainstorm a problem after you've tried.