Hi again,
Named ranges in EXCEL have a scope. That means that you can have several names but with different scope : - One named range TOTAL referencing cell C4 of sheet ‘sales’ - One named range TOTAL referencing cell C4 of sheet ‘expenses’ I know I can use the ‘setSheetindex’ method when creating the name but how do I do to get the name applying only to the sales sheet ? I tried that and I can only retrieve one value with XSSFWorkbook.getName() and I don’t know how to get the rest…. Thanks any help. POI : 3.7 EXCEL : 2010 (XLSX) Take care, Marco.
