//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IRange rangeB1 = worksheet.getRange("B1"); rangeB1.setValue("The ShrinkToFit property is applied"); rangeB1.setShrinkToFit(true); //save to an excel file workbook.save("ShrinkToFit.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val rangeB1 = worksheet.getRange("B1") rangeB1.value = "The ShrinkToFit property is applied" rangeB1.shrinkToFit = true //save to an excel file workbook.save("ShrinkToFit.xlsx")