Enumerate Defined Names

The following example shows you how to get all defined names (ranges) from a workbook and display all cells from the defined names.

import java.util.List;

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.DefinedName;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            List<DefinedName> ranges = book.getDefinedNames();

            for (DefinedName range : ranges)
            {
                System.out.println("Range name = " + range.getName());
                System.out.println("Reference  = " + range.getBody());

                List<Cell> cells = book.getCells(range.getBody());
                
                for (Cell cell : cells)
                {
                	System.out.println(cell.getReference() + " = " + cell.getValue());
                }
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

Independentsoft - any library, any programming language

JSpreadsheet > Tutorial > Enumerate Defined Names

Need help? Ask our developers: