Bulk fill worksheet

The following example shows you how to efficiently populate a large number of rows in a worksheet using a loop.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();
            sheet.Name = "Data";

            sheet["A1"] = new Cell("Name");
            sheet["B1"] = new Cell("Value");
            sheet["C1"] = new Cell("Category");

            for (int i = 2; i <= 1001; i++)
            {
                sheet["A" + i] = new Cell("Item " + (i - 1));
                sheet["B" + i] = new Cell(i * 1.5);
                sheet["C" + i] = new Cell(i % 3 == 0 ? "C" : i % 2 == 0 ? "B" : "A");
            }

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);

            Console.WriteLine("1000 data rows written successfully.");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

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

        Dim sheet As New Worksheet()
        sheet.Name = "Data"

        sheet("A1") = New Cell("Name")
        sheet("B1") = New Cell("Value")
        sheet("C1") = New Cell("Category")

        For i As Integer = 2 To 1001
            sheet("A" & i) = New Cell("Item " & (i - 1))
            sheet("B" & i) = New Cell(i * 1.5)
            Dim cat As String = If(i Mod 3 = 0, "C", If(i Mod 2 = 0, "B", "A"))
            sheet("C" & i) = New Cell(cat)
        Next

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

        Console.WriteLine("1000 data rows written successfully.")

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Bulk fill worksheet

Need help? Ask our developers: