Page breaks

The following example shows you how to insert manual horizontal and vertical page breaks into a worksheet.

import com.independentsoft.office.spreadsheet.Break;
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();
            sheet.setName("Report");

            for (int r = 1; r <= 30; r++)
            {
                sheet.set("A" + r, new Cell("Row " + r));
                sheet.set("B" + r, new Cell(r * 10));
            }

            Break hBreak1 = new Break();
            hBreak1.setID(10);
            hBreak1.setManual(true);
            sheet.getHorizontalPageBreaks().add(hBreak1);

            Break hBreak2 = new Break();
            hBreak2.setID(20);
            hBreak2.setManual(true);
            sheet.getHorizontalPageBreaks().add(hBreak2);

            Break vBreak = new Break();
            vBreak.setID(2);
            vBreak.setManual(true);
            sheet.getVerticalPageBreaks().add(vBreak);

            Workbook book = new Workbook();
            book.getSheets().add(sheet);
            book.save("c:\\test\\output.xlsx", true);
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Page breaks

Need help? Ask our developers: