// Create a new workbook Workbook workbook = new Workbook(); IRange mc = workbook.getWorksheets().get("Sheet1").getCells().get(0, 0); System.out.println(mc.getAddress()); // $A$1 System.out.println(mc.getAddress(false, true)); // $A1 System.out.println(mc.getAddress(true, true, ReferenceStyle.R1C1)); // R1C1 System.out.println( mc.getAddress(false, false, ReferenceStyle.R1C1, workbook.getWorksheets().get(0).getCells().get(2, 2))); // R[-2]C[-2]
// Create a new workbook var workbook = Workbook() val mc = workbook.worksheets["Sheet1"].cells[0, 0] println(mc.address) // $A$1 println(mc.getAddress(false, true)) // $A1 println(mc.getAddress(true, true, ReferenceStyle.R1C1)) // R1C1 println(mc.getAddress(false, false, ReferenceStyle.R1C1, workbook.worksheets[0].cells[2, 2])) // R[-2]C[-2]