Java 类org.apache.poi.ss.usermodel.DataFormat 实例源码
项目：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;
}
项目：excel-rw-annotation
文件：StyleConfiguration.java
/**
* 小数格式
*
* @return CellStyle
*/
public CellStyle getDecimalStyle() {
if (buildInStyleMap.containsKey(DECIMAL_STYLE_KEY)) {
return buildInStyleMap.get(DECIMAL_STYLE_KEY);
}
CellStyle decimalStyle = workbook.createCellStyle();//小数样式
if (!buildInFormatMap.containsKey(DATA_FORMAT_KEY)) {
DataFormat dataFormat = workbook.createDataFormat();
buildInFormatMap.put(DATA_FORMAT_KEY, dataFormat);
}
decimalStyle.setDataFormat(buildInFormatMap.get(DATA_FORMAT_KEY).getFormat("0.00"));
this.setCommonStyle(decimalStyle);
buildInStyleMap.put(DECIMAL_STYLE_KEY, decimalStyle);
return decimalStyle;
}
项目：excel-rw-annotation
文件：StyleConfiguration.java
/**
* 日期样式 yyyy-MM-dd HH:mm
*
* @return CellStyle
*/
public CellStyle getDateStyle() {
if (buildInStyleMap.containsKey(DATE_STYLE_KEY)) {
return buildInStyleMap.get(DATE_STYLE_KEY);
}
CellStyle dateStyle = workbook.createCellStyle();//日期样式
if (!buildInFormatMap.containsKey(DATA_FORMAT_KEY)) {
DataFormat dataFormat = workbook.createDataFormat();
buildInFormatMap.put(DATA_FORMAT_KEY, dataFormat);
}
dateStyle.setDataFormat(buildInFormatMap.get(DATA_FORMAT_KEY).getFormat("yyyy-MM-dd HH:mm"));
this.setCommonStyle(dateStyle);
buildInStyleMap.put(DATE_STYLE_KEY, dateStyle);
return dateStyle;
}
项目：excel-rw-annotation
文件：StyleConfiguration.java
/**
* 日期样式 yyyy/MM/dd
*
* @return CellStyle
*/
public CellStyle getDate8Style() {
if (buildInStyleMap.containsKey(DATE_8_STYLE_KEY)) {
return buildInStyleMap.get(DATE_8_STYLE_KEY);
}
CellStyle date8Style = workbook.createCellStyle();//年月日样式
if (!buildInFormatMap.containsKey(DATA_FORMAT_KEY)) {
DataFormat dataFormat = workbook.createDataFormat();
buildInFormatMap.put(DATA_FORMAT_KEY, dataFormat);
}
date8Style.setDataFormat(buildInFormatMap.get(DATA_FORMAT_KEY).getFormat("yyyy/MM/dd"));
this.setCommonStyle(date8Style);
buildInStyleMap.put(DATE_8_STYLE_KEY, date8Style);
return date8Style;
}
项目：excel-rw-annotation
文件：StyleConfiguration.java
/**
* 根据格式，创建返回样式对象
*
* @param format 格式
* @return 样式对象
*/
public CellStyle getCustomFormatStyle(String format) {
//存在对应格式直接返回
if (customFormatStyleMap.containsKey(format)) {
return customFormatStyleMap.get(format);
}
CellStyle customDateStyle = workbook.createCellStyle();
if (!buildInFormatMap.containsKey(DATA_FORMAT_KEY)) {
DataFormat dataFormat = workbook.createDataFormat();
buildInFormatMap.put(DATA_FORMAT_KEY, dataFormat);
}
customDateStyle.setDataFormat(buildInFormatMap.get(DATA_FORMAT_KEY).getFormat(format));
this.setCommonStyle(customDateStyle);
//放入map缓存
customFormatStyleMap.put(format, customDateStyle);
return customDateStyle;
}
项目：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;
}
项目：swing
文件：Report.java
protected void addRow(HSSFWorkbook workbook, HSSFSheet sheet, Object value, int row, int column) {
HSSFRow hssfRow = sheet.getRow(row);
hssfRow = (hssfRow == null) ? sheet.createRow(row) : hssfRow;
HSSFCell cell = hssfRow.getCell(column);
cell = (cell == null) ? hssfRow.createCell(column) : cell;
String cellValue = (value == null) ? "" : value.toString();
DecimalFormat decimalFormatter = new DecimalFormat("###,###,###,##0.00");
try {
double doubleValue = decimalFormatter.parse(cellValue).doubleValue();
DataFormat dataFormat = workbook.createDataFormat();
HSSFCellStyle cellStyle = workbook.createCellStyle();
cellStyle.setDataFormat(dataFormat.getFormat("###,###,###,##0.00"));
cell.setCellValue(doubleValue);
} catch (ParseException e) {
cell.setCellValue(cellValue);
}
formatCell(workbook, cell);
}
项目：qafe-platform
文件：DocumentExporter.java
protected static void setCellValue(Workbook wb, Cell cell, Object value) {
if (cell == null) {
return;
}
if (value instanceof Boolean) {
cell.setCellValue((Boolean)value);
} else if (value instanceof Number) {
cell.setCellValue(((Number)value).doubleValue());
} else if (value instanceof Date) {
CellStyle cellStyle = wb.createCellStyle();
DataFormat poiFormat = wb.createDataFormat();
// Format: 0x16, "m/d/yy h:mm"
final short format = poiFormat.getFormat(BuiltinFormats.getBuiltinFormat(0x16));
cellStyle.setDataFormat(format);
cell.setCellValue(((Date)value));
cell.setCellStyle(cellStyle);
} else if (value instanceof Calendar) {
cell.setCellValue(((Calendar)value));
} else if (value != null) {
cell.setCellValue(value.toString());
} else {
cell.setCellValue("");
cell.setCellType(Cell.CELL_TYPE_BLANK);
}
}
项目：ExcelHandle
文件：ExportExcel.java
/**
* 添加一个单元格
* @param row 添加的行
* @param column 添加列号
* @param val 添加值
* @param align 对齐方式（1：靠左；2：居中；3：靠右）
* @return 单元格对象
*/
public Cell addCell(Row row, int column, Object val, int align, Class<?> fieldType){
Cell cell = row.createCell(column);
CellStyle style = styles.get("data"+(align>=1&&align<=3?align:""));
try {
if (val == null){
cell.setCellValue("");
} else if (val instanceof String) {
cell.setCellValue((String) val);
} else if (val instanceof Integer) {
cell.setCellValue((Integer) val);
} else if (val instanceof Long) {
cell.setCellValue((Long) val);
} else if (val instanceof Double) {
cell.setCellValue((Double) val);
} else if (val instanceof Float) {
cell.setCellValue((Float) val);
} else if (val instanceof Date) {
DataFormat format = wb.createDataFormat();
style.setDataFormat(format.getFormat("yyyy-MM-dd"));
cell.setCellValue((Date) val);
} else {
if (fieldType != Class.class){
cell.setCellValue((String)fieldType.getMethod("setValue", Object.class).invoke(null, val));
}else{
cell.setCellValue((String)Class.forName(this.getClass().getName().replaceAll(this.getClass().getSimpleName(),
"fieldtype."+val.getClass().getSimpleName()+"Type")).getMethod("setValue", Object.class).invoke(null, val));
}
}
} catch (Exception ex) {
log.info("Set cell value ["+row.getRowNum()+","+column+"] error: " + ex.toString());
cell.setCellValue(val.toString());
}
cell.setCellStyle(style);
return cell;
}
项目：dremio-oss
文件：ExcelTestHelper.java
ExcelTestHelper(final String parent, boolean generateXls) throws Exception {
this.xls = generateXls;
// Create a test Excel sheet with all types of supported data
Workbook wb = generateXls ? new HSSFWorkbook() : new XSSFWorkbook();
CreationHelper creationHelper = wb.getCreationHelper();
DataFormat dataFormat = creationHelper.createDataFormat();
short fmt = dataFormat.getFormat("yyyy-mm-dd hh:mm:ss");
CellStyle style = wb.createCellStyle();
style.setDataFormat(fmt);
Sheet sheetWithHeader = wb.createSheet("Sheet 1");
// Create header row
Row headerRow = sheetWithHeader.createRow((short) 0);
headerRow.createCell(0).setCellValue("Number");
headerRow.createCell(1).setCellValue("String1");
headerRow.createCell(2).setCellValue("String2");
headerRow.createCell(3).setCellValue("MyTime");
headerRow.createCell(4).setCellValue("Formula");
headerRow.createCell(5).setCellValue("Boolean");
headerRow.createCell(6).setCellValue("Error");
generateSheetData(sheetWithHeader, style, (short)1);
Sheet sheetWithoutHeader = wb.createSheet("Sheet 2");
generateSheetData(sheetWithoutHeader, style, (short)0);
testFilePath = new File(parent, "excelTestFile").getPath();
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream(testFilePath);
wb.write(fileOut);
fileOut.close();
}
项目：Shop-for-JavaWeb
文件：ExportExcel.java
/**
* 添加一个单元格
* @param row 添加的行
* @param column 添加列号
* @param val 添加值
* @param align 对齐方式（1：靠左；2：居中；3：靠右）
* @return 单元格对象
*/
public Cell addCell(Row row, int column, Object val, int align, Class<?> fieldType){
Cell cell = row.createCell(column);
CellStyle style = styles.get("data"+(align>=1&&align<=3?align:""));
try {
if (val == null){
cell.setCellValue("");
} else if (val instanceof String) {
cell.setCellValue((String) val);
} else if (val instanceof Integer) {
cell.setCellValue((Integer) val);
} else if (val instanceof Long) {
cell.setCellValue((Long) val);
} else if (val instanceof Double) {
cell.setCellValue((Double) val);
} else if (val instanceof Float) {
cell.setCellValue((Float) val);
} else if (val instanceof Date) {
DataFormat format = wb.createDataFormat();
style.setDataFormat(format.getFormat("yyyy-MM-dd"));
cell.setCellValue((Date) val);
} else {
if (fieldType != Class.class){
cell.setCellValue((String)fieldType.getMethod("setValue", Object.class).invoke(null, val));
}else{
cell.setCellValue((String)Class.forName(this.getClass().getName().replaceAll(this.getClass().getSimpleName(),
"fieldtype."+val.getClass().getSimpleName()+"Type")).getMethod("setValue", Object.class).invoke(null, val));
}
}
} catch (Exception ex) {
log.info("Set cell value ["+row.getRowNum()+","+column+"] error: " + ex.toString());
cell.setCellValue(val.toString());
}
cell.setCellStyle(style);
return cell;
}
项目：bingexcel
文件：AbstractWriteHandler.java
CellStyle createDateStyle() {
if (dateCellStyle != null) {
return dateCellStyle;
}
CellStyle cellStyle = wb.createCellStyle();
DataFormat format = wb.createDataFormat();
cellStyle.setDataFormat(format.getFormat("m/d/yy h:mm"));
dateCellStyle = cellStyle;
return cellStyle;
}
项目：excel-cellformatter
文件：POICell.java
@Override
public String getFormatPattern() {
final DataFormat dataFormat = cell.getSheet().getWorkbook().createDataFormat();
final short formatIndex = getFormatIndex();
String formatPattern = dataFormat.getFormat(formatIndex);
if(formatPattern == null) {
formatPattern = "";
}
return formatPattern;
}
项目：SporttagePlaner
文件：KlassenlistenMaker.java
private void setStyles() {
csNormal = wb.createCellStyle();
csUeberschrift = wb.createCellStyle();
csTitel = wb.createCellStyle();
DataFormat dataFormat = wb.createDataFormat();
// Schriftart Schüler
Font fNormal = wb.createFont();
fNormal.setFontHeightInPoints((short) 10); // Schriftgröße auf 10pt setzen
fNormal.setColor(Font.COLOR_NORMAL); // Schriftfarbe schwarz
fNormal.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle für Schüler
csNormal.setFont(fNormal); // Schriftart
csNormal.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csNormal.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csNormal.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csNormal.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csNormal.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csNormal.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csNormal.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csNormal.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csNormal.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csNormal.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Fett
Font fUeberschrift = wb.createFont();
fUeberschrift.setFontHeightInPoints((short) 11);
fUeberschrift.setColor(Font.COLOR_NORMAL);
fUeberschrift.setBoldweight(Font.BOLDWEIGHT_BOLD);
csUeberschrift.setFont(fUeberschrift);
csUeberschrift.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csUeberschrift.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csUeberschrift.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csUeberschrift.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csUeberschrift.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csUeberschrift.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csUeberschrift.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csUeberschrift.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csUeberschrift.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csUeberschrift.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für Titel
Font fTitel = wb.createFont();
fTitel.setFontHeightInPoints((short) 24); // größe 24pt
fTitel.setColor(Font.COLOR_NORMAL); // schwarz
fTitel.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für den Titel
csTitel.setFont(fTitel); // Schrift setzen
csTitel.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csTitel.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
}
项目：SporttagePlaner
文件：SpielplanWriter.java
private void setStyles() {
csSpieleEtc = wb.createCellStyle(); // Stil für Spiele, Schiris, Zeiten etc.
csTitel = wb.createCellStyle(); // Stil für Titel
csUntertitel = wb.createCellStyle(); // Stil für Untertitel
csTabellenueberschrift = wb.createCellStyle(); // Stil für die Tabellenüberschriften (wie für Spiele, nur fett)
DataFormat dataFormat = wb.createDataFormat(); // Um das Datenformat auf Text zu setzen
// Schriftart für Titel
Font fTitel = wb.createFont();
fTitel.setFontHeightInPoints((short) 24); // größe 24pt
fTitel.setColor(Font.COLOR_NORMAL); // schwarz
fTitel.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für den Titel
csTitel.setFont(fTitel); // Schrift setzen
csTitel.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csTitel.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für den Untertitel
Font fUntertitel = wb.createFont();
fUntertitel.setFontHeightInPoints((short) 10); // Schriftgröße auf 10pt setzen
fUntertitel.setColor(Font.COLOR_NORMAL); // Schriftfarbe schwarz
fUntertitel.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle für den Untertitel
csUntertitel.setFont(fUntertitel); // Schriftart
csUntertitel.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csUntertitel.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für Tabellenüberschriften
Font fTabellenueberschrift = wb.createFont();
fTabellenueberschrift.setFontHeightInPoints((short) 11); // größe 11pt
fTabellenueberschrift.setColor(Font.COLOR_NORMAL); // schwarz
fTabellenueberschrift.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für die Tabellenüberschriften
csTabellenueberschrift.setFont(fTabellenueberschrift); // Schriftart
csTabellenueberschrift.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csTabellenueberschrift.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csTabellenueberschrift.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csTabellenueberschrift.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csTabellenueberschrift.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csTabellenueberschrift.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csTabellenueberschrift.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csTabellenueberschrift.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csTabellenueberschrift.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csTabellenueberschrift.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für Spiele, Schiris, Zeiten etc.
Font fSpieleEtc = wb.createFont();
fSpieleEtc.setFontHeightInPoints((short) 10); // Schriftgröße auf 10pt setzen
fSpieleEtc.setColor(Font.COLOR_NORMAL); // Schriftfarbe schwarz
fSpieleEtc.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle für Spiele, Schiris, Zeiten etc.
csSpieleEtc.setFont(fSpieleEtc); // Schriftart
csSpieleEtc.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csSpieleEtc.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csSpieleEtc.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csSpieleEtc.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csSpieleEtc.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csSpieleEtc.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csSpieleEtc.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csSpieleEtc.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csSpieleEtc.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csSpieleEtc.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
}
项目：SporttagePlaner
文件：PfeiflistenMaker.java
private void setStyles() {
csTitel = wb.createCellStyle();
csUntertitel = wb.createCellStyle();
csTabelleFett = wb.createCellStyle();
csTabelleNormal = wb.createCellStyle();
DataFormat dataFormat = wb.createDataFormat(); // Um das Datenformat auf Text zu setzen
// Schriftart für Titel
Font fTitel = wb.createFont();
fTitel.setFontHeightInPoints((short) 24); // größe 24pt
fTitel.setColor(Font.COLOR_NORMAL); // schwarz
fTitel.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für den Titel
csTitel.setFont(fTitel); // Schrift setzen
csTitel.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csTitel.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für den Untertitel
Font fUntertitel = wb.createFont();
fUntertitel.setFontHeightInPoints((short) 10); // Schriftgröße auf 10pt setzen
fUntertitel.setColor(Font.COLOR_NORMAL); // Schriftfarbe schwarz
fUntertitel.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle für den Untertitel
csUntertitel.setFont(fUntertitel); // Schriftart
csUntertitel.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csUntertitel.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für Tabellenüberschriften
Font fTabelleFett = wb.createFont();
fTabelleFett.setFontHeightInPoints((short) 10); // größe 11pt
fTabelleFett.setColor(Font.COLOR_NORMAL); // schwarz
fTabelleFett.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für die Tabellenüberschriften
csTabelleFett.setFont(fTabelleFett); // Schriftart
csTabelleFett.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // Mittige Anordnung
csTabelleFett.setAlignment(CellStyle.ALIGN_CENTER);
csTabelleFett.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csTabelleFett.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csTabelleFett.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csTabelleFett.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csTabelleFett.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csTabelleFett.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csTabelleFett.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csTabelleFett.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csTabelleFett.setDataFormat(dataFormat.getFormat("text")); // Datenformat Text
// Schriftart für Spiele, Schiris, Zeiten etc.
Font fTabelleNormal = wb.createFont();
fTabelleNormal.setFontHeightInPoints((short) 10); // Schriftgröße auf 10pt setzen
fTabelleNormal.setColor(Font.COLOR_NORMAL); // Schriftfarbe schwarz
fTabelleNormal.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle für Spiele, Schiris, Zeiten etc.
csTabelleNormal.cloneStyleFrom(csTabelleFett);
csTabelleNormal.setFont(fTabelleNormal); // Schriftart
}
项目：SporttagePlaner
文件：KontrollistenWriter.java
private void setStyles() {
csNormal1 = wb.createCellStyle(); // Stil für Uhrzeiten, Namen etc. (gerade Spiele)
csNormal2 = wb.createCellStyle(); // ungerade Spiele
csInfos = wb.createCellStyle(); // Stil für Infos über der eigentlichen Liste
csUeberschriften = wb.createCellStyle(); // Stil für Überschriften
DataFormat dataFormat = wb.createDataFormat(); // Textformat in den Zellen
// Schriftart für Überschriften
Font fUeberschriften = wb.createFont();
fUeberschriften.setFontHeightInPoints((short) 11); // 12pt
fUeberschriften.setColor(Font.COLOR_NORMAL); // schwarz
fUeberschriften.setBoldweight(Font.BOLDWEIGHT_BOLD); // fett
// CellStyle für Überschriften
csUeberschriften.setFont(fUeberschriften);
csUeberschriften.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // zentrieren
csUeberschriften.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
csUeberschriften.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csUeberschriften.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csUeberschriften.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csUeberschriften.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csUeberschriften.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csUeberschriften.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csUeberschriften.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csUeberschriften.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csUeberschriften.setDataFormat(dataFormat.getFormat("text")); // als Text formatiert
// Schriftart für Infos am Anfang
Font fInfos = wb.createFont();
fInfos.setFontHeightInPoints((short) 11); // 11pt
fInfos.setColor(Font.COLOR_NORMAL); // schwarz
fInfos.setBoldweight(Font.BOLDWEIGHT_BOLD);
// CellStyle für Infos
csInfos.setFont(fInfos);
csInfos.setAlignment(CellStyle.ALIGN_CENTER_SELECTION); // zentriert
csInfos.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
csInfos.setDataFormat(dataFormat.getFormat("text")); // text
// Schriftart für normales
Font fNormal = wb.createFont();
fNormal.setFontHeightInPoints((short) 10); // 11pt
fNormal.setColor(Font.COLOR_NORMAL);
fNormal.setBoldweight(Font.BOLDWEIGHT_NORMAL);
// CellStyle normal
csNormal1.setFont(fNormal);
csNormal1.setAlignment(CellStyle.ALIGN_LEFT); // linksbündig
csNormal1.setVerticalAlignment(CellStyle.VERTICAL_CENTER);
csNormal1.setBorderBottom(CellStyle.BORDER_THIN); // Umrandung unten einschalten
csNormal1.setBottomBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung unten in schwarz
csNormal1.setBorderLeft(CellStyle.BORDER_THIN); // Umrandung links einschalten
csNormal1.setLeftBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung links in schwarz
csNormal1.setBorderTop(CellStyle.BORDER_THIN); // Umrandung oben einschalten
csNormal1.setTopBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung oben in schwarz
csNormal1.setBorderRight(CellStyle.BORDER_THIN); // Umrandung rechts einschalten
csNormal1.setRightBorderColor(IndexedColors.BLACK.getIndex()); // Umrandung rechts in schwarz
csNormal1.setDataFormat(dataFormat.getFormat("text"));
csNormal2.cloneStyleFrom(csNormal1); // Gleich wie Normal für Gerade, nur der Hintergrund ist anders
csNormal2.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex()); // leicht grau
csNormal2.setFillPattern(CellStyle.SOLID_FOREGROUND);
}
项目：covito-kit
文件：ExportExcel.java
/**
* 添加一个单元格
*
* @param row
* 添加的行
* @param column
* 添加列号
* @param val
* 添加值
* @param align
* 对齐方式
* @return 单元格对象
*/
public Cell addCell(Row row, int column, Object val, ExAlign align) {
Cell cell = row.createCell(column);
CellStyle style = styles.get("data" + align.getValue());
try {
if (val == null) {
cell.setCellValue("");
} else if (val instanceof String) {
cell.setCellValue((String) val);
} else if (val instanceof Integer) {
cell.setCellValue((Integer) val);
} else if (val instanceof Long) {
cell.setCellValue((Long) val);
} else if (val instanceof Double) {
cell.setCellValue((Double) val);
} else if (val instanceof Float) {
cell.setCellValue((Float) val);
} else if (val instanceof Date) {
DataFormat format = wb.createDataFormat();
style.setDataFormat(format.getFormat("yyyy-MM-dd"));
cell.setCellValue((Date) val);
} else {
throw new RuntimeException("value is unkown class type");
}
} catch (Exception ex) {
log.info("Set cell value [" + row.getRowNum() + "," + column + "] error: "
+ ex.toString());
cell.setCellValue(val.toString());
}
cell.setCellStyle(style);
return cell;
}
项目：birt
文件：StyleManagerUtils.java
/**
* Apply a BIRT number/date/time format to a POI CellStyle.
* @param workbook
* The workbook containing the CellStyle (needed to create a new DataFormat).
* @param birtStyle
* The BIRT style which may contain a number format.
* @param poiStyle
* The CellStyle that is to receive the number format.
*/
public void applyNumberFormat(Workbook workbook, BirtStyle birtStyle, CellStyle poiStyle, Locale locale) {
String dataFormat = null;
String format = getNumberFormat(birtStyle);
if( format != null ) {
log.debug( "BIRT number format == ", format);
dataFormat = poiNumberFormatFromBirt(format);
} else {
format = getDateTimeFormat(birtStyle);
if( format != null ) {
log.debug( "BIRT date/time format == ", format );
dataFormat = poiDateTimeFormatFromBirt( format, locale );
} else {
format = getTimeFormat(birtStyle);
if( format != null ) {
log.debug( "BIRT time format == ", format );
dataFormat = poiDateTimeFormatFromBirt( format, locale );
} else {
format = getDateFormat(birtStyle);
if( format != null ) {
log.debug( "BIRT date format == ", format );
dataFormat = poiDateTimeFormatFromBirt( format, locale );
}
}
}
}
if( dataFormat != null ) {
DataFormat poiFormat = workbook.createDataFormat();
log.debug( "Setting POI data format to ", dataFormat);
poiStyle.setDataFormat(poiFormat.getFormat(dataFormat));
}
}
项目：CVRP
文件：PlotIt.java
public void initialize() throws IOException{
File directory = new File( "." );
fileExists = false;
for( File f : directory.listFiles() )
{
if( f.getName().equals( workBookName ) )
{
fileExists = true;
break;
}
}
File workBookFile = new File(workBookName);
if(!fileExists){
workBookFile.createNewFile();
wb = new HSSFWorkbook();
}else{
//in = ;
wb = new HSSFWorkbook(new FileInputStream(workBookFile));
}
// create a new workbook
out = new FileOutputStream(workBookName);
DataFormat df = wb.createDataFormat();
for(int i = 0 ; i < datatypes.length ; i++){
cellTypes[i] = wb.createCellStyle();
cellTypes[i].setDataFormat(df.getFormat(datatypes[i]));
}
}
项目：pentaho-kettle
文件：ExcelWriterStep.java
/**
* Set specified cell format
*
* @param excelFieldFormat the specified format
* @param cell the cell to set up format
*/
private void setDataFormat( String excelFieldFormat, Cell cell ) {
if ( log.isDebug() ) {
logDebug( BaseMessages.getString( PKG, "ExcelWriterStep.Log.SetDataFormat", excelFieldFormat, CellReference
.convertNumToColString( cell.getColumnIndex() ), cell.getRowIndex() ) );
}
DataFormat format = data.wb.createDataFormat();
short formatIndex = format.getFormat( excelFieldFormat );
CellStyle style = data.wb.createCellStyle();
style.cloneStyleFrom( cell.getCellStyle() );
style.setDataFormat( formatIndex );
cell.setCellStyle( style );
}
项目：bdf2
文件：ExcelReportBuilder.java
private int buildGridExcelData(ReportGrid gridModel, Sheet sheet, int starDataRow, Map<String, CellStyle> styles) {
CellStyle dataAlignLeftStyle = styles.get(GridStyleType.dataAlignLeftStyle.name());
CellStyle dataAlignCenterStyle = styles.get(GridStyleType.dataAlignCenterStyle.name());
CellStyle dataAlignRightStyle = styles.get(GridStyleType.dataAlignRightStyle.name());
IFillCellInterceptor interceptor = ContextHolder.getBean(IFillCellInterceptor.BEAN_ID);
List<ReportGridHeader> bottomGridExcelHeader = new ArrayList<ReportGridHeader>();
this.calculateBottomColumnHeader(gridModel.getGridHeaderModelList(), bottomGridExcelHeader);
List<Map<String, Object>> excelDatas = gridModel.getGridDataModel().getDatas();
String treeColumn = gridModel.getGridDataModel().getTreeColumn();
int excelDataIndex = 0;
int rowSize = excelDatas.size();
Cell cell;
Row row;
for (int rowNum = starDataRow; rowNum <= starDataRow + rowSize - 1; rowNum++) {
row = sheet.createRow(rowNum);
Map<String, Object> map = excelDatas.get(excelDataIndex);
int j = 0;
for (ReportGridHeader header : bottomGridExcelHeader) {
Object value = map.get(header.getColumnName());
int dataAlign = header.getDataAlign();
cell = row.createCell(j);
if (dataAlign == 1) {
cell.setCellStyle(dataAlignCenterStyle);
} else if (dataAlign == 2) {
cell.setCellStyle(dataAlignRightStyle);
} else {
cell.setCellStyle(dataAlignLeftStyle);
}
if (value != null) {
if (header.getColumnName().equalsIgnoreCase(treeColumn)) {
int level = this.calculateIndentationCount(value.toString());
cell.setCellStyle(new GridStyleBuilder().createIndentationCellStyle(sheet.getWorkbook(), level == 0 ? 0 : level * 2));
cell.setCellValue(value.toString());
} else {
if (value instanceof BigDecimal || value instanceof Float || value instanceof Double){
CellStyle style = cell.getCellStyle();
DataFormat format = sheet.getWorkbook().createDataFormat();
String displayFormat = header.getDisplayFormat();
if (StringUtils.isEmpty(displayFormat))
style.setDataFormat(format.getFormat("#,##0.00"));
else
style.setDataFormat(format.getFormat(displayFormat));
cell.setCellStyle(style);
}
interceptor.fillCellValue(sheet, row, cell, value);
}
} else {
cell.setCellValue("");
}
sheet.setColumnWidth(cell.getColumnIndex(), header.getWidth() / 6 > 255 ? 254 * 256 : header.getWidth() / 6 * 256);
j++;
}
excelDataIndex++;
}
return starDataRow + rowSize;
}
项目：excel-cellformatter
文件：BuiltInFormatGenerateTool.java
private void execute(final Sheet sheet) {
DataFormat format = sheet.getWorkbook().createDataFormat();
for(int i=0; i <= 59; i++) {
final Row row = sheet.getRow(3 + i);
Cell descriptionCell = row.getCell(1);
Cell testCaseCell = row.getCell(2);
Cell testResultCell = row.getCell(3);
Cell indexCell = row.getCell(4);
Cell formatCell = row.getCell(5);
descriptionCell.setCellValue(String.format("[10進数]=%d, [16進数]=%s", i, Integer.toHexString(i)));
// テストケースのスタイルの設定
CellStyle style = sheet.getWorkbook().createCellStyle();
style.setDataFormat((short)i);
style.setBorderBottom(CellStyle.BORDER_THIN);
testCaseCell.setCellStyle(style);
if(i == 0) {
testCaseCell.setCellValue("テキスト");
} else if(range(i, 1, 8)) {
// 数値
testCaseCell.setCellValue(-123.456);
} else if(range(i, 9, 11)) {
// パーセント、小数
testCaseCell.setCellValue(0.0123);
} else if(range(i, 12, 13)) {
// 分数
testCaseCell.setCellValue(12.345);
} else if(range(i, 14, 36)) {
// 日時
testCaseCell.setCellValue(Timestamp.valueOf("2000-02-29 10:19:23.123"));
} else if(range(i, 37, 44)) {
// 会計
testCaseCell.setCellValue(-123.456);
} else if(range(i, 45, 48)) {
// 時間、経過時間
testCaseCell.setCellValue(Timestamp.valueOf("1900-01-01 00:01:01.000"));
} else if(range(i, 9, 11)) {
// 指数
testCaseCell.setCellValue(123.456789);
} else if(i == 49) {
// テキスト
testCaseCell.setCellValue("テキスト");
} else if(range(i, 50, 59)) {
testCaseCell.setCellValue(Timestamp.valueOf("2000-02-29 10:19:23.123"));
}
// インデックス
indexCell.setCellValue(i);
// フォーマット
formatCell.setCellValue(BuiltinFormats.getBuiltinFormat(i));
}
}
项目：t-rex
文件：PoiSheetParser.java
private void changeValueIfNeeded(Cell cell) {
//validate
String originalValue = cell.getStringCellValue();
if (originalValue == null || originalValue.isEmpty()) return;
//interprets
Object result = interpreter.parseTemplate(originalValue, context, variables, formatter);
//converts
if (result != null) {
if (formatter.format() != null) {
//create data format
DataFormat df = workbook.createDataFormat();
short sdf = df.getFormat(formatter.format());
//set format
CellStyle style = cell.getCellStyle();
if (style == null) {
style = workbook.createCellStyle();
}
style.setDataFormat(sdf);
}
if (result instanceof Date) {
cell.setCellType(Cell.CELL_TYPE_NUMERIC);
cell.setCellValue((Date) result);
} else if (result instanceof Calendar) {
cell.setCellType(Cell.CELL_TYPE_NUMERIC);
cell.setCellValue((Calendar) result);
} else if (result instanceof Number) {
cell.setCellType(Cell.CELL_TYPE_NUMERIC);
Number numValue = (Number) result;
cell.setCellValue(numValue.doubleValue());
} else if (result instanceof Boolean) {
cell.setCellType(Cell.CELL_TYPE_BOOLEAN);
Boolean boolValue = (Boolean) result;
cell.setCellValue(boolValue);
} else {
String strValue = result.toString();
if (!originalValue.equals(strValue)) {
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellValue(strValue);
}
}
} else {
cell.setCellValue((String) null);
}
}
项目：xcelite
文件：CellStyles.java
private void createDateFormatStyle() {
dateStyle = wb.createCellStyle();
DataFormat df = wb.createDataFormat();
dateStyle.setDataFormat(df.getFormat(DEFAULT_DATE_FORMAT));
}
项目：xcelite
文件：CellStyles.java
public CellStyle getCustomDataFormatStyle(String dataFormat) {
CellStyle cellStyle = wb.createCellStyle();
DataFormat df = wb.createDataFormat();
cellStyle.setDataFormat(df.getFormat(dataFormat));
return cellStyle;
}
项目：excel-streaming-reader
文件：StreamingWorkbook.java
/**
* Not supported
*/
@Override
public DataFormat createDataFormat() {
throw new UnsupportedOperationException();
}
项目：olca-modules
文件：Excel.java
public static short dateFormat(Workbook workbook) {
DataFormat format = workbook.createDataFormat();
return format.getFormat("mm/dd/yyyy hh:mm");
}
项目：excel2canvas
文件：ExcelUtils.java
public static CellStyle createDateStyle(Workbook workbook, String format) {
CellStyle style = workbook.createCellStyle();
DataFormat df = workbook.createDataFormat();
style.setDataFormat(df.getFormat(format));
return style;
}
项目：pentaho-kettle
文件：ExcelWriterStep_StyleFormatTest.java
/**
* Test applying Format and Style from cell (from a template) when writing fields
*
* @param fileType
* @throws Exception
*/
private void testStyleFormat( String fileType ) throws Exception {
setupStepMock( fileType );
createStepMeta( fileType );
createStepData( fileType );
step.init( stepMeta, stepData );
// We do not run transformation or executing the whole step
// instead we just execute ExcelWriterStepData.writeNextLine() to write to Excel workbook object
// Values are written in A2:D2 and A3:D3 rows
List<Object[]> rows = createRowData();
for ( int i = 0; i < rows.size(); i++ ) {
step.writeNextLine( rows.get( i ) );
}
// Custom styles are loaded from G1 cell
Row xlsRow = stepData.sheet.getRow( 0 );
Cell baseCell = xlsRow.getCell( 6 );
CellStyle baseCellStyle = baseCell.getCellStyle();
DataFormat format = stepData.wb.createDataFormat();
// Check style of the exported values in A3:D3
xlsRow = stepData.sheet.getRow( 2 );
for ( int i = 0; i < stepData.inputRowMeta.size(); i++ ) {
Cell cell = xlsRow.getCell( i );
CellStyle cellStyle = cell.getCellStyle();
if ( i > 0 ) {
assertEquals( cellStyle.getBorderRight(), baseCellStyle.getBorderRight() );
assertEquals( cellStyle.getFillPattern(), baseCellStyle.getFillPattern() );
} else {
// cell A2/A3 has no custom style
assertFalse( cellStyle.getBorderRight() == baseCellStyle.getBorderRight() );
assertFalse( cellStyle.getFillPattern() == baseCellStyle.getFillPattern() );
}
if ( i != 1 ) {
assertEquals( format.getFormat( cellStyle.getDataFormat() ), "0.00000" );
} else {
// cell B2/B3 use different format from the custom style
assertEquals( format.getFormat( cellStyle.getDataFormat() ), "##0,000.0" );
}
}
}
项目：pentaho-kettle
文件：ExcelWriterStep_StyleFormatTest.java
/**
* Setup the data necessary for Excel Writer step
*
* @param fileType
* @throws KettleException
*/
private void createStepData( String fileType ) throws KettleException {
stepData = new ExcelWriterStepData();
stepData.inputRowMeta = step.getInputRowMeta().clone();
stepData.outputRowMeta = step.getInputRowMeta().clone();
// we don't run transformation so ExcelWriterStep.processRow() doesn't get executed
// we populate the ExcelWriterStepData with bare minimum required values
CellReference cellRef = new CellReference( stepMeta.getStartingCell() );
stepData.startingRow = cellRef.getRow();
stepData.startingCol = cellRef.getCol();
stepData.posX = stepData.startingCol;
stepData.posY = stepData.startingRow;
int numOfFields = stepData.inputRowMeta.size();
stepData.fieldnrs = new int[numOfFields];
stepData.linkfieldnrs = new int[numOfFields];
stepData.commentfieldnrs = new int[numOfFields];
for ( int i = 0; i < numOfFields; i++ ) {
stepData.fieldnrs[i] = i;
stepData.linkfieldnrs[i] = -1;
stepData.commentfieldnrs[i] = -1;
}
// we avoid reading/writing Excel files, so ExcelWriterStep.prepareNextOutputFile() doesn't get executed
// create Excel workbook object
stepData.wb = stepMeta.getExtension().equalsIgnoreCase( "xlsx" ) ? new XSSFWorkbook() : new HSSFWorkbook();
stepData.sheet = stepData.wb.createSheet();
stepData.file = null;
stepData.clearStyleCache( numOfFields );
// we avoid reading template file from disk
// so set beforehand cells with custom style and formatting
DataFormat format = stepData.wb.createDataFormat();
Row xlsRow = stepData.sheet.createRow( 0 );
// Cell F1 has custom style applied, used as template
Cell cell = xlsRow.createCell( 5 );
CellStyle cellStyle = stepData.wb.createCellStyle();
cellStyle.setBorderRight( CellStyle.BORDER_THICK );
cellStyle.setFillPattern( CellStyle.FINE_DOTS );
cell.setCellStyle( cellStyle );
// Cell G1 has same style, but also a custom data format
cellStyle = stepData.wb.createCellStyle();
cellStyle.cloneStyleFrom( cell.getCellStyle() );
cell = xlsRow.createCell( 6 );
cellStyle.setDataFormat( format.getFormat( "##0,000.0" ) );
cell.setCellStyle( cellStyle );
}