以二维数组为例写个小程序,用POI将数据写入到excel中,代码如下:
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.HSSFColor;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
/**
* Created by youlinmin on 2017/4/8.
*/
public class TransToExcel {
/**
* 导出excel文件
* @param title 表sheet的名字
* @param headers 表头
* @param dataList 正文单元格
* @param out 输出流
*/
public void exporteExcel(String title,String[] headers,String[][] dataList,OutputStream out){
HSSFWorkbook workBook = new HSSFWorkbook();
createSheet(title, headers, dataList, workBook);
createSheet(title+"2", headers, dataList, workBook);
try {
workBook.write(out);
}catch (IOException e){
System.out.println("写入文件失败"+e.getMessage());
}
}
/**
* 创建sheet
* @param