Range Template cell type Sample Clauses

Range Template cell type. Create a Range Template cell type by using RangeTemplateCellType method and apply it to the desired cell range. Refer to the following code to create a Range Template cell type. //create a new workbook Workbook workbook = new Workbook(); Workbook.setValueJsonSerializer(new CustomObjectJsonSerializer()); IWorksheet sheet1 = workbook.getActiveSheet(); IWorksheet sheet2 = workbook.getWorksheets().add(); PersonalAssets record1 = new PersonalAssets(); ▇▇▇▇▇▇▇.▇▇▇▇ = "Peyton"; record1.savings = 25000; record1.shares = 55000; record1.stocks = 15000; ▇▇▇▇▇▇▇.▇▇▇▇▇ = 250000; record1.bonds = 11000; ▇▇▇▇▇▇▇.▇▇▇ = 7500; PersonalAssets record2 = new PersonalAssets(); ▇▇▇▇▇▇▇.▇▇▇▇ = "Icey"; record2.savings = 30000; record2.shares = 45000; record2.stocks = 25000; ▇▇▇▇▇▇▇.▇▇▇▇▇ = 20000; record2.bonds = 18000; ▇▇▇▇▇▇▇.▇▇▇ = 75000; PersonalAssets record3 = new PersonalAssets(); ▇▇▇▇▇▇▇.▇▇▇▇ = "▇▇▇▇▇▇"; record3.savings = 20000; record3.shares = 4000; record3.stocks = 95000; ▇▇▇▇▇▇▇.▇▇▇▇▇ = 30000; record3.bonds = 10000; ▇▇▇▇▇▇▇.▇▇▇ = 56000; PersonalAssets record4 = new PersonalAssets(); ▇▇▇▇▇▇▇.▇▇▇▇ = "▇▇▇▇▇"; record4.savings = 70000; record4.shares = 85000; record4.stocks = 35000; ▇▇▇▇▇▇▇.▇▇▇▇▇ = 20000; record4.bonds = 15000; ▇▇▇▇▇▇▇.▇▇▇ = 45000; // Set binding path for cell. sheet2.getRange("A1:C1").merge(); sheet2.getRange("A1:C1").setHorizontalAlignment(▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇.▇▇▇▇▇▇); sheet2.getRange("A1:C1").setVerticalAlignment(▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇▇.▇▇▇▇▇▇); sheet2.getRange("A1").setBindingPath("name"); sheet2.getRange("A1").getFont().setName("Arial"); sheet2.getRange("A1").getFont().setSize(15); sheet2.getRange("1:1").setRowHeight(30); sheet2.getRange("A2").setValue("Asset Type"); sheet2.getRange("B2").setValue("Amount"); sheet2.getRange("C2").setValue("Rate"); sheet2.getRange("A3").setValue("Savings"); sheet2.getRange("A3").getInterior().setColor(Color.FromArgb(145, 159, 129)); sheet2.getRange("B3").setBindingPath("savings"); sheet2.getRange("C3").setFormula("=B3/B9"); sheet2.getRange("A4").setValue("Shares"); sheet2.getRange("A4").getInterior().setColor(Color.FromArgb(215, 145, 62)); sheet2.getRange("B4").setBindingPath("shares"); sheet2.getRange("C4").setFormula("=B4/B9"); sheet2.getRange("A5").setValue("Stocks"); sheet2.getRange("A5").getInterior().setColor(Color.FromArgb(206, 167, 34)); sheet2.getRange("B5").setBindingPath("stocks"); sheet2.getRange("C5").setFormula("=B5/B9"); sheet2.getRange("A6").setValue("House"); sheet2.getRange("A6").getInterior().setColor(Color.Fro...