private static bool isStyleExists(string name) { Excel.Workbook workbook = (Excel.Workbook)Globals.ThisAddIn.Application.ActiveWorkbook; Excel.Styles styles = workbook.Styles; bool found = false; for (int i = 1; i <= styles.Count; i++) { if (styles[i].Name == name) { found = true; break; } } return(found); }
private void DoMyExcelStuff() { Excel.Application excelApplication = new Excel.Application(); Excel.Workbooks books = excelApplication.Workbooks; Excel.Workbook wBook = books.Add(""); Excel.Worksheet wSheet = (Excel.Worksheet)wBook.ActiveSheet; Excel.Styles styles = wBook.Styles; Excel.Style columnHeader = styles.Add("ColumnHeader"); columnHeader.Font.Size = 12; columnHeader.Font.Bold = true; excelApplication.Range["A1"].Value = "Name"; excelApplication.Range["A1"].Style = columnHeader; wBook.SaveAs(@"c:\Temp\tst" + DateTime.Now.ToString("mmss") + ".xlsx"); // No need for Marshal.ReleaseComObject(...) // No need for ... = null excelApplication.Quit(); }