//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); // Auto fit column width of range 'A1' worksheet.getRange("A1").setValue("Grapecity Documents for Excel"); worksheet.getRange("A1").getColumns().autoFit(); //Auto fit row height of range 'B2' worksheet.getRange("B2").setValue("Grapecity"); worksheet.getRange("B2").getFont().setSize(20); worksheet.getRange("B2").getRows().autoFit(); //Auto fit column width and row height of range 'C3' worksheet.getRange("C3").setValue("Grapecity Documents for Excel"); worksheet.getRange("C3").getFont().setSize(32); worksheet.getRange("C3").autoFit(); //save to an excel file workbook.save("AutoFit.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) // Auto fit column width of range 'A1' worksheet.getRange("A1").value = "Grapecity Documents for Excel" worksheet.getRange("A1").columns.autoFit() //Auto fit row height of range 'B2' worksheet.getRange("B2").value = "Grapecity" worksheet.getRange("B2").font.size = 20.0 worksheet.getRange("B2").rows.autoFit() //Auto fit column width and row height of range 'C3' worksheet.getRange("C3").value = "Grapecity Documents for Excel" worksheet.getRange("C3").font.size = 32.0 worksheet.getRange("C3").autoFit() //save to an excel file workbook.save("AutoFit.xlsx")