Save workbook to a stream or byte array

The following example shows you how to generate an XLSX workbook in memory. The GetBytes method returns the complete file as a byte array, which is convenient in web applications where the workbook is sent to the client as a download and never stored on disk.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

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

            sheet["A1"] = new Cell("Hello");
            sheet["B1"] = new Cell("World");

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);

            byte[] bytes = book.GetBytes();

            Console.WriteLine("Generated " + bytes.Length + " bytes.");
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

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

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

        sheet("A1") = New Cell("Hello")
        sheet("B1") = New Cell("World")

        Dim book As New Workbook()
        book.Sheets.Add(sheet)

        Dim bytes As Byte() = book.GetBytes()

        Console.WriteLine("Generated " & bytes.Length & " bytes.")

    End Sub
End Module

The Save method also accepts any System.IO.Stream, so the workbook can be written directly to a MemoryStream, a response stream or any other destination.

C# example

using System;
using System.IO;
using Independentsoft.Office.Spreadsheet;

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

            using (MemoryStream stream = new MemoryStream())
            {
                book.Save(stream);

                Console.WriteLine("Workbook size: " + stream.Length + " bytes.");
            }
        }
    }
}

VB example

Imports System
Imports System.IO
Imports Independentsoft.Office.Spreadsheet

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

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

        Using stream As New MemoryStream()
            book.Save(stream)

            Console.WriteLine("Workbook size: " & stream.Length & " bytes.")
        End Using

    End Sub
End Module

Spreadsheet .NET > Tutorial > Save workbook to a stream or byte array

Need help? Ask our developers: