/** * Create a new CT_Worksheet instance with all values set to defaults * * @return a new instance */ private static CT_Worksheet NewSheet() { CT_Worksheet worksheet = new CT_Worksheet(); CT_SheetFormatPr ctFormat = worksheet.AddNewSheetFormatPr(); ctFormat.defaultRowHeight = (15.0); CT_SheetView ctView = worksheet.AddNewSheetViews().AddNewSheetView(); ctView.workbookViewId = (0); worksheet.AddNewDimension().@ref = "A1"; worksheet.AddNewSheetData(); CT_PageMargins ctMargins = worksheet.AddNewPageMargins(); ctMargins.bottom = (0.75); ctMargins.footer = (0.3); ctMargins.header = (0.3); ctMargins.left = (0.7); ctMargins.right = (0.7); ctMargins.top = (0.75); return worksheet; }