//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); ButtonCellType cellType = new ButtonCellType(); cellType.setText("Hello"); cellType.setButtonBackColor("Azure"); cellType.setMarginLeft(10); cellType.setMarginRight(10); worksheet.getRange("C5").setCellType(cellType); //save to an excel file workbook.save("AddButtonCellType.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val cellType = ButtonCellType() cellType.setText("Hello") cellType.setButtonBackColor("Azure") cellType.marginLeft = 10.0 cellType.marginRight = 10.0 worksheet.getRange("C5").cellType = cellType //save to an excel file workbook.save("AddButtonCellType.xlsx")