Writing to excel using C#

Use the Interop.Excel, you can do everything

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11/html/xlhowConstants_HV01049962.asp

http://www.c-sharpcorner.com/Code/2002/Jan/CreateExcelSheetGAG.asp

ThE_lOtUs at 2007-9-3 >

There are several options you can use to manipulate an excel file.

The first and possibly simplest is to use COM integration to manipulate an excel spreadsheet programmatically. I have a co-worker who does this with Visio.

I also found a library on CodeProject that does excel exporting for you (you hand it a DataTable and it exports it to Excel). I haven't tried it myself, but it will likely work.

Finally, you can find the Excel format on the internet and code your own library to read and write from/to Excel.

If the codeproject library works like it says, it will probably be the easiest method to use.

ivolved_Mike_Brown at 2007-9-3 >

In references, right click, add reference

Choose the COM tab

Choose Microsoft Excel 10.0 Object Library

ThE_lOtUs at 2007-9-3 >

Excel.Application excelApp = new Excel.Application(); string myPath = @"C:\Excel.xls"; excelApp.Workbooks.Open(myPath); int rowIndex = 1; int colIndex = 1; excelApp.Cells[rowIndex, colIndex] = "First"; excelApp.Visible = true;

That will open the workbook named Excel.xls located in your C:\ directory. rowIndex controls which row you're in and assumingly so, colIndex controls the column you are in. The code will place the word "First" into the workbook in cell "A1". The visible method tells your program to make "excelApp" visible. You can of course save/close the workbook without displaying it first.

mEt at 2007-9-3 >