//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A:H").setColumnWidth(17); // Display 111 as 111. worksheet.getRange("A1").setValue(111); worksheet.getRange("A1").setNumberFormat("#####"); // Display 222 as 00222. worksheet.getRange("B1").setValue(222); worksheet.getRange("B1").setNumberFormat("00000"); // Display 12345678 as 12,345,678. worksheet.getRange("C1").setValue(12345678); worksheet.getRange("C1").setNumberFormat("#,#"); // Display .126 as 0.13. worksheet.getRange("D1").setValue(.126); worksheet.getRange("D1").setNumberFormat("0.##"); // Display 74.4 as 74.400. worksheet.getRange("E1").setValue(74.4); worksheet.getRange("E1").setNumberFormat("##.000"); // Display 1.6 as 160.0%. worksheet.getRange("F1").setValue(1.6); worksheet.getRange("F1").setNumberFormat("0.0%"); // Display 4321 as $4,321.00. worksheet.getRange("G1").setValue(4321); worksheet.getRange("G1").setNumberFormat("$#,##0.00"); // Display 8.75 as 8 3/4. worksheet.getRange("H1").setValue(8.75); worksheet.getRange("H1").setNumberFormat("# ?/?"); //save to an excel file workbook.save("NumberFormats.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A:H").columnWidth = 17.0 // Display 111 as 111. worksheet.getRange("A1").value = 111 worksheet.getRange("A1").numberFormat = "#####" // Display 222 as 00222. worksheet.getRange("B1").value = 222 worksheet.getRange("B1").numberFormat = "00000" // Display 12345678 as 12,345,678. worksheet.getRange("C1").value = 12345678 worksheet.getRange("C1").numberFormat = "#,#" // Display .126 as 0.13. worksheet.getRange("D1").value = .126 worksheet.getRange("D1").numberFormat = "0.##" // Display 74.4 as 74.400. worksheet.getRange("E1").value = 74.4 worksheet.getRange("E1").numberFormat = "##.000" // Display 1.6 as 160.0%. worksheet.getRange("F1").value = 1.6 worksheet.getRange("F1").numberFormat = "0.0%" // Display 4321 as $4,321.00. worksheet.getRange("G1").value = 4321 worksheet.getRange("G1").numberFormat = "$#,##0.00" // Display 8.75 as 8 3/4. worksheet.getRange("H1").value = 8.75 worksheet.getRange("H1").numberFormat = "# ?/?" //save to an excel file workbook.save("NumberFormats.xlsx")