效果图:
package excel;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.util.List;
import java.util.Objects;
public class OperateExcel {
/**
* 创建WorkBook对象
* @param list 合并后的list集合
* @param labels 标签数组(文件第一行)
* @param title 左右语句类型数组(文件第一行)
* @return HSSFWorkbook对象
*/
public XSSFWorkbook getWorkBook(List list, JSONArray labels, JSONArray title) {
XSSFWorkbook xwk = new XSSFWorkbook();
XSSFSheet xssfSheet = xwk.createSheet("导出结果");
//√符号
int[] code = {0x2611};
//创建表头
Integer initLabel = 3;
createHeader(xssfSheet,labels,title,initLabel);
JSONObject oneRow;
int j = 0;
int size = list.size();
for (j = 0; j < size; j++) {
oneRow = list.get(j);
// 创建内容行:从第二行开始,跳过属性列
createContent(labels, xssfSheet, oneRow, j,initLabel,code);
oneRow = null;
}
return xwk;
}
/**
* 创建表头
* @param xssfSheet 工作薄
*/
private void createHeader(XSSFSheet