Java 类org.apache.poi.ss.usermodel.Font 实例源码
项目：neoscada
文件：ExportEventsImpl.java
private void makeHeader ( final List<Field> columns, final HSSFSheet sheet )
{
final Font font = sheet.getWorkbook ().createFont ();
font.setFontName ( "Arial" );
font.setBoldweight ( Font.BOLDWEIGHT_BOLD );
font.setColor ( HSSFColor.WHITE.index );
final CellStyle style = sheet.getWorkbook ().createCellStyle ();
style.setFont ( font );
style.setFillForegroundColor ( HSSFColor.BLACK.index );
style.setFillPattern ( PatternFormatting.SOLID_FOREGROUND );
final HSSFRow row = sheet.createRow ( 0 );
for ( int i = 0; i < columns.size (); i++ )
{
final Field field = columns.get ( i );
final HSSFCell cell = row.createCell ( i );
cell.setCellValue ( field.getHeader () );
cell.setCellStyle ( style );
}
}
项目：excel-utils
文件：CellStyleUtils.java
/** 创建每个CellStyle，并放到map之中
* @param workbook
* @param styleInfo
* @param dataFormat
* @return
*/
public static CellStyle doCreateCellStyle(Workbook workbook,ExportCellStyleInfo styleInfo,String dataFormat) {
if(styleInfo != null ){
CellStyle cellStyle = workbook.createCellStyle();
setStyleValue(ExportCellStyleInfo.class, cellStyle, styleInfo);
if(styleInfo.getFontStyleInfo() != null){
Font fontStyle = workbook.createFont();
setStyleValue(ExportFontStyleInfo.class, fontStyle, styleInfo.getFontStyleInfo());
cellStyle.setFont(fontStyle);
}
if(!StringUtils.isEmpty(dataFormat)){
short format = workbook.createDataFormat().getFormat(dataFormat);
cellStyle.setDataFormat(format);
}
return cellStyle;
}
return null;
}
项目：bdf2
文件：AbstractStyleBuilder.java
public void setCellStyleFont(Workbook workbook, CellStyle style, int i) {
Font font = workbook.createFont();
if (i == 0) {
// 正常
} else if (i == 4) {
// 下划线
font.setUnderline(Font.U_SINGLE);
style.setFont(font);
} else if (i == 2) {
// 倾斜
font.setItalic(true);
style.setFont(font);
} else if (i == 1) {
// 加粗
font.setBold(true);
style.setFont(font);
}
}
项目：vaadin-gridexport
文件：ExcelExport.java
/**
* Returns the default title style. Obtained from:
* http://svn.apache.org/repos/asf/poi
* /trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
*
* @param wb the wb
* @return the cell style
*/
protected CellStyle defaultTitleCellStyle(final Workbook wb) {
CellStyle style;
final Font titleFont = wb.createFont();
titleFont.setFontHeightInPoints((short) 18);
titleFont.setBold(true);
style = wb.createCellStyle();
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.CENTER);
style.setFont(titleFont);
return style;
}
项目：vaadin-gridexport
文件：ExcelExport.java
/**
* Returns the default header style. Obtained from:
* http://svn.apache.org/repos/asf/poi
* /trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
*
* @param wb the wb
* @return the cell style
*/
protected CellStyle defaultHeaderCellStyle(final Workbook wb) {
CellStyle style;
final Font monthFont = wb.createFont();
monthFont.setFontHeightInPoints((short) 11);
monthFont.setColor(IndexedColors.WHITE.getIndex());
style = wb.createCellStyle();
style.setAlignment(HorizontalAlignment.CENTER);
style.setVerticalAlignment(VerticalAlignment.CENTER);
style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
style.setFont(monthFont);
style.setWrapText(true);
return style;
}
项目：bdf2
文件：GridStyleBuilder.java
public CellStyle createIndentationCellStyle(Workbook workbook, int s) {
CellStyle dataStyle1 = this.createBorderCellStyle(workbook, true);
Font dataFont = workbook.createFont();
dataFont.setColor((short) 12);
dataFont.setFontHeightInPoints((short) 10);
dataStyle1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
dataStyle1.setFillForegroundColor((short) 11);
dataStyle1.setFont(dataFont);
dataStyle1.setVerticalAlignment(VerticalAlignment.CENTER);
dataStyle1.setAlignment(HorizontalAlignment.LEFT);
dataStyle1.setIndention(Short.valueOf(String.valueOf((s))));
return dataStyle1;
}
项目：bingexcel
文件：AbstractWriteHandler.java
CellStyle createHeadStyle() {
if (headerCellStyle != null) {
return headerCellStyle;
}
CellStyle style = wb.createCellStyle();
// 设置这些样式
style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.index);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
style.setAlignment(CellStyle.ALIGN_CENTER);
// 生成一个字体
Font font = wb.createFont();
font.setColor(IndexedColors.BLACK.index);
font.setFontHeightInPoints((short) 12);
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
// 把字体应用到当前的样式
style.setFont(font);
headerCellStyle = style;
return style;
}
项目：bingexcel
文件：AbstractWriteHandler.java
CellStyle createHeadDateStyle() {
if (headDateCellStyle != null) {
return headDateCellStyle;
}
CellStyle cellStyle = wb.createCellStyle();
DataFormat format = wb.createDataFormat();
cellStyle.setDataFormat(format.getFormat("m/d/yy h:mm"));
// 设置这些样式
cellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.index);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cellStyle.setAlignment(CellStyle.ALIGN_CENTER);
// 生成一个字体
Font font = wb.createFont();
font.setColor(IndexedColors.BLACK.index);
font.setFontHeightInPoints((short) 12);
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
// 把字体应用到当前的样式
cellStyle.setFont(font);
headDateCellStyle = cellStyle;
return cellStyle;
}
项目：owsi-core-parent
文件：AbstractExcelTableExport.java
/**
* Initialisation des polices
*/
protected void initFonts() {
Font fontHeader = workbook.createFont();
fontHeader.setFontHeightInPoints(getHeaderFontHeight());
fontHeader.setFontName(getFontName());
fontHeader.setBoldweight(Font.BOLDWEIGHT_BOLD);
setFontColor(fontHeader, colorRegistry, HEADER_FONT_COLOR_INDEX);
registerFont(FONT_HEADER_NAME, fontHeader);
Font fontNormal = workbook.createFont();
fontNormal.setFontHeightInPoints(getNormalFontHeight());
fontNormal.setFontName(getFontName());
registerFont(FONT_NORMAL_NAME, fontNormal);
Font fontLink = workbook.createFont();
fontLink.setFontHeightInPoints(getNormalFontHeight());
fontLink.setFontName(getFontName());
fontLink.setUnderline(Font.U_SINGLE);
setFontColor(fontLink, colorRegistry, LINK_FONT_COLOR_INDEX);
registerFont(FONT_LINK_NAME, fontLink);
}
项目：sigmah
文件：ExcelUtils.java
private CellStyle createLinkStyle(boolean bordered) {
final Font hlinkFont = wb.createFont();
hlinkFont.setUnderline(Font.U_SINGLE);
hlinkFont.setColor(IndexedColors.BLUE.getIndex());
final CellStyle style;
if (bordered) {
style = createBorderedStyle(wb);
} else {
style = wb.createCellStyle();
}
style.setFont(hlinkFont);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setIndention((short) 1);
style.setWrapText(true);
return style;
}
项目：fluentexcel
文件：XlsxRender.java
/**
* 初始化字体样式
*
* @param font
* @param fontBean
*/
private void initFont(Font font, FontStyleBean fontBean) {
font.setFontName(fontBean.getName());
font.setFontHeightInPoints(fontBean.getSize());
if (fontBean.getBoldWeight() != null) {
font.setBoldweight(fontBean.getBoldWeight());
}
if (fontBean.getItalic() != null) {
font.setItalic(fontBean.getItalic());
}
if (fontBean.getUnderLine() != null) {
font.setUnderline(fontBean.getUnderLine());
}
if (fontBean.getColor() != null) {
ColorBean cbean = fontBean.getColor();
((XSSFFont) font).setColor(new XSSFColor(new Color(cbean.getR(), cbean.getG(), cbean.getB())));
}
}
项目：NoraUi
文件：ExcelDataProvider.java
/**
* @throws TechnicalException
* is thrown if you have a technical error (format, configuration, datas, ...) in NoraUi.
*/
void openOutputData() throws TechnicalException {
this.dataOutExtension = validExtension(dataOutPath);
try (FileInputStream fileOut = new FileInputStream(dataOutPath + scenarioName + "." + dataOutExtension);) {
initWorkbook(fileOut, dataOutExtension);
} catch (final IOException e) {
throw new TechnicalException(Messages.getMessage(TechnicalException.TECHNICAL_ERROR_MESSAGE_DATA_IOEXCEPTION), e);
}
styleSuccess = workbook.createCellStyle();
final Font fontSuccess = workbook.createFont();
fontSuccess.setColor(HSSFColor.HSSFColorPredefined.GREEN.getIndex());
styleSuccess.setFont(fontSuccess);
styleFailed = workbook.createCellStyle();
final Font fontFailed = workbook.createFont();
fontFailed.setColor(HSSFColor.HSSFColorPredefined.RED.getIndex());
styleFailed.setFont(fontFailed);
styleWarning = workbook.createCellStyle();
final Font fontWarning = workbook.createFont();
fontWarning.setColor(HSSFColor.HSSFColorPredefined.ORANGE.getIndex());
styleWarning.setFont(fontWarning);
}
项目：ExcelHandle
文件：ExportExcel.java
/**
* 创建表格样式
* @param wb 工作薄对象
* @return 样式列表
*/
private Map<String, CellStyle> createStyles(Workbook wb) {
Map<String, CellStyle> styles = new HashMap<String, CellStyle>();
CellStyle style = wb.createCellStyle();
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
Font titleFont = wb.createFont();
titleFont.setFontName("Arial");
titleFont.setFontHeightInPoints((short) 16);
titleFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
style.setFont(titleFont);
styles.put("title", style);
style = wb.createCellStyle();
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderTop(CellStyle.BORDER_THIN);
style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
Font dataFont = wb.createFont();
dataFont.setFontName("Arial");
dataFont.setFontHeightInPoints((short) 10);
style.setFont(dataFont);
styles.put("data", style);
style = wb.createCellStyle();
style.cloneStyleFrom(styles.get("data"));
style.setAlignment(CellStyle.ALIGN_LEFT);
styles.put("data1", style);
style = wb.createCellStyle();
style.cloneStyleFrom(styles.get("data"));
style.setAlignment(CellStyle.ALIGN_CENTER);
styles.put("data2", style);
style = wb.createCellStyle();
style.cloneStyleFrom(styles.get("data"));
style.setAlignment(CellStyle.ALIGN_RIGHT);
styles.put("data3", style);
style = wb.createCellStyle();
style.cloneStyleFrom(styles.get("data"));
// style.setWrapText(true);
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
Font headerFont = wb.createFont();
headerFont.setFontName("Arial");
headerFont.setFontHeightInPoints((short) 10);
headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
headerFont.setColor(IndexedColors.WHITE.getIndex());
style.setFont(headerFont);
styles.put("header", style);
return styles;
}
项目：hy.common.report
文件：ExcelHelp.java
/**
* 复制字体
*
* @author ZhengWei(HY)
* @createDate 2017-03-18
* @version v1.0
*
* @param i_FromFont 源字体
* @param i_ToFont 目标字体
*/
public final static void copyFont(Font i_FromFont ,Font i_ToFont)
{
i_ToFont.setBold( i_FromFont.getBold());
i_ToFont.setCharSet( i_FromFont.getCharSet());
i_ToFont.setColor( i_FromFont.getColor());
i_ToFont.setFontHeight( i_FromFont.getFontHeight());
i_ToFont.setFontHeightInPoints(i_FromFont.getFontHeightInPoints());
i_ToFont.setFontName( i_FromFont.getFontName());
i_ToFont.setItalic( i_FromFont.getItalic());
i_ToFont.setStrikeout( i_FromFont.getStrikeout());
i_ToFont.setTypeOffset( i_FromFont.getTypeOffset());
i_ToFont.setUnderline( i_FromFont.getUnderline());
}
项目：hy.common.report
文件：RWorkbook.java
/**
* 创建一个新的字体，字体从i_DataCell中克隆出来。
*
* @author ZhengWei(HY)
* @createDate 2017-09-11
* @version v1.0
*
* @param i_ID 标记ID。由调用者设定
* @param i_DataCell 被克隆的单元格样式
* @return
*/
public synchronized Font getFontByCopy(String i_ID ,Cell i_DataCell ,RTemplate i_RTemplate)
{
Short v_FontID = this.fontsByCopy.get(i_ID);
Font v_Font = null;
if ( v_FontID == null )
{
v_Font = this.workbook.createFont();
ExcelHelp.copyFont(this.workbook.getFontAt(i_DataCell.getCellStyle().getFontIndex()) ,v_Font);
// 2017-09-20 动态格式的ID均加 Short.MAX_VALUE
this.fonts.putRow(i_RTemplate ,String.valueOf(Short.MAX_VALUE + v_Font.getIndex()) ,v_Font);
this.fontsByCopy.put(i_ID ,v_Font.getIndex());
}
else
{
v_Font = this.getFont(i_RTemplate ,Short.MAX_VALUE + v_FontID);
}
return v_Font;
}
项目：excel-rw-annotation
文件：StyleConfiguration.java
/**
* 设置通用的对齐居中、边框等
*
* @param style 样式
*/
private void setCommonStyle(CellStyle style) {
// 设置单元格居中对齐、自动换行
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setWrapText(true);
//设置单元格字体
if (!buildInFontMap.containsKey(FONT_KEY)) {
Font font = workbook.createFont();
//通用字体
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
buildInFontMap.put(FONT_KEY, font);
}
style.setFont(buildInFontMap.get(FONT_KEY));
// 设置单元格边框为细线条
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setBorderTop(CellStyle.BORDER_THIN);
}
项目：poilight
文件：PoiLightStyle.java
/**
* Fixed all properties suitable for cell-related style.
*
* @param workbook Excel Workbook
* @param boardStyle all properties suitable on the style of a cell
* @param font a font
* @return the customized style
*/
protected static CellStyle getCellStyle(Workbook workbook, TableStyle boardStyle, Font font) {
XSSFCellStyle cellStyle = (XSSFCellStyle) workbook.createCellStyle();
if (boardStyle.getFillColor() != null) {
cellStyle.setFillForegroundColor(boardStyle.getFillColor());
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
}
cellStyle.setBorderLeft(boardStyle.getCellBorderLeft());
cellStyle.setBorderRight(boardStyle.getCellBorderRight());
cellStyle.setBorderTop(boardStyle.getCellBorderTop());
cellStyle.setBorderBottom(boardStyle.getCellBorderBottom());
cellStyle.setAlignment(boardStyle.getAlignment());
cellStyle.setBorderColor(BorderSide.LEFT, boardStyle.getBorderColor());
cellStyle.setBorderColor(BorderSide.RIGHT, boardStyle.getBorderColor());
cellStyle.setBorderColor(BorderSide.TOP, boardStyle.getBorderColor());
cellStyle.setBorderColor(BorderSide.BOTTOM, boardStyle.getBorderColor());
if (font != null) {
cellStyle.setFont(font);
}
return cellStyle;
}
项目：poix
文件：StylerHelper.java
private void fontStyle(Font font) {
if (font.getBoldweight() >= Font.BOLDWEIGHT_BOLD)
out.format(" font-weight: bold;%n");
if (font.getItalic())
out.format(" font-style: italic;%n");
out.format(" font-family: %s;%n", font.getFontName());
int fontheight = font.getFontHeightInPoints();
if (fontheight == 9) {
fontheight = 10;
}
out.format(" font-size: %dpt;%n", fontheight);
helper.styleColor(out, "color", getColor(font));
}
项目：easypoi
文件：StylerHelper.java
private void fontStyle(Font font) {
if (font.getBoldweight() >= Font.BOLDWEIGHT_BOLD)
out.format(" font-weight: bold;%n");
if (font.getItalic())
out.format(" font-style: italic;%n");
out.format(" font-family: %s;%n", font.getFontName());
int fontheight = font.getFontHeightInPoints();
if (fontheight == 9) {
fontheight = 10;
}
out.format(" font-size: %dpt;%n", fontheight);
helper.styleColor(out, "color", getColor(font));
}
项目：kdxplore
文件：CellStyleProvider.java
public CellStyle getBoldHeading() {
if (boldHeading == null) {
boldHeading = workbook.createCellStyle();
Font font = workbook.createFont();
font.setBold(true);
boldHeading.setFont(font);
}
return boldHeading;
}
项目：domui
文件：ExcelExportWriter.java
@Override public void startExport(List<? extends IExportColumn<?>> columnList) throws Exception {
if(m_started)
throw new IllegalArgumentException("The writer was already started");
m_started = true;
m_columnList = columnList;
Workbook wb = m_workbook = createWorkbook();
Font defaultFont = wb.createFont();
defaultFont.setFontHeightInPoints((short) 10);
defaultFont.setFontName("Arial");
CellStyle dcs = m_defaultCellStyle = wb.createCellStyle();
dcs.setFont(defaultFont);
// FIXME Date format must be locale dependent?
CellStyle dates = m_dateStyle = wb.createCellStyle();
dates.setDataFormat(wb.createDataFormat().getFormat("d-m-yyyy"));
dates.setFont(defaultFont);
CellStyle curs = m_currencyStyle = wb.createCellStyle();
curs.setDataFormat(wb.createDataFormat().getFormat("#,##0.00"));
curs.setFont(defaultFont);
CellStyle nums = m_numberStyle = wb.createCellStyle();
nums.setDataFormat(wb.createDataFormat().getFormat("#0"));
nums.setFont(defaultFont);
Font headerFont = wb.createFont();
headerFont.setFontHeightInPoints((short) 10);
headerFont.setColor((short) 0xc);
headerFont.setBold(true);
headerFont.setFontName("Arial");
CellStyle hds = m_headerStyle = wb.createCellStyle();
hds.setBorderBottom(BorderStyle.THIN);
hds.setDataFormat(HSSFDataFormat.getBuiltinFormat("text"));
hds.setFont(headerFont);
createNewSheet(columnList);
}
项目：nbone
文件：AbstractPoiExcelTemplate.java
/**
*
* @return
*/
protected CellStyle crateCaptionCellStyle() {
Font font = workbook.createFont();
font.setColor(Font.COLOR_NORMAL);
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setWrapText(false);
font.setFontHeight((short) 250);
cellStyle.setFont(font);
cellStyle.setFillForegroundColor(IndexedColors.BLUE_GREY.index);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
cellStyle.setAlignment(CellStyle.ALIGN_CENTER);
return cellStyle;
}
项目：nbone
文件：AbstractPoiExcelTemplate.java
/**
* 表头单元格样式
*
* @return
*/
protected CellStyle crateTitleCellStyle() {
Font font = workbook.createFont();
font.setColor(Font.COLOR_NORMAL);
CellStyle cellStyle = workbook.createCellStyle();
cellStyle.setWrapText(false);
font.setFontHeight((short) 250);
cellStyle.setFont(font);
cellStyle.setFillForegroundColor(HSSFColor.BLUE_GREY.index);
cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
short border = 1;
setCellBorder(cellStyle, border, border, border, border);
cellStyle.setAlignment(CellStyle.ALIGN_LEFT);
return cellStyle;
}
项目：tecsinapse-data-io
文件：TableCellStyle.java
private void configFont(Font font) {
font.setBold(isBold());
font.setItalic(isItalic());
font.setStrikeout(isStrikeout());
font.setUnderline(isUnderline() ? Font.U_SINGLE : Font.U_NONE);
if (getFontSize() != null) {
font.setFontHeightInPoints(fontSize.shortValue());
}
if (getFontColor() != null) {
if (font instanceof XSSFFont) {
((XSSFFont)font).setColor(new XSSFColor(toRgbByte(fontColor)));
} else {
font.setColor(fontColor.getIndex());
}
}
}
项目：report
文件：ReportServiceImpl.java
/**
*
* @Title: getCellStyle
* @Description: TODO（设置表头样式）
* @param wb
* @return
*/
private CellStyle getHeadCellStyle(Workbook wb) {
CellStyle style = wb.createCellStyle();
Font font = wb.createFont();
font.setFontName("宋体");
font.setFontHeightInPoints((short) 12);// 设置字体大小
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 加粗
style.setFillForegroundColor(HSSFColor.LIME.index);// 设置背景色
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style.setAlignment(HSSFCellStyle.SOLID_FOREGROUND);// 让单元格居中
style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
style.setBorderTop(CellStyle.BORDER_THIN);
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setBorderBottom(CellStyle.BORDER_THIN);
// style.setWrapText(true);//设置自动换行
style.setFont(font);
return style;
}
项目：turnus
文件：PoiUtils.java
/**
* Set a bold font for the given cell with a given font size (in pt).
*
* @param wb
* the workbook that contains the cell
* @param cell
* the cell where the text is contained
* @param size
* the size in pt of the text
*/
public static void setBold(Workbook wb, HSSFCell cell, short size) {
Font font = wb.createFont();
font.setFontHeightInPoints((short) size);
font.setFontName("Arial");
font.setColor(IndexedColors.BLACK.getIndex());
font.setBold(true);
font.setItalic(false);
CellStyle style = wb.createCellStyle();
style.setFont(font);
cell.setCellStyle(style);
}
项目：turnus
文件：PoiUtils.java
/**
* Set a link to a cell. The link type should one of {@link Hyperlink}
*
* @param wb
* the workbook which contains the cell
* @param cell
* the cell where the link is stored
* @param address
* the cell destination address
* @param linkType
* the type selected among {@link Hyperlink}
*/
public static void setLink(Workbook wb, HSSFCell cell, String address, int linkType) {
CreationHelper helper = wb.getCreationHelper();
CellStyle style = wb.createCellStyle();
Font font = wb.createFont();
font.setUnderline(Font.U_SINGLE);
font.setColor(IndexedColors.BLUE.getIndex());
style.setFont(font);
Hyperlink link = helper.createHyperlink(linkType);
link.setAddress(address);
cell.setHyperlink(link);
cell.setCellStyle(style);
}
项目：common-utils
文件：StyleConfiguration.java
/**
* header样式
*
* @return
*/
public CellStyle getHeaderStyle() {
CellStyle headerStyle = workbook.createCellStyle();
// 设置单元格的背景颜色为淡蓝色
headerStyle.setFillForegroundColor(HSSFColor.PALE_BLUE.index);
headerStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
// 设置单元格居中对齐
headerStyle.setAlignment(CellStyle.ALIGN_CENTER);
// 设置单元格垂直居中对齐
headerStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
// 创建单元格内容显示不下时自动换行
headerStyle.setWrapText(true);
// 设置单元格字体样式
Font font = workbook.createFont();
// 设置字体加粗
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
headerStyle.setFont(font);
// 设置单元格边框为细线条
setBorder(headerStyle);
return headerStyle;
}
项目：common-utils
文件：StyleConfiguration.java
/**
* 文本样式
*
* @return
*/
public CellStyle getTextStyle() {
CellStyle textStyle = workbook.createCellStyle();
// 设置单元格居中对齐
textStyle.setAlignment(CellStyle.ALIGN_CENTER);
// 设置单元格垂直居中对齐
textStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
// 创建单元格内容显示不下时自动换行
textStyle.setWrapText(true);
// 设置单元格字体样式
Font font = workbook.createFont();
// 设置字体加粗
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
textStyle.setFont(font);
// 设置单元格边框为细线条
setBorder(textStyle);
return textStyle;
}
项目：common-utils
文件：StyleConfiguration.java
public CellStyle getNumberStyle() {
CellStyle numberStyle = workbook.createCellStyle();
// 设置单元格居中对齐
numberStyle.setAlignment(CellStyle.ALIGN_CENTER);
// 设置单元格垂直居中对齐
numberStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
// 创建单元格内容显示不下时自动换行
numberStyle.setWrapText(true);
// 设置单元格字体样式
Font font = workbook.createFont();
// 设置字体加粗
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
numberStyle.setFont(font);
// 设置单元格边框为细线条
setBorder(numberStyle);
return numberStyle;
}
项目：common-utils
文件：StyleConfiguration.java
public CellStyle getDateStyle() {
CellStyle dateStyle = workbook.createCellStyle();
// 设置单元格居中对齐
dateStyle.setAlignment(CellStyle.ALIGN_CENTER);
// 设置单元格垂直居中对齐
dateStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
DataFormat format = workbook.createDataFormat();
dateStyle.setDataFormat(format.getFormat("yyyy-MM-dd HH:mm"));
// 创建单元格内容显示不下时自动换行
dateStyle.setWrapText(true);
// 设置单元格字体样式
Font font = workbook.createFont();
// 设置字体加粗
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontName("宋体");
font.setFontHeight((short) 200);
dateStyle.setFont(font);
setBorder(dateStyle);
return dateStyle;
}
项目：meja
文件：PoiWorkbook.java
@Override
public PoiFont createFont(com.dua3.utility.text.Font font) {
Font poiFont = poiWorkbook.createFont();
poiFont.setFontName(font.getFamily());
poiFont.setFontHeight(((short) Math.round(20*font.getSizeInPoints())));
poiFont.setColor(getPoiColor(font.getColor()).getIndex());
poiFont.setBold(font.isBold());
poiFont.setItalic(font.isItalic());
poiFont.setUnderline(font.isUnderlined() ? org.apache.poi.ss.usermodel.Font.U_SINGLE
: org.apache.poi.ss.usermodel.Font.U_NONE);
poiFont.setStrikeout(font.isStrikeThrough());
return new PoiFont(this, poiFont);
}
项目：bingexcel
文件：MyTest.java
@Test
public void test2() throws IOException{
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
Row row = sheet.createRow(1);
// Create a cell and put a value in it.
// Style the cell with borders all around.
CellStyle style = wb.createCellStyle();
// style.setFillBackgroundColor(IndexedColors.AUTOMATIC.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
style.setFillForegroundColor(IndexedColors.LIGHT_ORANGE.index);
Font font = wb.createFont();
font.setFontHeightInPoints((short)24);
font.setFontName("Courier New");
font.setItalic(true);
font.setStrikeout(true);
style.setFont(font);
CellUtil.createCell(row, 1, "nihao",style);
//style.setFont(font);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
}
项目：ATTIC-osit
文件：ISheetTemplate.java
/**
* @param color
* @param font
* @return CellStyle
*/
protected XSSFCellStyle getCellStyle(XSSFColor color, Font font) {
XSSFCellStyle style = wb.createCellStyle();
style.setFillForegroundColor(color);
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setWrapText(true); // new line
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderLeft(CellStyle.BORDER_THIN);
style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderRight(CellStyle.BORDER_THIN);
style.setRightBorderColor(IndexedColors.BLACK.getIndex());
style.setBorderTop(CellStyle.BORDER_THIN);
style.setTopBorderColor(IndexedColors.BLACK.getIndex());
if(font != null) style.setFont(font);
return style;
}
项目：olat
文件：DefaultXlsTableExporter.java
private CellStyle getHeaderCellStyle(final Workbook wb) {
CellStyle cellStyle = wb.createCellStyle();
Font boldFont = wb.createFont();
boldFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
cellStyle.setFont(boldFont);
return cellStyle;
}
项目：olat
文件：DefaultXlsTableExporter.java
private CellStyle getHeaderCellStyle(final Workbook wb) {
CellStyle cellStyle = wb.createCellStyle();
Font boldFont = wb.createFont();
boldFont.setBoldweight(Font.BOLDWEIGHT_BOLD);
cellStyle.setFont(boldFont);
return cellStyle;
}
项目：Aspose_for_Apache_POI
文件：ApacheWorkingWithFonts.java
public static void main(String[] args) throws Exception
{
String dataPath = "src/featurescomparison/workingwithformattingfeatures/workingwithfonts/data/";
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("new sheet");
// Create a row and put some cells in it. Rows are 0 based.
Row row = sheet.createRow(1);
// Create a new font and alter it.
Font font = wb.createFont();
font.setFontHeightInPoints((short)24);
font.setFontName("Courier New");
font.setItalic(true);
font.setStrikeout(true);
// Fonts are set into a style so create a new one to use.
CellStyle style = wb.createCellStyle();
style.setFont(font);
// Create a cell and put a value in it.
Cell cell = row.createCell(1);
cell.setCellValue("This is a test of fonts");
cell.setCellStyle(style);
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream(dataPath + "ApacheFonts.xls");
wb.write(fileOut);
fileOut.close();
System.out.println("Apache Fonts Created.");
}
项目：Introspect-Framework
文件：ExcelWriter.java
private CellStyle createTitleBarStyle(Workbook wb) {
CellStyle style = wb.createCellStyle();
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
style.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
Font font = wb.createFont();
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
font.setFontHeight((short) (font.getFontHeight() * 1.5));
style.setFont(font);
return style;
}
项目：Introspect-Framework
文件：ExcelWriter.java
protected CellStyle createColumnHeaderStyle(Workbook wb) {
CellStyle style = wb.createCellStyle();
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
Font font = wb.createFont();
font.setBoldweight(Font.BOLDWEIGHT_BOLD);
style.setFont(font);
style.setBorderTop(CellStyle.BORDER_THIN);
style.setBorderRight(CellStyle.BORDER_THIN);
style.setBorderBottom(CellStyle.BORDER_THIN);
style.setBorderLeft(CellStyle.BORDER_THIN);
return style;
}