package?com.kcm.tools.excel;
/**
?*?創(chuàng)建人：聶偉
?*?創(chuàng)建時(shí)間：2015-9-9
?*?類名：PoiExcelTool
?*?描述：根據(jù)EXCEL模板創(chuàng)建EXCEL文件的工具類，需要提供excel模板，以及配套的xml格式文件，xml格式為（也可自己定義，但需要調(diào)整xml解析時(shí)的變量名）
?*?
?*?修改時(shí)間：2015-9-9
?*/
import?java.io.ByteArrayInputStream;
import?java.io.FileInputStream;
import?java.io.InputStream;
import?java.io.OutputStream;
import?java.math.BigDecimal;
import?java.text.SimpleDateFormat;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?javax.xml.parsers.DocumentBuilder;
import?javax.xml.parsers.DocumentBuilderFactory;
import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
import?org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import?org.apache.poi.hssf.usermodel.HSSFComment;
import?org.apache.poi.hssf.usermodel.HSSFDateUtil;
import?org.apache.poi.hssf.usermodel.HSSFFont;
import?org.apache.poi.hssf.usermodel.HSSFPatriarch;
import?org.apache.poi.hssf.usermodel.HSSFRichTextString;
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.poifs.filesystem.POIFSFileSystem;
import?org.apache.poi.ss.usermodel.Cellstyle;
import?org.apache.poi.ss.usermodel.IndexedColors;
import?org.apache.poi.xssf.usermodel.XSSFCell;
import?org.apache.poi.xssf.usermodel.XSSFRow;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;
import?org.w3c.dom.Document;
import?org.w3c.dom.Node;
import?org.w3c.dom.NodeList;

import?com.kcm.tools.date.DateUtil;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

public?class?PoiExcelTool?{
	
	/**
	?*?單元格類型的靜態(tài)常量
	?*/
	private?static?final?String?CELL_S_TYPE=“STRING“;
	private?static?final?String?CELL_T_TYPE=“DATE“;
	private?static?final?String?CELL_I_TYPE=“INT“;
	private?static?final?String?CELL_D_TYPE=“DOUBLE“;
	
	/**
	?*?按模板創(chuàng)建EXCEL數(shù)據(jù)文件的主函數(shù)
	?*?@param?_request
	?*?@param?_response
	?*?@param?_excelTempUrl
	?*?@param?_dataJsonStr
	?*?@param?_xmlDFUrl
	?*?@param?_startRowNum
	?*/
	public?static?void?_createExcelMain（HttpServletRequest?_requestHttpServletResponse?_responseString?_excelTempUrlString?_dataJsonStrString?_xmlDFUrlint?_startRowNum）{
		OutputStream?_out?=?null;
		HSSFWorkbook?_fWorkBook=null;
		try{
			_out=_response.getOutputStream（）;
			_request.setCharacterEncoding（“UTF-8“）;
			_response.setCharacterEncoding（“UTF-8“）;
			_response.setHeader（“Content-Type““application/force-download“）;
			_response.setHeader（“Content-Type““application/vnd.ms-excel“）;
			_response.setHeader（“Content-Disposition““attachment;filename=niewei_test.xls“）;
			_fWorkBook=_createExcelFromTemplate（_excelTempUrl_dataJsonStr_xmlDFUrl_startRowNum）;
			_fWorkBook.write（_out）;
			_out.