Java Code Examples for org.apache.poi.hssf.usermodel.HSSFWorkbook#createFont()
The following examples show how to use
org.apache.poi.hssf.usermodel.HSSFWorkbook#createFont() .
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: TitleStyleBuilder.java From bdf3 with Apache License 2.0 | 6 votes |
|
private HSSFCellStyle createHSSFCellStyle(Workbook wb, int[] bgColor, int[] fontColor, int fontSize) {
HSSFWorkbook workbook = (HSSFWorkbook) wb;
HSSFPalette palette = workbook.getCustomPalette();
palette.setColorAtIndex((short) 9, (byte) fontColor[0], (byte) fontColor[1], (byte) fontColor[2]);
palette.setColorAtIndex((short) 10, (byte) bgColor[0], (byte) bgColor[1], (byte) bgColor[2]);
HSSFFont titleFont = workbook.createFont();
titleFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
titleFont.setFontName("宋体");
titleFont.setColor((short) 9);
titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
titleFont.setFontHeightInPoints((short) fontSize);
HSSFCellStyle titleStyle = (HSSFCellStyle) createBorderCellStyle(workbook, true);
titleStyle.setFont(titleFont);
titleStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
titleStyle.setFillForegroundColor((short) 10);
titleStyle.setAlignment(CellStyle.ALIGN_CENTER);
titleStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
return titleStyle;
}
Example 2
| Source File: POIUtils.java From ermasterr with Apache License 2.0 | 6 votes |
|
public static HSSFFont copyFont(final HSSFWorkbook workbook, final HSSFFont font) {
final HSSFFont newFont = workbook.createFont();
// newFont.setBoldweight(font.getBoldweight());
// newFont.setCharSet(font.getCharSet());
// newFont.setColor(font.getColor());
// newFont.setFontHeight(font.getFontHeight());
// newFont.setFontHeightInPoints(font.getFontHeightInPoints());
// newFont.setFontName(font.getFontName());
// newFont.setItalic(font.getItalic());
// newFont.setStrikeout(font.getStrikeout());
// newFont.setTypeOffset(font.getTypeOffset());
// newFont.setUnderline(font.getUnderline());
return newFont;
}
Example 3
| Source File: TestExportExcel.java From poi with Apache License 2.0 | 6 votes |
|
@Test
public void exportExcelWithStyle() {
try {
String filePath = TestUtil.DOC_PATH + File.separator
+ Globals.EXPORT_PRODUCT;
OutputStream os = new FileOutputStream(filePath);
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet(Globals.SHEETNAME);
HSSFRichTextString richString = new HSSFRichTextString(
TestUtil.RICH_TEXT_STRING);
HSSFFont font = wb.createFont();
font.setColor(IndexedColors.BLUE.index);
richString.applyFont(font);
sheet.createRow(0).createCell(0).setCellValue(richString);
wb.write(os);
os.close();
} catch (Exception e) {
e.printStackTrace();
}
}
Example 4
| Source File: POIUtils.java From ermaster-b with Apache License 2.0 | 6 votes |
|
public static HSSFFont copyFont(HSSFWorkbook workbook, HSSFFont font) {
HSSFFont newFont = workbook.createFont();
// newFont.setBoldweight(font.getBoldweight());
// newFont.setCharSet(font.getCharSet());
// newFont.setColor(font.getColor());
// newFont.setFontHeight(font.getFontHeight());
// newFont.setFontHeightInPoints(font.getFontHeightInPoints());
// newFont.setFontName(font.getFontName());
// newFont.setItalic(font.getItalic());
// newFont.setStrikeout(font.getStrikeout());
// newFont.setTypeOffset(font.getTypeOffset());
// newFont.setUnderline(font.getUnderline());
return newFont;
}
Example 5
| Source File: ExcelExportUtil.java From jeewx with Apache License 2.0 | 5 votes |
|
/**
* 表明的Style
* @param workbook
* @return
*/
public static HSSFCellStyle getHeaderStyle(HSSFWorkbook workbook, ExcelTitle entity) {
HSSFCellStyle titleStyle = workbook.createCellStyle();
Font font = workbook.createFont();
font.setFontHeightInPoints((short) 24);
titleStyle.setFont(font);
titleStyle.setFillForegroundColor(entity.getColor());
titleStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
titleStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
return titleStyle;
}
Example 6
| Source File: ExportUtils.java From tech-gallery with Apache License 2.0 | 5 votes |
|
private static void makeRowBold(HSSFWorkbook wb, Row row) {
CellStyle style = wb.createCellStyle();
Font font = wb.createFont();
font.setBold(true);
style.setFont(font);
for (int i = 0; i < row.getLastCellNum(); i++) {
row.getCell(i).setCellStyle(style);
}
}
Example 7
| Source File: ExportUtil.java From jumbune with GNU Lesser General Public License v3.0 | 5 votes |
|
/**
* Sets header style
* @param worksheet the worksheet
* @param fontName font name
* @param fontColor font color
* @param fontBoldweight font weight
*/
public static void setHeaderStyle(Worksheet worksheet, String fontName,
short fontColor, short fontBoldweight) {
HSSFWorkbook workbook = worksheet.getWorkbook();
HSSFFont font = workbook.createFont();
font.setFontName(fontName);
font.setColor(fontColor);
font.setBoldweight(fontBoldweight);
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setFont(font);
worksheet.setCellStyle(cellStyle);
}
Example 8
| Source File: InvestmentSummaryController.java From primefaces-blueprints with The Unlicense | 5 votes |
|
public void postProcessXLS(Object document) {
HSSFWorkbook wb = (HSSFWorkbook) document;
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow header = sheet.getRow(0);
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setFillForegroundColor(HSSFColor.GREEN.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
for(int i=0; i < header.getPhysicalNumberOfCells();i++) {
HSSFCell cell = header.getCell(i);
cell.setCellStyle(cellStyle);
}
Row row=sheet.createRow((short)sheet.getLastRowNum()+3);
Cell cellDisclaimer = row.createCell(0);
HSSFFont customFont= wb.createFont();
customFont.setFontHeightInPoints((short)10);
customFont.setFontName("Arial");
customFont.setColor(IndexedColors.BLACK.getIndex());
customFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
customFont.setItalic(true);
cellDisclaimer.setCellValue("Disclaimer");
HSSFCellStyle cellStyleDisclaimer = wb.createCellStyle();
cellStyleDisclaimer.setFont(customFont);
cellDisclaimer.setCellStyle(cellStyleDisclaimer);
Row row1=sheet.createRow(sheet.getLastRowNum()+2);
Cell cellDisclaimerContent1 = row1.createCell(0);
cellDisclaimerContent1.setCellValue("The information contained in this website is for information purposes only, and does not constitute, nor is it intended to constitute, the provision of financial product advice.");
Row row2=sheet.createRow(sheet.getLastRowNum()+1);
Cell cellDisclaimerContent2 = row2.createCell(0);
cellDisclaimerContent2.setCellValue("This website is intended to track the investor account summary information,investments and transaction in a partcular period of time. ");
}
Example 9
| Source File: AccountSummaryController.java From primefaces-blueprints with The Unlicense | 5 votes |
|
public void postProcessXLS(Object document) {
HSSFWorkbook wb = (HSSFWorkbook) document;
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow header = sheet.getRow(0);
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setFillForegroundColor(HSSFColor.GREEN.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
for(int i=0; i < header.getPhysicalNumberOfCells();i++) {
HSSFCell cell = header.getCell(i);
cell.setCellStyle(cellStyle);
}
Row row=sheet.createRow((short)sheet.getLastRowNum()+3);
Cell cellDisclaimer = row.createCell(0);
HSSFFont customFont= wb.createFont();
customFont.setFontHeightInPoints((short)10);
customFont.setFontName("Arial");
customFont.setColor(IndexedColors.BLACK.getIndex());
customFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
customFont.setItalic(true);
cellDisclaimer.setCellValue("Disclaimer");
HSSFCellStyle cellStyleDisclaimer = wb.createCellStyle();
cellStyleDisclaimer.setFont(customFont);
cellDisclaimer.setCellStyle(cellStyleDisclaimer);
Row row1=sheet.createRow(sheet.getLastRowNum()+2);
Cell cellDisclaimerContent1 = row1.createCell(0);
cellDisclaimerContent1.setCellValue("The information contained in this website is for information purposes only, and does not constitute, nor is it intended to constitute, the provision of financial product advice.");
Row row2=sheet.createRow(sheet.getLastRowNum()+1);
Cell cellDisclaimerContent2 = row2.createCell(0);
cellDisclaimerContent2.setCellValue("This website is intended to track the investor account summary information,investments and transaction in a partcular period of time. ");
}
Example 10
| Source File: TransactionSummaryController.java From primefaces-blueprints with The Unlicense | 5 votes |
|
public void postProcessXLS(Object document) {
HSSFWorkbook wb = (HSSFWorkbook) document;
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow header = sheet.getRow(0);
HSSFCellStyle cellStyle = wb.createCellStyle();
cellStyle.setFillForegroundColor(HSSFColor.GREEN.index);
cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
for (int i = 0; i < header.getPhysicalNumberOfCells(); i++) {
HSSFCell cell = header.getCell(i);
cell.setCellStyle(cellStyle);
}
Row row = sheet.createRow((short) sheet.getLastRowNum() + 3);
Cell cellDisclaimer = row.createCell(0);
HSSFFont customFont = wb.createFont();
customFont.setFontHeightInPoints((short) 10);
customFont.setFontName("Arial");
customFont.setColor(IndexedColors.BLACK.getIndex());
customFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
customFont.setItalic(true);
cellDisclaimer.setCellValue("Disclaimer");
HSSFCellStyle cellStyleDisclaimer = wb.createCellStyle();
cellStyleDisclaimer.setFont(customFont);
cellDisclaimer.setCellStyle(cellStyleDisclaimer);
Row row1 = sheet.createRow(sheet.getLastRowNum() + 2);
Cell cellDisclaimerContent1 = row1.createCell(0);
cellDisclaimerContent1
.setCellValue("The information contained in this website is for information purposes only, and does not constitute, nor is it intended to constitute, the provision of financial product advice.");
Row row2 = sheet.createRow(sheet.getLastRowNum() + 1);
Cell cellDisclaimerContent2 = row2.createCell(0);
cellDisclaimerContent2
.setCellValue("This website is intended to track the investor account summary information,investments and transaction in a partcular period of time. ");
}
Example 11
| Source File: GridStyleBuilder.java From bdf3 with Apache License 2.0 | 4 votes |
|
private Map<String, CellStyle> createHSSFCellStyles(Workbook wb, int[] contextBgColor, int[] contextFontColor, int contextFontSize, int contextFontAlign, int[] headerBgColor,
int[] headerFontColor, int headerFontSize, int headerAlign) {
Map<String, CellStyle> styles = new HashMap<String, CellStyle>();
HSSFWorkbook workbook = (HSSFWorkbook) wb;
HSSFPalette palette = workbook.getCustomPalette();
palette.setColorAtIndex((short) 11, (byte) contextBgColor[0], (byte) contextBgColor[1], (byte) contextBgColor[2]);
palette.setColorAtIndex((short) 12, (byte) contextFontColor[0], (byte) contextFontColor[1], (byte) contextFontColor[2]);
palette.setColorAtIndex((short) 13, (byte) headerBgColor[0], (byte) headerBgColor[1], (byte) headerBgColor[2]);
palette.setColorAtIndex((short) 14, (byte) headerFontColor[0], (byte) headerFontColor[1], (byte) headerFontColor[2]);
HSSFFont headerFont = workbook.createFont();
headerFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
headerFont.setFontName("宋体");
headerFont.setColor((short) 14);
headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
headerFont.setFontHeightInPoints((short) headerFontSize);
CellStyle headerStyle = this.createBorderCellStyle(workbook, true);
headerStyle.setFont(headerFont);
headerStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
headerStyle.setFillForegroundColor((short) 13);
this.setCellStyleAligment(headerStyle, headerAlign);
headerStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
styles.put(GridStyleType.headerStyle.name(), headerStyle);
HSSFFont dataFont = workbook.createFont();
dataFont.setColor((short) 12);
dataFont.setFontHeightInPoints((short) contextFontSize);
dataFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
dataFont.setFontName("宋体");
CellStyle dataAlignLeftStyle = this.createBorderCellStyle(workbook, true);
dataAlignLeftStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignLeftStyle.setFillForegroundColor((short) 11);
dataAlignLeftStyle.setFont(dataFont);
dataAlignLeftStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignLeftStyle.setWrapText(true);
dataAlignLeftStyle.setAlignment(CellStyle.ALIGN_LEFT);
styles.put(GridStyleType.dataAlignLeftStyle.name(), dataAlignLeftStyle);
CellStyle dataAlignCenterStyle = this.createBorderCellStyle(workbook, true);
dataAlignCenterStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignCenterStyle.setFillForegroundColor((short) 11);
dataAlignCenterStyle.setFont(dataFont);
dataAlignCenterStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignCenterStyle.setWrapText(true);
dataAlignCenterStyle.setAlignment(CellStyle.ALIGN_CENTER);
styles.put(GridStyleType.dataAlignCenterStyle.name(), dataAlignCenterStyle);
CellStyle dataAlignRightStyle = this.createBorderCellStyle(workbook, true);
dataAlignRightStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignRightStyle.setFillForegroundColor((short) 11);
dataAlignRightStyle.setFont(dataFont);
dataAlignRightStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignRightStyle.setWrapText(true);
dataAlignRightStyle.setAlignment(CellStyle.ALIGN_RIGHT);
styles.put(GridStyleType.dataAlignRightStyle.name(), dataAlignRightStyle);
CellStyle dateStyle = this.createBorderCellStyle(workbook, true);
CreationHelper helper = workbook.getCreationHelper();
dateStyle.setDataFormat(helper.createDataFormat().getFormat("m/d/yy h:mm"));
dateStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dateStyle.setFillForegroundColor((short) 11);
dateStyle.setFont(dataFont);
dateStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
this.setCellStyleAligment(dateStyle, contextFontAlign);
styles.put(GridStyleType.dateStyle.name(), dateStyle);
return styles;
}
Example 12
| Source File: HRExcelBuilder.java From Spring-MVC-Blueprints with MIT License | 4 votes |
|
@Override
protected void buildExcelDocument(Map<String, Object> model,
HSSFWorkbook workbook, HttpServletRequest request, HttpServletResponse response)
throws Exception {
// get data model which is passed by the Spring container
@SuppressWarnings("unchecked")
List<HrmsLogin> users = (List<HrmsLogin>) model.get("allUsers");
// create a new Excel sheet
HSSFSheet sheet = workbook.createSheet("User List");
sheet.setDefaultColumnWidth(30);
// create style for header cells
CellStyle style = workbook.createCellStyle();
Font font = workbook.createFont();
font.setFontName("Arial");
style.setFillForegroundColor(HSSFColor.BLUE.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
font.setColor(HSSFColor.WHITE.index);
style.setFont(font);
// create header row
HSSFRow header = sheet.createRow(0);
header.createCell(0).setCellValue("Employee ID");
header.getCell(0).setCellStyle(style);
header.createCell(1).setCellValue("Username");
header.getCell(1).setCellStyle(style);
header.createCell(2).setCellValue("Password");
header.getCell(2).setCellStyle(style);
header.createCell(3).setCellValue("Role");
header.getCell(3).setCellStyle(style);
// create data rows
int rowCount = 1;
for (HrmsLogin account : users) {
HSSFRow aRow = sheet.createRow(rowCount++);
aRow.createCell(0).setCellValue(account.getHrmsEmployeeDetails().getEmpId());
aRow.createCell(1).setCellValue(account.getUsername());
aRow.createCell(2).setCellValue(account.getPassword());
aRow.createCell(3).setCellValue(account.getRole());
}
}
Example 13
| 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;
}
