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.

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Worksheet sheet = new Worksheet("Sheet1");

            sheet.set("A1", new Cell("Hello"));
            sheet.set("B1", new Cell("World"));

            Workbook book = new Workbook();
            book.getSheets().add(sheet);

            byte[] bytes = book.getBytes();

            System.out.println("Generated " + bytes.length + " bytes.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

The save method also accepts any java.io.OutputStream, so the workbook can be written directly to a ByteArrayOutputStream, a response stream or any other destination.

import java.io.ByteArrayOutputStream;

import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            ByteArrayOutputStream stream = new ByteArrayOutputStream();
            book.save(stream);

            byte[] bytes = stream.toByteArray();

            System.out.println("Workbook size: " + bytes.length + " bytes.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JSpreadsheet > Tutorial > Save workbook to a stream or byte array

Need help? Ask our developers: