excelApp = new Microsoft.Office.Interop.Excel.Application(); excelBook = excelApp.Workbooks.Add(XlSheetType.xlWorksheet); excelWorksheet =(Worksheet)(excelBook.Worksheets[1]); excelApp.Visible = true; excelWorksheet.DisplayRightToLeft = true; rng1 = excelWorksheet.get_Range("A1", "A1"); rng1.Value2 = "__ID__"; rng1.Font.Bold = true; rng2 = excelWorksheet.get_Range("B1", "B1"); rng2.Value2 = "ID"; rng2.Font.Bold = true; rng3 = excelWorksheet.get_Range("C1", "C1"); rng3.Value2 = "Title"; rng3.Font.Bold = true; i = 1; foreach (DataRow r in ds.Tables[0].Rows) { i++; string s = i.ToString(); Range r1 = excelWorksheet.get_Range("A" + s, "A" + s); r1.Value2 = r[0].ToString(); Range r2 = excelWorksheet.get_Range("B" + s, "B" + s); r2.Value2 = r[1].ToString(); Range r3 = excelWorksheet.get_Range("C" + s, "C" + s); r3.Value2 = r[2].ToString(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)