//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); sheet.getRange("B3:B7").setValue(123456.789); sheet.getRange("B9:B13").setValue(-123456.789); sheet.getRange("B4, B10").setNumberFormat("0.00;[Red]0.00"); sheet.getRange("B5, B11").setNumberFormat("$#,##0.00;[Red]$#,##0.00"); sheet.getRange("B6, B12").setNumberFormat("0.00E+00"); sheet.getRange("B7, B13").setNumberFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \" - \"??_);_(@_)"); //Other settings sheet.getColumns().get(1).setColumnWidthInPixel(100); //save to an pdf file workbook.save("NumberFormating.pdf");
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) sheet.getRange("B3:B7").value = 123456.789 sheet.getRange("B9:B13").value = -123456.789 sheet.getRange("B4, B10").numberFormat = "0.00;[Red]0.00" sheet.getRange("B5, B11").numberFormat = "$#,##0.00;[Red]$#,##0.00" sheet.getRange("B6, B12").numberFormat = "0.00E+00" sheet.getRange("B7, B13").numberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* \" - \"??_);_(@_)" //Other settings sheet.columns.get(1).columnWidthInPixel = 100.0 //save to an pdf file workbook.save("NumberFormating.pdf")