Java Code Examples for org.apache.poi.hssf.usermodel.HSSFSheet#createFreezePane()
The following examples show how to use
org.apache.poi.hssf.usermodel.HSSFSheet#createFreezePane() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: ExportEventsImpl.java From neoscada with Eclipse Public License 1.0 | 5 votes |
|
private HSSFSheet createSheet ( final List<Event> events, final HSSFWorkbook workbook, final List<Field> columns )
{
final HSSFSheet sheet = workbook.createSheet ( Messages.ExportImpl_ExcelSheet_Name );
final HSSFHeader header = sheet.getHeader ();
header.setLeft ( Messages.ExportImpl_ExcelSheet_Header );
header.setRight ( HeaderFooter.date () + " " + HeaderFooter.time () );//$NON-NLS-1$
final HSSFFooter footer = sheet.getFooter ();
footer.setLeft ( String.format ( Messages.ExportImpl_ExcelSheet_Footer_1, events.size () ) );
footer.setRight ( Messages.ExportImpl_ExcelSheet_Footer_2 + HeaderFooter.page () + Messages.ExportImpl_ExcelSheet_Footer_3 + HeaderFooter.numPages () );
makeHeader ( columns, sheet );
final HSSFPrintSetup printSetup = sheet.getPrintSetup ();
printSetup.setLandscape ( true );
printSetup.setFitWidth ( (short)1 );
printSetup.setFitHeight ( (short)0 );
printSetup.setPaperSize ( PrintSetup.A4_PAPERSIZE );
sheet.setAutoFilter ( new CellRangeAddress ( 0, 0, 0, columns.size () - 1 ) );
sheet.createFreezePane ( 0, 1 );
sheet.setFitToPage ( true );
sheet.setAutobreaks ( true );
printSetup.setFooterMargin ( 0.25 );
sheet.setMargin ( Sheet.LeftMargin, 0.25 );
sheet.setMargin ( Sheet.RightMargin, 0.25 );
sheet.setMargin ( Sheet.TopMargin, 0.25 );
sheet.setMargin ( Sheet.BottomMargin, 0.5 );
return sheet;
}
Example 2
| Source File: CourseLoadOverviewBean.java From fenixedu-academic with GNU Lesser General Public License v3.0 | 4 votes |
|
public StyledExcelSpreadsheet getInconsistencySpreadsheet() {
final StyledExcelSpreadsheet spreadsheet =
new StyledExcelSpreadsheet(BundleUtil.getString(Bundle.ACADEMIC, "label.course.load.inconsistency.filename")
+ "_" + executionSemester.getExecutionYear().getYear().replace('/', '_') + "_"
+ executionSemester.getSemester());
CellStyle normalStyle = spreadsheet.getExcelStyle().getValueStyle();
normalStyle.setAlignment(HorizontalAlignment.CENTER);
HSSFWorkbook wb = spreadsheet.getWorkbook();
HSSFFont font = wb.createFont();
font.setColor(HSSFColor.BLACK.index);
font.setFontHeightInPoints((short) 8);
HSSFCellStyle redStyle = wb.createCellStyle();
redStyle.setFont(font);
redStyle.setAlignment(HorizontalAlignment.CENTER);
redStyle.setFillForegroundColor(HSSFColor.ORANGE.index);
redStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
HSSFCellStyle yellowStyle = wb.createCellStyle();
yellowStyle.setFont(font);
yellowStyle.setAlignment(HorizontalAlignment.CENTER);
yellowStyle.setFillForegroundColor(HSSFColor.YELLOW.index);
yellowStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
spreadsheet.newHeaderRow();
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.department"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.degree"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.executionCourse"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.shift"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.shiftType"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.competenceCourse"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.curricularCourse"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.executionCourse"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.lessonInstances"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.lesson.count"));
spreadsheet.addHeader(BundleUtil.getString(Bundle.ACADEMIC, "label.load.lessonInstances.count"));
for (final ExecutionCourse executionCourse : executionSemester.getAssociatedExecutionCoursesSet()) {
for (final CourseLoad courseLoad : executionCourse.getCourseLoadsSet()) {
for (final Shift shift : courseLoad.getShiftsSet()) {
spreadsheet.newRow();
spreadsheet.addCell(getDepartmentString(executionCourse));
spreadsheet.addCell(executionCourse.getDegreePresentationString());
spreadsheet.addCell(executionCourse.getName());
spreadsheet.addCell(shift.getNome());
spreadsheet.addCell(courseLoad.getType().getFullNameTipoAula());
final BigDecimal competenceCourseLoad =
new BigDecimal(getCompetenceCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
final BigDecimal curricularCourseLoad =
new BigDecimal(getCurricularCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
final BigDecimal executionLoad = courseLoad.getTotalQuantity().setScale(2, RoundingMode.HALF_EVEN);
final BigDecimal shiftCourseLoad = getShiftCourseLoad(shift).setScale(2, RoundingMode.HALF_EVEN);
if (competenceCourseLoad.signum() < 0) {
spreadsheet.addCell(getCompetenceCourseLoadStrings(courseLoad), redStyle);
} else {
spreadsheet.addCell(competenceCourseLoad);
}
if (!competenceCourseLoad.equals(curricularCourseLoad) || curricularCourseLoad.signum() < 0) {
spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
} else {
spreadsheet.addCell(curricularCourseLoad);
}
if (!executionLoad.equals(curricularCourseLoad)) {
spreadsheet.addCell(executionLoad, redStyle);
} else {
spreadsheet.addCell(executionLoad);
}
if (!shiftCourseLoad.equals(executionLoad)) {
if (isLargeDifference(shiftCourseLoad, executionLoad,
competenceCourseLoad.divide(new BigDecimal(14), 2, RoundingMode.HALF_EVEN))) {
spreadsheet.addCell(shiftCourseLoad, redStyle);
} else {
spreadsheet.addCell(shiftCourseLoad, yellowStyle);
}
} else {
spreadsheet.addCell(shiftCourseLoad);
}
spreadsheet.addCell(shift.getAssociatedLessonsSet().size());
spreadsheet.addCell(getLessonInstanceCount(shift));
}
}
}
final HSSFSheet sheet = wb.getSheetAt(0);
sheet.createFreezePane(0, 1, 0, 1);
sheet.autoSizeColumn(1, true);
sheet.autoSizeColumn(2, true);
sheet.autoSizeColumn(3, true);
sheet.autoSizeColumn(4, true);
sheet.autoSizeColumn(5, true);
sheet.autoSizeColumn(6, true);
sheet.autoSizeColumn(7, true);
sheet.autoSizeColumn(8, true);
sheet.autoSizeColumn(9, true);
return spreadsheet;
}
Example 3
| Source File: ExcelExportSuper.java From phone with Apache License 2.0 | 2 votes |
|
/**
* 在excel表格生成完成后执行的方法
* 默认是锁定表头
* @param sheet
*/
protected void completeAfter(HSSFSheet sheet){
sheet.createFreezePane(3, 2);
}
