// Create a new workbook Workbook workbook = new Workbook(); // Get the cell at row 0, column 0 in the worksheet named "Sheet1" IRange mc = workbook.getWorksheets().get("Sheet1").getCells().get(0, 0); // Print the absolute address of the cell (e.g., $A$1) System.out.println(mc.getAddress()); // Print the address of the cell with the row not being absolute (e.g., $A1) System.out.println(mc.getAddress(false, true)); // Print the address of the cell in R1C1 reference style (e.g., R1C1) System.out.println(mc.getAddress(true, true, ReferenceStyle.R1C1)); // Print the address of the cell in R1C1 reference style with both row and column not being absolute, // relative to the cell at row 2, column 2 in the first worksheet (e.g., R[-2]C[-2]) System.out.println( mc.getAddress(false, false, ReferenceStyle.R1C1, workbook.getWorksheets().get(0).getCells().get(2, 2)));