本文整理匯總了Java中org.apache.poi.ss.usermodel.Font.setFontHeightInPoints方法的典型用法代碼示例。如果您正苦於以下問題:Java Font.setFontHeightInPoints方法的具體用法?Java Font.setFontHeightInPoints怎麽用?Java Font.setFontHeightInPoints使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類org.apache.poi.ss.usermodel.Font
的用法示例。
在下文中一共展示了Font.setFontHeightInPoints方法的15個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Java代碼示例。
示例1: createIndentationCellStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
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;
}
示例2: defaultHeaderCellStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 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;
}
示例3: defaultTitleCellStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 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;
}
示例4: createStyles
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 創建表格樣式
* @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;
}
示例5: createHeadStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
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;
}
示例6: createHeadDateStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
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;
}
示例7: initFonts
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 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);
}
示例8: initFont
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 初始化字體樣式
*
* @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())));
}
}
示例9: createStyles
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* excel 樣式
*
* @return
*/
public Map<String, CellStyle> createStyles(Workbook workbook) {
Map<String, CellStyle> styles = new HashMap();
CellStyle style = workbook.createCellStyle();
style.setAlignment((short) 2);
style.setVerticalAlignment((short) 1);
Font titleFont = workbook.createFont();
titleFont.setFontName("Arial");
titleFont.setFontHeightInPoints((short) 16);
titleFont.setBoldweight((short) 700);
style.setFont(titleFont);
styles.put("title", style);
style = workbook.createCellStyle();
style.setVerticalAlignment((short) 1);
style.setBorderRight((short) 1);
style.setRightBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderLeft((short) 1);
style.setLeftBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderTop((short) 1);
style.setTopBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setBorderBottom((short) 1);
style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
Font dataFont = workbook.createFont();
dataFont.setFontName("Arial");
dataFont.setFontHeightInPoints((short) 10);
style.setFont(dataFont);
styles.put("data", style);
style = workbook.createCellStyle();
style.cloneStyleFrom((CellStyle) styles.get("data"));
style.setAlignment((short) 1);
styles.put("data1", style);
style = workbook.createCellStyle();
style.cloneStyleFrom((CellStyle) styles.get("data"));
style.setAlignment((short) 2);
styles.put("data2", style);
style = workbook.createCellStyle();
style.cloneStyleFrom((CellStyle) styles.get("data"));
style.setAlignment((short) 3);
styles.put("data3", style);
style = workbook.createCellStyle();
style.cloneStyleFrom((CellStyle) styles.get("data"));
style.setAlignment((short) 2);
style.setFillForegroundColor(IndexedColors.GREY_50_PERCENT.getIndex());
style.setFillPattern((short) 1);
Font headerFont = workbook.createFont();
headerFont.setFontName("Arial");
headerFont.setFontHeightInPoints((short) 10);
headerFont.setBoldweight((short) 700);
headerFont.setColor(IndexedColors.WHITE.getIndex());
style.setFont(headerFont);
styles.put("header", style);
return styles;
}
示例10: copyFont
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 複製字體
*
* @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());
}
示例11: startExport
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
@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);
}
示例12: configFont
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
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());
}
}
}
示例13: getHeadCellStyle
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
*
* @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;
}
示例14: setBold
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
/**
* 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);
}
示例15: test2
import org.apache.poi.ss.usermodel.Font; //導入方法依賴的package包/類
@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();
}