代码

maven 依赖

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.0.1</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.0.1</version>
</dependency>

jar 包

• poi-3.8-20120326.jar
• commons-math3

java代码

package test;

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.junit.Test;

import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class POI {

    //创建Excel对象

    public static void main(String[] args) throws Exception{
        //创建工作薄对象
        HSSFWorkbook workbook = new HSSFWorkbook();//这里也可以设置sheet的Name
        //创建工作表对象
        HSSFSheet sheet = workbook.createSheet();
        //创建工作表的行
        HSSFRow row = sheet.createRow(0);//设置第一行，从零开始
        SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String datetime=sdf.format(new Date());
        row.createCell(0).setCellValue(datetime);//第一行第一列为日期
        row.createCell(2).setCellValue("测试");//第一行第三列为aaaaaaaaaaaa
        workbook.setSheetName(0, "sheet的Name");//设置sheet的Name

        //文档输出
        FileOutputStream out = new FileOutputStream("1.xls");
        workbook.write(out);
        out.close();
    }
}