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.

C# example

using System;
using System.Collections.Generic;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook();
            book.LoadFromXls("c:\\test\\input.xls");

            Console.WriteLine("Sheets loaded: " + book.Sheets.Count);

            foreach (Sheet sheet in book.Sheets)
            {
                if (sheet is Worksheet)
                {
                    Worksheet ws = (Worksheet)sheet;
                    Console.WriteLine("Sheet: " + ws.Name);

                    IList<Cell> cells = ws.GetCells();
                    Console.WriteLine("  Cells: " + cells.Count);
                }
            }

            // Save as modern xlsx format
            book.Save("c:\\test\\output.xlsx", true);
            Console.WriteLine("Converted to XLSX successfully.");
        }
    }
}

VB example

Imports System
Imports System.Collections.Generic
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim book As New Workbook()
        book.LoadFromXls("c:\test\input.xls")

        Console.WriteLine("Sheets loaded: " & book.Sheets.Count)

        For Each sheet As Sheet In book.Sheets
            If TypeOf sheet Is Worksheet Then
                Dim ws As Worksheet = DirectCast(sheet, Worksheet)
                Console.WriteLine("Sheet: " & ws.Name)

                Dim cells As IList(Of Cell) = ws.GetCells()
                Console.WriteLine("  Cells: " & cells.Count)
            End If
        Next

        book.Save("c:\test\output.xlsx", True)
        Console.WriteLine("Converted to XLSX successfully.")

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Load from XLS (BIFF8)

Need help? Ask our developers: