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!
Printable View
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!
Is this article any help? http://support.microsoft.com/kb/302084
You can use a 3rd party libraries to work with Excel files in C#. For example you may look for this .Net component.
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/
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!
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.