// Create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getActiveSheet(); sheet.getRange("A2:E2").merge(); sheet.getRange("A2:E2").setValue("Data"); sheet.getRange("A2:E2").setHorizontalAlignment(HorizontalAlignment.Center); sheet.getRange("A2:E2").getFont().setBold(true); Object[][] data = new Object[][]{ {"Product", "Category", "Unit Price", "Quantity", "Total"}, {"Phone", "Electronics", 899.99, 2, 1799.98}, {"Headphones", "Accessories", 199.50, 3, 598.50}, {"Laptop", "Electronics", 3499.00, 1, 3499.00}, {"Mouse", "Accessories", 99.99, 4, 399.96}, {"Keyboard", "Office", 149.00, 2, 298.00} }; sheet.getRange("A3:E8").setValue(data); sheet.getRange("G1").setValue("Formula"); sheet.getRange("G2").setValue("=TRIMRANGE(A:E)"); sheet.getRange("G3").setValue("Result"); sheet.getRange("G4").setFormula2("=TRIMRANGE(A:E)"); sheet.getRange("H3").setValue("Rows:"); sheet.getRange("I3").setFormula2("=ROWS(TRIMRANGE(A:E))"); sheet.getRange("J3").setValue("Columns:"); sheet.getRange("K3").setFormula2("=COLUMNS(TRIMRANGE(A:E))"); sheet.getRange("G1,G3,H3,J3").getFont().setBold(true); sheet.getRange("G12").setValue("Trim Reference"); sheet.getRange("G13").setValue("=A:.E"); sheet.getRange("G14").setValue("Result"); sheet.getRange("G15").setFormula2("=A:.E"); sheet.getRange("H14").setValue("Rows:"); sheet.getRange("I14").setFormula2("=ROWS(A:.E)"); sheet.getRange("J14").setValue("Columns:"); sheet.getRange("K14").setFormula2("=COLUMNS(A:.E)"); sheet.getRange("G12,G14,H14,J14").getFont().setBold(true); sheet.getRange("A:K").autoFit(); // Save to an excel file workbook.save("TrimRangeFunctionAndTrimReferences.xlsx");