Load from XLS (BIFF8)

The following example shows you how to load a legacy Excel 97-2003 .xls file and convert it to the modern .xlsx format.

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();
            book.loadFromXls("c:\\test\\input.xls");

            System.out.println("Sheets loaded: " + book.getSheets().size());

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

                    List<Cell> cells = ws.getCells();
                    System.out.println("  Cells: " + cells.size());
                }
            }

            book.save("c:\\test\\output.xlsx", true);
            System.out.println("Converted to XLSX successfully.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Load from XLS (BIFF8)

Need help? Ask our developers: