package com.fline.aic.excel;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
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.xssf.usermodel.XSSFWorkbook;
import com.fline.aic.dao.QueryDataOfCharts;
import com.fline.aic.vo.CountEntity;/**
*
* @Description TODO
* @author biehl
* @Date 2018年9月21日 上午11:37:28
**/
public classWriteExcelForXSSF {private staticWriteExcelForXSSF writeExcelForXSSF;privateWriteExcelForXSSF() {
}public staticWriteExcelForXSSF getInstance() {if (writeExcelForXSSF == null) {
writeExcelForXSSF= newWriteExcelForXSSF();
}returnwriteExcelForXSSF;
}/**
**/
public Map>readDbAreaOfDabase() {//Map集合
Map> map = new HashMap>();//List集合
List list = new ArrayList();//获取到QueryDataOfCharts对象
QueryDataOfCharts instance =QueryDataOfCharts.getInstance();//查询到xxx的数据
CountEntity queryDbxxx =instance.queryDbxxx();
list.add(queryDbxxx.getSx());
list.add(queryDbxxx.getBj());
list.add(queryDbxxx.getZz());
list.add(queryDbxxx.getYh());
map.put(0,list);returnmap;
}public voidwriteDbAreaForXSSF() {//创建一个空的工作簿
Workbook workbook = newXSSFWorkbook();//创建一个sheet页
Sheet sheet = workbook.createSheet("xxxxxx报表");//合并单元格
/** sheet.addMergedRegion(new CellRangeAddress( 2,//第一行(从0开始) 2,//最后一行(从0开始)
* 0,//第一列(从0开始) 26 //最后一列(从0开始) ));*/
//