本文整理了Java中org.apache.poi.hssf.usermodel.HSSFSheet.createFreezePane()
方法的一些代码示例,展示了HSSFSheet.createFreezePane()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。HSSFSheet.createFreezePane()
方法的具体详情如下:
包路径:org.apache.poi.hssf.usermodel.HSSFSheet
类名称:HSSFSheet
方法名:createFreezePane
[英]Creates a split (freezepane). Any existing freezepane or split pane is overwritten.
If both colSplit and rowSplit are zero then the existing freeze pane is removed
[中]创建拆分(冻结窗格)。任何现有的冻结窗格或拆分窗格都将被覆盖。
如果colSplit和rowSplit均为零,则现有的冻结窗格将被删除
代码示例来源:origin: org.apache.poi/poi
/**
* 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);
}
代码示例来源:origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi
/**
* 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);
}
代码示例来源:origin: com.haulmont.thirdparty/poi
/**
* 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);
}
代码示例来源:origin: org.openl.rules/org.openl.lib.poi.dev
/**
* 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);
}
代码示例来源:origin: org.motechproject/motech-bulk-export-import
public Worksheet(HSSFWorkbook workbook, String sheetName, String title, List<String> columnHeaders) {
sheet = workbook.createSheet(sheetName);
initializeLayout(title, columnHeaders);
sheet.createFreezePane(0, currentRowIndex);
}
代码示例来源:origin: org.apache.poi/poi-examples
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);
}
}
}
}
代码示例来源:origin: TomasKypta/android-lang-tool
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;
}
代码示例来源:origin: stackoverflow.com
style.setFillPattern(CellStyle.FINE_DOTS);
sheet.createFreezePane(0, 1); // Freeze 1st Row sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)
代码示例来源:origin: stackoverflow.com
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
sheet.createFreezePane(0, 1); // Freeze 1st Row sheet.createFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)
代码示例来源:origin: FenixEdu/fenixedu-academic
sheet.createFreezePane(0, 1, 0, 1);
sheet.autoSizeColumn(1, true);
sheet.autoSizeColumn(2, true);
代码示例来源:origin: org.metaeffekt.core/ae-inventory-processor
private void writeArtifacts(Inventory inventory, HSSFWorkbook myWorkBook) {
HSSFSheet mySheet = myWorkBook.createSheet("Artifact Inventory");
mySheet.createFreezePane(0, 1);
mySheet.setDefaultColumnWidth(20);
代码示例来源:origin: org.metaeffekt.core/ae-inventory-processor
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);
内容来源于网络,如有侵权,请联系作者删除!