//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); sheet.getRange("F2, F4").setValue("This is a test string of overflow"); sheet.getRange("F6, F8").setValue("This is a test string of overflow with right alignment"); sheet.getRange("F6, F8").setHorizontalAlignment(HorizontalAlignment.Right); sheet.getRange("D8, H4").setValue(123); //Other settings sheet.getRange("A1:J10").getBorders().setLineStyle(BorderLineStyle.Thin); //save to an pdf file workbook.save("Overflow.pdf");
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) sheet.getRange("F2, F4").value = "This is a test string of overflow" sheet.getRange("F6, F8").value = "This is a test string of overflow with right alignment" sheet.getRange("F6, F8").horizontalAlignment = HorizontalAlignment.Right sheet.getRange("D8, H4").value = 123 //Other settings sheet.getRange("A1:J10").borders.lineStyle = BorderLineStyle.Thin //save to an pdf file workbook.save("Overflow.pdf")