Java Code Examples for org.apache.poi.xssf.streaming.SXSSFWorkbook#createFont()
The following examples show how to use
org.apache.poi.xssf.streaming.SXSSFWorkbook#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: ExcelWriter.java From excel-boot with Artistic License 2.0 | 5 votes |
|
public CellStyle getHeaderCellStyle(SXSSFWorkbook workbook) {
if (headCellStyle == null) {
headCellStyle = workbook.getXSSFWorkbook().createCellStyle();
headCellStyle.setBorderTop(BorderStyle.NONE);
headCellStyle.setBorderRight(BorderStyle.NONE);
headCellStyle.setBorderBottom(BorderStyle.NONE);
headCellStyle.setBorderLeft(BorderStyle.NONE);
headCellStyle.setAlignment(HorizontalAlignment.CENTER);
headCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
XSSFColor color = new XSSFColor(new java.awt.Color(217, 217, 217));
headCellStyle.setFillForegroundColor(color);
headCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
Font font = workbook.createFont();
font.setFontName("微软雅黑");
font.setColor(IndexedColors.ROYAL_BLUE.index);
font.setBold(true);
headCellStyle.setFont(font);
headCellStyle.setDataFormat(workbook.createDataFormat().getFormat("@"));
}
return headCellStyle;
}
Example 2
| Source File: CommonsUtils.java From czy-nexus-commons-utils with Apache License 2.0 | 5 votes |
|
/**
* 大标题样式
*
* @param wb
* @param cell
* @param sxssfRow
*/
public static void setLabelStyles(SXSSFWorkbook wb, Cell cell, SXSSFRow sxssfRow) {
CellStyle cellStyle = wb.createCellStyle();
cellStyle.setAlignment(HorizontalAlignment.CENTER);
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
sxssfRow.setHeight((short) (399 * 2));
XSSFFont font = (XSSFFont) wb.createFont();
font.setFontName("宋体");
font.setFontHeight(16);
cellStyle.setFont(font);
cell.setCellStyle(cellStyle);
}
Example 3
| Source File: ExcelUtil.java From agile-service-old with Apache License 2.0 | 5 votes |
|
/**
* 创建单元格样式
*
* @param workbook 工作簿
* @param fontSize 字体大小
* @return 单元格样式
*/
private static CellStyle createCellStyle(SXSSFWorkbook workbook, short fontSize, short aligment, Boolean bold) {
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setAlignment(aligment);
//垂直居中
cellStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
org.apache.poi.ss.usermodel.Font font = workbook.createFont();
if (bold) {
//加粗字体
font.setBoldweight(org.apache.poi.ss.usermodel.Font.BOLDWEIGHT_BOLD);
}
font.setFontHeightInPoints(fontSize);
cellStyle.setFont(font);
return cellStyle;
}
Example 4
| Source File: TitleStyleBuilder.java From bdf3 with Apache License 2.0 | 5 votes |
|
private XSSFCellStyle createXSSFCellStyle(Workbook wb, int[] bgColor, int[] fontColor, int fontSize) {
SXSSFWorkbook workbook = (SXSSFWorkbook) wb;
XSSFFont titleFont = (XSSFFont) workbook.createFont();
titleFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
titleFont.setFontName("宋体");
XSSFColor color9 = new XSSFColor(new java.awt.Color(fontColor[0], fontColor[1], fontColor[2]));
XSSFColor color10 = new XSSFColor(new java.awt.Color(bgColor[0], bgColor[1], bgColor[2]));
if (!(fontColor[0] == 0 && fontColor[1] == 0 && fontColor[2] == 0)) {
titleFont.setColor(color9);
}
titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
titleFont.setFontHeightInPoints((short) fontSize);
XSSFCellStyle titleStyle = (XSSFCellStyle) createBorderCellStyle(workbook, true);
titleStyle.setFont(titleFont);
titleStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
titleStyle.setFillForegroundColor(color10);
titleStyle.setAlignment(CellStyle.ALIGN_CENTER);
titleStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
return titleStyle;
}
Example 5
| Source File: CommonsUtils.java From czy-nexus-commons-utils with Apache License 2.0 | 4 votes |
|
/**
* @param cell Cell对象。
* @param wb SXSSFWorkbook对象。
* @param fontSize 字体大小。
* @param bold 是否加粗。
* @param center 是否左右上下居中。
* @param isBorder 是否忽略边框
* @param leftBoolean 左对齐
* @param rightBoolean 右对齐
* @param height 行高
*/
public static void setExcelStyles(Cell cell, SXSSFWorkbook wb, SXSSFRow sxssfRow, Integer fontSize, Boolean bold, Boolean center, Boolean isBorder, Boolean leftBoolean,
Boolean rightBoolean, Integer fontColor, Integer height) {
CellStyle cellStyle = cell.getRow().getSheet().getWorkbook().createCellStyle();
//保证了既可以新建一个CellStyle，又可以不丢失原来的CellStyle 的样式
cellStyle.cloneStyleFrom(cell.getCellStyle());
//左右居中、上下居中
if (center != null && center) {
cellStyle.setAlignment(HorizontalAlignment.CENTER);
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
}
//右对齐
if (rightBoolean != null && rightBoolean) {
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
cellStyle.setAlignment(HorizontalAlignment.RIGHT);
}
//左对齐
if (leftBoolean != null && leftBoolean) {
cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
cellStyle.setAlignment(HorizontalAlignment.LEFT);
}
//是否忽略边框
if (isBorder != null && isBorder) {
setBorderColor(cellStyle, isBorder);
}
//设置单元格字体样式
XSSFFont font = (XSSFFont) wb.createFont();
if (bold != null && bold) {
font.setBold(bold);
}
//行高
if (height != null) {
sxssfRow.setHeight((short) (height * 2));
}
font.setFontName("宋体");
font.setFontHeight(fontSize == null ? 12 : fontSize);
cellStyle.setFont(font);
// 点击可查看颜色对应的值： BLACK(8), WHITE(9), RED(10),
font.setColor(IndexedColors.fromInt(fontColor == null ? 8 : fontColor).index);
cell.setCellStyle(cellStyle);
}
Example 6
| Source File: CommonsUtils.java From czy-nexus-commons-utils with Apache License 2.0 | 4 votes |
|
/**
* 设置数据：无样式（行、列、单元格样式）
*
* @param wb
* @param sxssfRow
* @param dataLists
* @param regionMap
* @param columnMap
* @param paneMap
* @param sheetName
* @param labelName
* @param dropDownMap
* @throws Exception
*/
public static void setDataListNoStyle(SXSSFWorkbook wb, SXSSFRow sxssfRow, List<List<String[]>> dataLists, HashMap regionMap,
HashMap columnMap, HashMap paneMap, String[] sheetName, String[] labelName, HashMap dropDownMap,Integer defaultColumnWidth,Integer fontSize) throws Exception {
if (dataLists == null) {
log.debug("=== === === :Andyczy ExcelUtils Exception Message：Export data(type:List<List<String[]>>) cannot be empty!");
}
if (sheetName == null) {
log.debug("=== === === :Andyczy ExcelUtils Exception Message：Export sheet(type:String[]) name cannot be empty!");
}
int k = 0;
for (List<String[]> listRow : dataLists) {
SXSSFSheet sxssfSheet = wb.createSheet();
sxssfSheet.setDefaultColumnWidth(defaultColumnWidth);
wb.setSheetName(k, sheetName[k]);
CellStyle cellStyle = wb.createCellStyle();
XSSFFont font = (XSSFFont) wb.createFont();
int jRow = 0;
// 自定义：大标题（看该方法说明）。
jRow = setLabelName(jRow, k, wb, labelName, sxssfRow, sxssfSheet, listRow);
// 自定义：每个表格固定表头（看该方法说明）。
Integer pane = 1;
if (paneMap != null && paneMap.get(k + 1) != null) {
pane = (Integer) paneMap.get(k + 1) + (labelName != null ? 1 : 0);
createFreezePane(sxssfSheet, pane);
}
// 自定义：每个单元格自定义合并单元格：对每个单元格自定义合并单元格（看该方法说明）。
if (regionMap != null) {
setMergedRegion(sxssfSheet, (ArrayList<Integer[]>) regionMap.get(k + 1));
}
// 自定义：每个单元格自定义下拉列表：对每个单元格自定义下拉列表（看该方法说明）。
if (dropDownMap != null) {
setDataValidation(sxssfSheet, (List<String[]>) dropDownMap.get(k + 1), listRow.size());
}
// 自定义：每个表格自定义列宽：对每个单元格自定义列宽（看该方法说明）。
if (columnMap != null) {
setColumnWidth(sxssfSheet, (HashMap) columnMap.get(k + 1));
}
// 默认样式。
setStyle(cellStyle, font,fontSize);
// 写入小标题与数据。
Integer SIZE = listRow.size() < MAX_ROWSUM ? listRow.size() : MAX_ROWSUM;
for (int i = 0; i < SIZE; i++) {
sxssfRow = sxssfSheet.createRow(jRow);
for (int j = 0; j < listRow.get(i).length; j++) {
Cell cell = createCell(sxssfRow, j, listRow.get(i)[j]);
cell.setCellStyle(cellStyle);
}
jRow++;
}
k++;
}
}
Example 7
| Source File: ReportExcelUtil.java From roncoo-education with MIT License | 4 votes |
|
public static void exportExcelForLecturerProfit(HttpServletResponse response, Page<LecturerProfitVO> result) throws IOException {
// 创建一个workbook 对应一个excel文件
final SXSSFWorkbook workBook = new SXSSFWorkbook();
SXSSFSheet sheet = workBook.createSheet("讲师分润报表");
// 列名和列宽
String[] names = { "讲师名称", "银行卡号", "银行名称", "银行开户名", "讲师分润（元）", "平台分润（元）", "时间" };// 表头
Integer[] widths = { 25, 15, 15, 25, 25, 25, 25 };// 列宽
// 创建第一行
SXSSFRow row = sheet.createRow(0);
// 设置第一行样式
CellStyle headStyle = workBook.createCellStyle();
headStyle.setAlignment(HorizontalAlignment.CENTER_SELECTION);// 水平居中
headStyle.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直居中
// 设置第一行字体
Font headFont = workBook.createFont();
headFont.setBold(true);
headStyle.setFont(headFont);
// 设置第一行单元格内容、单元格样式
for (int i = 0; i < names.length; i++) {
SXSSFCell cell = row.createCell(i);
cell.setCellValue(names[i]);
cell.setCellStyle(headStyle);
sheet.setColumnWidth(i, widths[i] * 256);
}
// 从第二行开始遍历出分润记录表的数据，再写入单元格
SXSSFRow row1 = sheet.createRow(1);
int r = 1;
for (LecturerProfitVO bean : result.getList()) {
row1 = sheet.createRow(r++);
row1.createCell(0).setCellValue(bean.getLecturerVO().getLecturerName());
row1.createCell(1).setCellValue(bean.getBankCardNo());
row1.createCell(2).setCellValue(bean.getBankName());
row1.createCell(3).setCellValue(bean.getBankUserName());
row1.createCell(4).setCellValue(bean.getLecturerProfit().doubleValue());
row1.createCell(5).setCellValue(bean.getPlatformProfit().doubleValue());
row1.createCell(6).setCellValue(new SimpleDateFormat("yyyy/MM/dd").format(bean.getGmtCreate()));
}
try {
workBook.write(response.getOutputStream());
response.getOutputStream().flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (response.getOutputStream() != null)
response.getOutputStream().close();
if (workBook != null)
workBook.close();
}
}
Example 8
| Source File: GridStyleBuilder.java From bdf3 with Apache License 2.0 | 4 votes |
|
private Map<String, CellStyle> createXSSFCellStyles(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>();
SXSSFWorkbook workbook = (SXSSFWorkbook) wb;
XSSFColor xssfContextBgColor = new XSSFColor(new java.awt.Color(contextBgColor[0], contextBgColor[1], contextBgColor[2]));
XSSFColor xssfContextFontColor = new XSSFColor(new java.awt.Color(contextFontColor[0], contextFontColor[1], contextFontColor[2]));
XSSFColor xssfHeaderBgColor = new XSSFColor(new java.awt.Color(headerBgColor[0], headerBgColor[1], headerBgColor[2]));
XSSFColor xssfHeaderFontColor = new XSSFColor(new java.awt.Color(headerFontColor[0], headerFontColor[1], headerFontColor[2]));
XSSFFont headerFont = (XSSFFont) workbook.createFont();
headerFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
headerFont.setFontName("宋体");
if (!(headerFontColor[0] == 0 && headerFontColor[1] == 0 && headerFontColor[2] == 0)) {
headerFont.setColor(xssfHeaderFontColor);
}
headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
headerFont.setFontHeightInPoints((short) headerFontSize);
XSSFCellStyle headerStyle = (XSSFCellStyle) this.createBorderCellStyle(workbook, true);
headerStyle.setFont(headerFont);
headerStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
headerStyle.setFillForegroundColor(xssfHeaderBgColor);
this.setCellStyleAligment(headerStyle, headerAlign);
headerStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
styles.put(GridStyleType.headerStyle.name(), headerStyle);
XSSFFont dataFont = (XSSFFont) workbook.createFont();
if (!(contextFontColor[0] == 0 && contextFontColor[1] == 0 && contextFontColor[2] == 0)) {
dataFont.setColor(xssfContextFontColor);
}
dataFont.setFontHeightInPoints((short) contextFontSize);
dataFont.setCharSet(HSSFFont.DEFAULT_CHARSET);
dataFont.setFontName("宋体");
XSSFCellStyle dataAlignLeftStyle = (XSSFCellStyle) this.createBorderCellStyle(workbook, true);
dataAlignLeftStyle.setFont(dataFont);
dataAlignLeftStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignLeftStyle.setFillForegroundColor(xssfContextBgColor);
dataAlignLeftStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignLeftStyle.setWrapText(true);
dataAlignLeftStyle.setAlignment(CellStyle.ALIGN_LEFT);
styles.put(GridStyleType.dataAlignLeftStyle.name(), dataAlignLeftStyle);
XSSFCellStyle dataAlignCenterStyle = (XSSFCellStyle) this.createBorderCellStyle(workbook, true);
dataAlignCenterStyle.setFont(dataFont);
dataAlignCenterStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignCenterStyle.setFillForegroundColor(xssfContextBgColor);
dataAlignCenterStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignCenterStyle.setWrapText(true);
dataAlignCenterStyle.setAlignment(CellStyle.ALIGN_CENTER);
styles.put(GridStyleType.dataAlignCenterStyle.name(), dataAlignCenterStyle);
XSSFCellStyle dataAlignRightStyle = (XSSFCellStyle) this.createBorderCellStyle(workbook, true);
dataAlignRightStyle.setFont(dataFont);
dataAlignRightStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dataAlignRightStyle.setFillForegroundColor(xssfContextBgColor);
dataAlignRightStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
dataAlignRightStyle.setWrapText(true);
dataAlignRightStyle.setAlignment(CellStyle.ALIGN_RIGHT);
styles.put(GridStyleType.dataAlignRightStyle.name(), dataAlignRightStyle);
XSSFCellStyle dateStyle = (XSSFCellStyle) this.createBorderCellStyle(workbook, true);
CreationHelper helper = workbook.getCreationHelper();
dateStyle.setDataFormat(helper.createDataFormat().getFormat("m/d/yy h:mm"));
dateStyle.setFont(dataFont);
dateStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
dateStyle.setFillForegroundColor(xssfContextBgColor);
dateStyle.setVerticalAlignment(CellStyle.ALIGN_CENTER);
this.setCellStyleAligment(dateStyle, contextFontAlign);
styles.put(GridStyleType.dateStyle.name(), dateStyle);
return styles;
}
