Java excel 写操作-优快云博客

本文介绍了一个使用Java进行Excel文件导出的例子。通过Apache POI库创建包含数据的Excel表格，并设置了单元格样式和填充颜色。此外，还实现了文件的自动命名与保存。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package common.excelOprate;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Locale;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.hssf.util.Region;

public class WriteExcel {

public WriteExcel() {
super();
// TODO 自动生成构造函数存根
}

/**
* @param args
* @throws IOException
*/
public String createExcel(){

  HSSFWorkbook workBook = new HSSFWorkbook();
  HSSFSheet sheet = workBook.createSheet();
//  为表格的列创建显示类型
  HSSFCellStyle columnHeaderStyle = workBook.createCellStyle();
  columnHeaderStyle.setFillBackgroundColor(HSSFColor.BLUE_GREY.index);
  columnHeaderStyle.setFillForegroundColor(HSSFColor.BLUE_GREY.index);


//  创建字体
  HSSFFont font = workBook.createFont();
  font.setColor(HSSFFont.COLOR_RED);

  columnHeaderStyle.setFont(font);

//  设定表格每一列的显示风格
  //headerCell1.setCellStyle(columnHeaderStyle);
  //headerCell2.setCellStyle(columnHeaderStyle);

//创建表格行的数据内容

  HSSFRow row = sheet.createRow((short) 0);
  HSSFCell c11=row.createCell((short) 0);
  c11.setCellValue("订单编号");
  c11=row.createCell((short) 1);
  c11.setCellValue("集团名称");
  c11=row.createCell((short) 2);
  c11.setCellValue("内容");
  c11=row.createCell((short) 3);
  c11.setCellValue("提交日期");
  c11=row.createCell((short) 4);
  c11.setCellValue("完成日期");
  c11=row.createCell((short) 5);
  c11.setCellValue("区域");
  for(int i=1;i<10;i++){
   row = sheet.createRow((short) i);
   c11=row.createCell((short) 0);
   c11.setCellValue(i+"0");
   c11=row.createCell((short) 1);
   c11.setCellValue(i+"0");

   c11=row.createCell((short) 2);
   c11.setCellValue(i+"0");

   c11=row.createCell((short) 3);
   c11.setCellValue(i+"0");

   c11=row.createCell((short) 4);
   c11.setCellValue(i+"0");

   c11=row.createCell((short) 5);
   c11.setCellValue(i+"0");



  }
    //写文件，完成保存任务
  Date currTime = new Date();
     SimpleDateFormat formatter2 = new SimpleDateFormat("yyyyMMddhhmmss", Locale.US);

  String fileName =formatter2.format(currTime)+ ".xls";

  FileOutputStream stream = null;
  try {
   stream = new FileOutputStream("excel/"+fileName);
  } catch (FileNotFoundException e) {
   e.printStackTrace();
  }
  try {
   workBook.write(stream);
  } catch (IOException e) {
   e.printStackTrace();
  }
  return fileName;

}

public static void main(String[] args) throws SQLException, Exception {
WriteExcel createXL=new WriteExcel();
createXL.createExcel();
}

}