/** * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.<p> * * If both colSplit and rowSplit are zero then the existing freeze pane is removed * * @param colSplit Horizonatal position of split. * @param rowSplit Vertical position of split. */ @Override public void createFreezePane(int colSplit, int rowSplit) { createFreezePane(colSplit, rowSplit, colSplit, rowSplit); }
/** * Creates a split (freezepane). Any existing freezepane or split pane is overwritten.<p> * * If both colSplit and rowSplit are zero then the existing freeze pane is removed * * @param colSplit Horizonatal position of split. * @param rowSplit Vertical position of split. */ @Override public void createFreezePane(int colSplit, int rowSplit) { createFreezePane(colSplit, rowSplit, colSplit, rowSplit); }
/** * Creates a split (freezepane). Any existing freezepane or split pane is overwritten. * <p/> * <p> * If both colSplit and rowSplit are zero then the existing freeze pane is removed * </p> * * @param colSplit Horizonatal position of split. * @param rowSplit Vertical position of split. */ public void createFreezePane(int colSplit, int rowSplit) { createFreezePane(colSplit, rowSplit, colSplit, rowSplit); }
/** * Creates a split (freezepane). Any existing freezepane or split pane is overwritten. * * <p> * If both colSplit and rowSplit are zero then the existing freeze pane is removed * </p> * * @param colSplit Horizonatal position of split. * @param rowSplit Vertical position of split. */ public void createFreezePane(int colSplit, int rowSplit) { createFreezePane(colSplit, rowSplit, colSplit, rowSplit); }
public Worksheet(HSSFWorkbook workbook, String sheetName, String title, List<String> columnHeaders) { sheet = workbook.createSheet(sheetName); initializeLayout(title, columnHeaders); sheet.createFreezePane(0, currentRowIndex); }
public static void main(String[] args) throws IOException { try (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); // Create a split with the lower left side being the active quadrant sheet4.createSplitPane(2000, 2000, 0, 0, Sheet.PANE_LOWER_LEFT); try (FileOutputStream fileOut = new FileOutputStream("workbook.xls")) { wb.write(fileOut); } } } }
private Map<String, Integer> exportDefLang(File valueDir) throws IOException, SAXException { Map<String, Integer> keys = new HashMap<String, Integer>(); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet; sheet = wb.createSheet(project); int rowIndex = 0; sheet.createRow(rowIndex++); createTilte(wb, sheet); addLang2Tilte(wb, sheet, "default"); sheet.createFreezePane(1, 1); FileOutputStream outFile = new FileOutputStream(outExcelFile); wb.write(outFile); outFile.close(); for (String fileName : sAllowedFiles) { File stringFile = new File(valueDir, fileName); if (!stringFile.exists()) { continue; } keys.putAll(exportDefLangToExcel(rowIndex, project, stringFile, getStrings(stringFile), outExcelFile)); } return keys; }
style.setFillPattern(CellStyle.FINE_DOTS); sheet.createFreezePane(0, 1); // Freeze 1st Row sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)
style.setFillPattern(CellStyle.SOLID_FOREGROUND); sheet.createFreezePane(0, 1); // Freeze 1st Row sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)
sheet.createFreezePane(0, 1, 0, 1); sheet.autoSizeColumn(1, true); sheet.autoSizeColumn(2, true);
private void writeArtifacts(Inventory inventory, HSSFWorkbook myWorkBook) { HSSFSheet mySheet = myWorkBook.createSheet("Artifact Inventory"); mySheet.createFreezePane(0, 1); mySheet.setDefaultColumnWidth(20);
private void writeNotices(Inventory inventory, HSSFWorkbook myWorkBook) { HSSFSheet mySheet = myWorkBook.createSheet("License Notices"); mySheet.createFreezePane(0, 1); mySheet.setAutoFilter(new CellRangeAddress(0, 65000, 0, 4)); mySheet.setDefaultColumnWidth(80);