关注我们

POI Excel - 日期单元格

要创建显示该单元格当前日期的日期单元格，无涯教程可以使用Apache POI的样式函数根据日期对单元格进行格式化。 setDateformat()方法用于设置日期格式。看一个示例，在该示例中，将创建一个包含当前日期的单元格。

POI Excel日期单元格示例

package poiexample;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class DateCellExample {
	
	public static void main(String[] args) throws FileNotFoundException, IOException {
		Workbook wb = new HSSFWorkbook();
		CreationHelper createHelper = wb.getCreationHelper();
	    try(OutputStream os = new FileOutputStream("Learnfk.xls")){
	        Sheet sheet = wb.createSheet("New Sheet");
	        Row row     = sheet.createRow(0);
	        Cell cell   = row.createCell(0);
	        CellStyle cellStyle = wb.createCellStyle();
	        cellStyle.setDataFormat(
	            createHelper.createDataFormat().getFormat("d/m/yy h:mm"));
	        cell = row.createCell(1);
	        cell.setCellValue(new Date());
	        cell.setCellStyle(cellStyle);
	        wb.write(os);
	    }catch(Exception e) {
	    	System.out.println(e.getMessage());
	    }
	}
}