public void Format() { MyFormat.FormatHeaders(workbook, true); MyFormat.FormatTableDatas(workbook); MyFormat.SetBorders(workbook); MyFormat.PageSetups(workbook, verfahrensname); ZE.Columns["C"].Hidden = true; ZE.Columns["F:H"].Hidden = true; ZE.Columns["L:N"].Hidden = true; ZE.Columns["O"].Delete(); }
public void Format() { Globals.ThisAddIn.Application.ScreenUpdating = false; Excel.Worksheet ws = workbook.Worksheets[workbook.Worksheets.Count]; MyFormat.FormatHeader(ws, true); MyFormat.FormatTableData(ws); MyFormat.SetBorder(ws); MyFormat.PageSetup(ws, sheetName); Globals.ThisAddIn.Application.ScreenUpdating = true; }