// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("B3:C16").setValue(new Object[][] { { "ITEM", "AMOUNT" }, { "Rent/mortgage", 800 }, { "Electric", 120 }, { "Gas", 50 }, { "Cell phone", 45 }, { "Groceries", 500 }, { "Car payment", 273 }, { "Auto expenses", 120 }, { "Student loans", 50 }, { "Credit cards", 100 }, { "Auto Insurance", 78 }, { "Personal care", 50 }, { "Entertainment", 100 }, { "Miscellaneous", 50 }, }); // Create a table ITable expensesTable = worksheet.getTables().add(worksheet.getRange("B3:C16"), true); expensesTable.setName("tblExpenses"); worksheet.getRange("C3:C16").setNumberFormat("$#,##0_);($#,##0)"); worksheet.getRange("B2:C2").merge(); worksheet.getRange("B2").setValue("MONTHLY EXPENSES"); worksheet.getRange("B2").getInterior().setColor(Color.FromArgb(219, 219, 219)); worksheet.getRange("E2").setValue("Total Monthly Expenses"); worksheet.getRange("E3").setFormula("SUM(tblExpenses[AMOUNT])"); worksheet.getRange("E3").setNumberFormat("$#,##0_);($#,##0)"); worksheet.getRange("B:B").setColumnWidth(15); worksheet.getRange("C:C").setColumnWidth(15); worksheet.getRange("E:F").setColumnWidth(15); String json = workbook.toJson(); // ignore style and formula when deserialize workbook from json. DeserializationOptions deserializationOptions = new DeserializationOptions(); deserializationOptions.setIgnoreStyle(true); deserializationOptions.setIgnoreFormula(true); workbook.fromJson(json, deserializationOptions); // Save to an excel file workbook.save("WorkbookFromJsonWithOptions.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets[0] worksheet.getRange("B3:C16").value = arrayOf(arrayOf("ITEM", "AMOUNT"), arrayOf("Rent/mortgage", 800), arrayOf("Electric", 120), arrayOf("Gas", 50), arrayOf("Cell phone", 45), arrayOf("Groceries", 500), arrayOf("Car payment", 273), arrayOf("Auto expenses", 120), arrayOf("Student loans", 50), arrayOf("Credit cards", 100), arrayOf("Auto Insurance", 78), arrayOf("Personal care", 50), arrayOf("Entertainment", 100), arrayOf("Miscellaneous", 50)) // Create a table val expensesTable = worksheet.tables.add(worksheet.getRange("B3:C16"), true) expensesTable.name = "tblExpenses" worksheet.getRange("C3:C16").numberFormat = "$#,##0_);($#,##0)" worksheet.getRange("B2:C2").merge() worksheet.getRange("B2").value = "MONTHLY EXPENSES" worksheet.getRange("B2").interior.color = Color.FromArgb(219, 219, 219) worksheet.getRange("E2").value = "Total Monthly Expenses" worksheet.getRange("E3").formula = "SUM(tblExpenses[AMOUNT])" worksheet.getRange("E3").numberFormat = "$#,##0_);($#,##0)" worksheet.getRange("B:B").columnWidth = 15.0 worksheet.getRange("C:C").columnWidth = 15.0 worksheet.getRange("E:F").columnWidth = 15.0 val json = workbook.toJson() // ignore style and formula when deserialize workbook from json. val deserializationOptions = DeserializationOptions() deserializationOptions.ignoreStyle = true deserializationOptions.ignoreFormula = true workbook.fromJson(json, deserializationOptions) // Save to an excel file workbook.save("WorkbookFromJsonWithOptions.xlsx")