// Create a new workbook Workbook workbook = new Workbook(); IWorksheet activeSheet = workbook.getActiveSheet(); // Fill data Object[][] testData = new Object[][] { {"Fruit", null, null, "Fruit Total", "Vegetables", null, null, null, "Vegetables Total", "Grand Total"}, {"Canada", "Germany", "New Zealand", null, "Australia", "Germany", "United Kingdom", "United States", null, null}, {7431d, null, null, 9848d, null, null, null, null, null, 9848d}, {8384d, 8250d, 6906d, 24157d, null, null, null, null, null, 24157d}, {null, null, null, null, null, 2626d, null, null, 2626d, 2626d}, {null, null, null, null, 9062d, null, 8239d, 7012d, 24313d, 24313d}, {null, null, null, null, null, 1903d, null, 4270d, 6173d, 6173d}, {null, null, null, 3610d, null, null, null, null, null, 3610d}, {15815d, 8250d, 6906d, 30971d, 9062d, 4529d, 8239d, 11282d, 33112d, 64083d} }; IRange dataAndHeader = activeSheet.getRange("$A$1:$J$9"); dataAndHeader.setValue(testData); // Add borders IBorders borders = dataAndHeader.getBorders(); borders.setLineStyle(BorderLineStyle.Thin); borders.setThemeColor(ThemeColor.Dark1); borders.setTintAndShade(-0.499984740745262); // Use center across selection in the header row IRange header = activeSheet.getRange("$A$1:$J$1"); header.setHorizontalAlignment(HorizontalAlignment.CenterContinuous); activeSheet.getColumns().autoFit(); activeSheet.getPageSetup().setOrientation(PageOrientation.Landscape); // Save to a pdf file workbook.save("CenterAcrossSelection.pdf");
// Create a new workbook var workbook = Workbook() val activeSheet: IWorksheet = workbook.getActiveSheet() // Fill data val testData = arrayOf(arrayOf("Fruit", null, null, "Fruit Total", "Vegetables", null, null, null, "Vegetables Total", "Grand Total"), arrayOf("Canada", "Germany", "New Zealand", null, "Australia", "Germany", "United Kingdom", "United States", null, null), arrayOf(7431.0, null, null, 9848.0, null, null, null, null, null, 9848.0), arrayOf(8384.0, 8250.0, 6906.0, 24157.0, null, null, null, null, null, 24157.0), arrayOf(null, null, null, null, null, 2626.0, null, null, 2626.0, 2626.0), arrayOf(null, null, null, null, 9062.0, null, 8239.0, 7012.0, 24313.0, 24313.0), arrayOf(null, null, null, null, null, 1903.0, null, 4270.0, 6173.0, 6173.0), arrayOf(null, null, null, 3610.0, null, null, null, null, null, 3610.0), arrayOf(15815.0, 8250.0, 6906.0, 30971.0, 9062.0, 4529.0, 8239.0, 11282.0, 33112.0, 64083.0)) val dataAndHeader: IRange = activeSheet.getRange("\$A$1:\$J$9") dataAndHeader.setValue(testData) // Add borders val borders: IBorders = dataAndHeader.getBorders() borders.setLineStyle(BorderLineStyle.Thin) borders.setThemeColor(ThemeColor.Dark1) borders.setTintAndShade(-0.499984740745262) // Use center across selection in the header row val header: IRange = activeSheet.getRange("\$A$1:\$J$1") header.setHorizontalAlignment(HorizontalAlignment.CenterContinuous) activeSheet.getColumns().autoFit() activeSheet.getPageSetup().setOrientation(PageOrientation.Landscape) // Save to a pdf file workbook.save("CenterAcrossSelection.pdf")