Package org.apache.poi.xssf.usermodel

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet()

28
29
30
31
32
33
34
35
36
37
38
*/
public class SplitAndFreezePanes {
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        Sheet sheet3 = wb.createSheet("third sheet");
        Sheet sheet4 = wb.createSheet("fourth sheet");

        // Freeze just one row
        sheet1.createFreezePane(0, 1, 0, 1);
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
public class SplitAndFreezePanes {
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        Sheet sheet3 = wb.createSheet("third sheet");
        Sheet sheet4 = wb.createSheet("fourth sheet");

        // Freeze just one row
        sheet1.createFreezePane(0, 1, 0, 1);
        // Freeze just one column
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        Sheet sheet3 = wb.createSheet("third sheet");
        Sheet sheet4 = wb.createSheet("fourth sheet");

        // Freeze just one row
        sheet1.createFreezePane(0, 1, 0, 1);
        // Freeze just one column
        sheet2.createFreezePane(1, 0, 1, 0);
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
public class SelectedSheet {

    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();

        Sheet sheet = wb.createSheet("row sheet");
        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();

        Sheet sheet = wb.createSheet("row sheet");
        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);

        // Create various cells and rows for spreadsheet.
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();

        Sheet sheet = wb.createSheet("row sheet");
        Sheet sheet2 = wb.createSheet("another sheet");
        Sheet sheet3 = wb.createSheet(" sheet 3 ");
        sheet3.setSelected(true);
        wb.setActiveSheet(2);

        // Create various cells and rows for spreadsheet.
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
* Working with borders
*/
public class WorkingWithBorders {
    public static void main(String[] args) throws Exception {
        Workbook wb = new XSSFWorkbook();  //or new HSSFWorkbook();
        Sheet sheet = wb.createSheet("borders");

        // Create a row and put some cells in it. Rows are 0 based.
        Row row = sheet.createRow((short) 1);

        // Create a cell and put a value in it.
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
* Working with Fonts
*/
public class WorkingWithFonts {
    public static void main(String[] args) throws Exception {
        Workbook wb = new XSSFWorkbook();  //or new HSSFWorkbook();
        Sheet sheet = wb.createSheet("Fonts");

        Font font0 = wb.createFont();
        font0.setColor(IndexedColors.BROWN.getIndex());
        CellStyle style0 = wb.createCellStyle();
        style0.setFont(font0);
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
public class FitSheetToOnePage {


    public static void main(String[]args) throws Exception {
        Workbook wb = new XSSFWorkbook();  //or new HSSFWorkbook();
        Sheet sheet = wb.createSheet("format sheet");
        PrintSetup ps = sheet.getPrintSetup();

        sheet.setAutobreaks(true);

        ps.setFitHeight((short) 1);
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
* An example of how to merge regions of cells.
*/
public class MergingCells {
    public static void main(String[] args) throws Exception {
        Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook();
        Sheet sheet = wb.createSheet("new sheet");

        Row row = sheet.createRow((short) 1);
        Cell cell = row.createCell((short) 1);
        cell.setCellValue(new XSSFRichTextString("This is a test of merging"));

View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.