Multiple sheets

The following example shows you how to create a workbook with multiple worksheets, set their names and populate each independently.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook book = new Workbook();

            Worksheet sales = new Worksheet();
            sales.Name = "Sales";
            sales["A1"] = new Cell("Product");
            sales["B1"] = new Cell("Revenue");
            sales["A2"] = new Cell("Widget A");
            sales["B2"] = new Cell(12500.0);
            sales["A3"] = new Cell("Widget B");
            sales["B3"] = new Cell(8750.0);
            book.Sheets.Add(sales);

            Worksheet expenses = new Worksheet();
            expenses.Name = "Expenses";
            expenses["A1"] = new Cell("Category");
            expenses["B1"] = new Cell("Amount");
            expenses["A2"] = new Cell("Rent");
            expenses["B2"] = new Cell(3000.0);
            expenses["A3"] = new Cell("Utilities");
            expenses["B3"] = new Cell(500.0);
            book.Sheets.Add(expenses);

            Worksheet summary = new Worksheet();
            summary.Name = "Summary";
            summary["A1"] = new Cell("Sheet");
            summary["B1"] = new Cell("Row Count");
            summary["A2"] = new Cell("Sales");
            summary["B2"] = new Cell(2);
            summary["A3"] = new Cell("Expenses");
            summary["B3"] = new Cell(2);
            book.Sheets.Add(summary);

            book.Save("c:\\test\\output.xlsx", true);
            Console.WriteLine("Workbook with " + book.Sheets.Count + " sheets saved.");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

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

        Dim book As New Workbook()

        Dim sales As New Worksheet()
        sales.Name = "Sales"
        sales("A1") = New Cell("Product")
        sales("B1") = New Cell("Revenue")
        sales("A2") = New Cell("Widget A")
        sales("B2") = New Cell(12500.0)
        sales("A3") = New Cell("Widget B")
        sales("B3") = New Cell(8750.0)
        book.Sheets.Add(sales)

        Dim expenses As New Worksheet()
        expenses.Name = "Expenses"
        expenses("A1") = New Cell("Category")
        expenses("B1") = New Cell("Amount")
        expenses("A2") = New Cell("Rent")
        expenses("B2") = New Cell(3000.0)
        expenses("A3") = New Cell("Utilities")
        expenses("B3") = New Cell(500.0)
        book.Sheets.Add(expenses)

        Dim summary As New Worksheet()
        summary.Name = "Summary"
        summary("A1") = New Cell("Sheet")
        summary("B1") = New Cell("Row Count")
        summary("A2") = New Cell("Sales")
        summary("B2") = New Cell(2)
        summary("A3") = New Cell("Expenses")
        summary("B3") = New Cell(2)
        book.Sheets.Add(summary)

        book.Save("c:\test\output.xlsx", True)
        Console.WriteLine("Workbook with " & book.Sheets.Count & " sheets saved.")

    End Sub
End Module

Spreadsheet .NET > Tutorial > Multiple sheets

Need help? Ask our developers: