java cellvalue_Java SXSSFCell.setCellValue方法代码示例

import org.apache.poi.xssf.streaming.SXSSFCell; //导入方法依赖的package包/类

@Override

public void write(Object newDAO) throws OfficeWriterException {

SpreadSheetCellDAO sscd = MSExcelWriter.checkSpreadSheetCellDAO(newDAO);

String safeSheetName=WorkbookUtil.createSafeSheetName(sscd.getSheetName());

SXSSFSheet currentSheet=this.currentWorkbook.getSheet(safeSheetName);

if (currentSheet==null) {// create sheet if it does not exist yet

currentSheet=this.currentWorkbook.createSheet(safeSheetName);

if (!(safeSheetName.equals(sscd.getSheetName()))) {

LOG.warn("Sheetname modified from \""+sscd.getSheetName()+"\" to \""+safeSheetName+"\" to correspond to Excel conventions.");

}

// create drawing anchor (needed for comments...)

this.mappedDrawings.put(safeSheetName,