话不多说,请看代码:
ExcelUtil.java
package pers.kangxu.datautils.utils;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
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.CellValue;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.FormulaEvaluator;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
/**
*
*
* excel 工具
*
* @author kangxu
*
*/
public class ExcelUtil {
/**
* 导出 excel
* @param filePath 文件全路径
* @param sheetName sheet页名称
* @param sheetIndex 当前sheet下表 从0开始
* @param fileHeader 头部
* @param datas 内容
*/
public static void writeExcel(String filePath,String sheetName,
int sheetIndex,
String[] fileHeader,
List datas){
// 创建工作簿
Workbook wb = new HSSFWorkbook();
// 创建工作表 sheet
Sheet s = wb.createSheet();
wb.setSheetName(sheetIndex, sheetName);
Row r = s.createRow(0);
Cell c = null;
Font font = null;
CellStyle styleHeader = null;
CellStyle styleContent = null;
//粗体
font = wb.createFont();
font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
// 设置头样式
styleHeader = wb.createCellStyle();
styleHeader.setFont(font);
styleHeade