setcellvalue 格式_Java Cell.setCellValue方法代码示例

本文整理汇总了Java中org.apache.poi.ss.usermodel.Cell.setCellValue方法的典型用法代码示例。如果您正苦于以下问题：Java Cell.setCellValue方法的具体用法？Java Cell.setCellValue怎么用？Java Cell.setCellValue使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.apache.poi.ss.usermodel.Cell的用法示例。

在下文中一共展示了Cell.setCellValue方法的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: setupTotalCell

​点赞 5

​

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

protected void setupTotalCell(Cell cell, final String propId, final int currentRow, final int startRow, int col) {

cell.setCellStyle(getCellStyle(propId, currentRow, startRow, col, true));

final HorizontalAlignment poiAlignment = getGridHolder().getCellAlignment(propId);

CellUtil.setAlignment(cell, poiAlignment);

Class> propType = getGridHolder().getPropertyType(propId);

if (isNumeric(propType)) {

CellRangeAddress cra = new CellRangeAddress(startRow, currentRow - 1, col, col);

if (isHierarchical()) {

// 9 & 109 are for sum. 9 means include hidden cells, 109 means exclude.

// this will show the wrong value if the user expands an outlined category, so

// we will range value it first

cell.setCellFormula("SUM(" + cra.formatAsString(hierarchicalTotalsSheet.getSheetName(),

true) + ")");

} else {

cell.setCellFormula("SUM(" + cra.formatAsString() + ")");

}

} else {

if (0 == col) {

cell.setCellValue(createHelper.createRichTextString("Total"));

}

}

}

开发者ID:TFyre，项目名称:vaadin-gridexport，代码行数:23，

示例2: setCellValue

​点赞 3

​

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

private static void setCellValue(Cell cell, Object obj){

if(obj == null){

}else if(obj instanceof String){

cell.setCellValue((String) obj);

}else if(obj instanceof Date){

Date date = (Date) obj;

if(date != null){

cell.setCellValue(DateUtils.dfDateTime.format(date));

}

}else if(obj instanceof Calendar){

Calendar calendar = (Calendar) obj;

if(calendar != null){

cell.setCellValue(DateUtils.dfDateTime.format(calendar.getTime()));

}

}else if(obj instanceof Timestamp){

Timestamp timestamp = (Timestamp) obj;

if(timestamp != null){

cell.setCellValue(DateUtils.dfDateTime.format(new Date(timestamp.getTime())));

}

}else if(obj instanceof Double){

cell.setCellValue((Double) obj);

}else{

cell.setCellValue(obj.toString());

}

}

开发者ID:xujeff，项目名称:tianti，代码行数:26，

示例3: createFirstRow

​点赞 3

​

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

private static List createFirstRow(String sheetName,

List locales, Sheet sheet, CellStyle styleTitle) {

int colIdx = 0;

Row titleRow = sheet.createRow(0);

sheet.setColumnWidth(colIdx, 30 * 256);

Cell titleCell = titleRow.createCell(colIdx++);

titleCell.setCellStyle(styleTitle);

titleCell.setCellValue(getDefaultResourceBundle().getString(

BaseBean.LABEL_SHOP_TRANSLARIONS_KEY));

return createColumnHeaders(sheetName, locales, sheet, styleTitle,

colIdx, titleRow);

}

开发者ID:servicecatalog，项目名称:oscm，代码行数:13，

示例4: setCellValue

​点赞 3

​

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

protected void setCellValue(Cell sheetCell, Object value, Class> valueType, Object propId) {

if (null != value) {

if (!isNumeric(valueType)) {

if (java.util.Date.class.isAssignableFrom(valueType)) {

sheetCell.setCellValue((Date) value);

} else {

sheetCell.setCellValue(createHelper.createRichTextString(value.toString()));

}

} else {

try {

// parse all numbers as double, the format will determine how they appear

final Double d = Double.parseDouble(value.toString());

sheetCell.setCellValue(d);

} catch (final NumberFormatException nfe) {

LOGGER.warning("NumberFormatException parsing a numeric value: " + nfe);

sheetCell.setCellValue(createHelper.createRichTextString(value.toString()));

}

}

}

}

开发者ID:TFyre，项目名称:vaadin-gridexport，代码行数:21，

示例5: feedDetailsSheet

​点赞 3

​

import org.apache.poi.ss.usermodel.Cell; //导入方法依赖的package包/类

public void feedDetailsSheet(Sheet sheet, boolean exportAsTemplate, List xLTestSteps) {

int index = 0;

for (XLTestStep xLTestStep : xLTestSteps) {

index++;

Row row = sheet.createRow(index);

Cell cell = row.createCell(STEPNAME_INDEX);

cell.setCellValue(xLTestStep.getName());

cell = row.createCell(EXPECTED_OR_ACTION_INDEX);

cell.setCellValue(xLTestStep.getExpected());

cell = row.createCell(RESULT_INDEX);

if (exportAsTemplate)

cell.setCellValue("");

else

cell.setCellValue(xLTestStep.getActual());

cell = row.createCell(STATUS_INDEX);

formatCellStatus(sheet, cell);

if (exportAsTemplate)

cell.setCellValue("");

else

cell.setCellValue(Integer