Load workbook from file

The following example shows you how to load an existing Excel workbook from a file and iterate over its sheets and cells.

import java.util.List;

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Sheet;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

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

            for (Sheet sheet : book.getSheets())
            {
                if (sheet instanceof Worksheet)
                {
                    Worksheet ws = (Worksheet) sheet;
                    System.out.println("Sheet: " + ws.getName());

                    List<Cell> cells = ws.getCells();
                    for (int i = 0; i < cells.size(); i++)
                    {
                        System.out.println(cells.get(i).getReference() + " = " + cells.get(i).getValue());
                    }
                }
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Load workbook from file

Need help? Ask our developers: