Example usage for org.apache.poi.hssf.usermodel HSSFSheet createFreezePane

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet createFreezePane.

Prototype

@Override
public void createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow) 

Source Link

Document

Creates a split (freezepane).

Usage

From source file:poi.hssf.usermodel.examples.SplitAndFreezePanes.java

License:Apache License

public static void main(String[] args) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet1 = wb.createSheet("new sheet");
    HSSFSheet sheet2 = wb.createSheet("second sheet");
    HSSFSheet sheet3 = wb.createSheet("third sheet");
    HSSFSheet 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);
    // Freeze the columns and rows (forget about scrolling position of the lower right quadrant).
    sheet3.createFreezePane(2, 2);/*w ww.  ja va 2 s.  c  o  m*/
    // Create a split with the lower left side being the active quadrant
    sheet4.createSplitPane(2000, 2000, 0, 0, HSSFSheet.PANE_LOWER_LEFT);

    FileOutputStream fileOut = new FileOutputStream("workbook.xls");
    wb.write(fileOut);
    fileOut.close();
}

---

From source file:senselogic.excelbundle.ExcelExporter.java

License:Apache License

/**
 * Create a sheet and fill it with stuff.
 *//*w w  w  .  ja  va2s.  c  o  m*/
private void createSheet(String sheetName, LanguagePack referencePack) {
    HSSFSheet sheet = wb.createSheet(sheetName);
    sheet.protectSheet("excelbundle");
    sheet.setDisplayGridlines(false);
    sheet.createFreezePane(1, 0, 1, 0);

    //Set some column widths:
    int numCols = langPacks.size() + 2;
    for (short i = 0; i <= numCols; i++)
        sheet.setColumnWidth(i, 10000);

    //Now lets fill it with stuff
    HSSFRow r;
    HSSFCell c;
    int rowIndex = 0;
    int colIndex;
    for (LanguageFile refLangFile : referencePack.getLanguageFiles()) {
        //Bundle path
        r = sheet.createRow(rowIndex);
        c = r.createCell(0);
        c.setCellStyle(bundlePathStyle);
        c.setCellValue(new HSSFRichTextString(refLangFile.getPath()));
        rowIndex++;

        //"Table header"
        r = sheet.createRow(rowIndex);
        colIndex = 1;
        for (LanguagePack pack : langPacks.values()) {
            c = r.createCell(colIndex);
            c.setCellStyle(languageStyle);
            c.setCellValue(new HSSFRichTextString(pack.getLanguage()));
            colIndex++;
        }
        rowIndex++;

        //Keys and values
        for (LanguageFile.KeyValuePair pair : refLangFile.getPairs()) {
            r = sheet.createRow(rowIndex);
            r.setHeightInPoints(16);
            c = r.createCell(0);
            c.setCellStyle(keyStyle);
            c.setCellValue(new HSSFRichTextString(pair.getKey()));

            colIndex = 1;
            for (LanguagePack pack : langPacks.values()) {
                c = r.createCell(colIndex);

                String value = null;
                LanguageFile langFile = pack.getLanguageFile(refLangFile.getPath());
                if (langFile != null)
                    value = langFile.getValue(pair.getKey());

                if (value == null) {
                    if (redmark)
                        c.setCellStyle(missingStyle);
                    else
                        c.setCellStyle(valueStyle);
                } else {
                    c.setCellStyle(valueStyle);
                    c.setCellValue(new HSSFRichTextString(value));
                }
                colIndex++;
            }
            rowIndex++;
        }
        rowIndex++;
    } //End of sheet creation
}

---

• «
• 1
• 2
• »