Multiple sheets

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

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
        {
            Workbook book = new Workbook();

            Worksheet sales = new Worksheet();
            sales.setName("Sales");
            sales.set("A1", new Cell("Product"));
            sales.set("B1", new Cell("Revenue"));
            sales.set("A2", new Cell("Widget A"));
            sales.set("B2", new Cell(12500.0));
            sales.set("A3", new Cell("Widget B"));
            sales.set("B3", new Cell(8750.0));
            book.getSheets().add(sales);

            Worksheet expenses = new Worksheet();
            expenses.setName("Expenses");
            expenses.set("A1", new Cell("Category"));
            expenses.set("B1", new Cell("Amount"));
            expenses.set("A2", new Cell("Rent"));
            expenses.set("B2", new Cell(3000.0));
            expenses.set("A3", new Cell("Utilities"));
            expenses.set("B3", new Cell(500.0));
            book.getSheets().add(expenses);

            Worksheet summary = new Worksheet();
            summary.setName("Summary");
            summary.set("A1", new Cell("Sheet"));
            summary.set("B1", new Cell("Row Count"));
            summary.set("A2", new Cell("Sales"));
            summary.set("B2", new Cell(2));
            summary.set("A3", new Cell("Expenses"));
            summary.set("B3", new Cell(2));
            book.getSheets().add(summary);

            book.save("c:\\test\\output.xlsx", true);
            System.out.println("Workbook with " + book.getSheets().size() + " sheets saved.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Multiple sheets

Need help? Ask our developers: