How can i get name box from excel

Question

When I find a difference between two excels files, I print it using the example DIFF command. Sch HI cell values (1 of 4)! Old and updated values for the cell location K40 (6.0 vs. 5.0)

I, therefore, need to print the box name in place of the cell position.

 @Override
    public void reportDiffCell(CellPos c1, CellPos c2) {
        sheets.add(c1.getSheetName());
        rows.add(c1.getRow());
        cols.add(c1.getColumn());
        results.add("DIFF Cell values at: " + c1.getCellPosition() + " => '" + c1.getCellValue()
                + "' v/s '" + c2.getCellValue() + "'");
    }

Answer 1

You could add a VBA function to the workbook and call that from java.

Function CellName(r As Range)
    On Error Resume Next
    CellName = r.Name.Name
    If Err Then CellName = r.Address(0, 0)
End Function