package?com.cider.javapos2015.servlet.common;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.IOException;
import?java.io.InputStream;
import?java.net.URLEncoder;
import?java.text.DecimalFormat;

import?javax.servlet.ServletException;
import?javax.servlet.ServletOutputStream;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?jxl.CellType;
import?jxl.Workbook;
import?jxl.format.CellFormat;
import?jxl.write.Alignment;
import?jxl.write.Border;
import?jxl.write.BorderLinestyle;
import?jxl.write.Colour;
import?jxl.write.Label;
import?jxl.write.NumberFormat;
import?jxl.write.VerticalAlignment;
import?jxl.write.WritableCellFormat;
import?jxl.write.WritableFont;
import?jxl.write.WriteException;
import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

import?com.cider.javapos2015.tools.GetDataFromSysvar;

public?class?ServletExportExcel?extends?HttpServlet{
	private?static?final?long?serialVersionUID?=?1L;
	private?static?WritableCellFormat?wcf_c?=?null;???
	private?static?WritableCellFormat?wcf_n?=?null;???
	private???Double?sys_toexcel_line?=?0.0;?
//	private?static?final?int?maxFormatRecordsIndex?=?Integer.MAX_VALUE;?
//
//	private?static?final?int?maxFormatRecordsIndex?=?Integer.MAX_VALUE;
	
	@Override
	protected?void?doGet（HttpServletRequest?req?HttpServletResponse?resp）
			throws?ServletException?IOException?{
		this.doPost（req?resp）;
	}
	
	@Override
	protected?void?doPost（HttpServletRequest?req?HttpServletResponse??resp）
			throws?ServletException?IOException?{
		req.setCharacterEncoding（“UTF-8“）;
		resp.setCharacterEncoding（“UTF-8“）;
//		resp.setContentType（“octets/stream“）;?
		?
		//PrintWriter?pw?=?resp.getWriter（）;
		String?ExcelHeader?=?req.getParameter（“ExcelHeader“）;
		String?ExcelContext?=?req.getParameter（“ExcelContext“）;
		String?fileName?=?req.getParameter（“ExcelFileName“）;
		//System.out.println（ExcelContext）;
		JSONArray?ExcelHeaderA?=?JSONArray.fromobject（ExcelHeader）;
		JSONArray?ExcelContextA?=?JSONArray.fromobject（ExcelContext）;
		if（fileName==null?||?fileName.equals（““）?||?fileName.equals（“undefined“））{
			fileName=java.util.UUID.randomUUID（）.toString（）+“.xls“;
		}
		//System.out.println（“attachment;fileName=“+URLEncoder.encode（fileName?“UTF-8“））;
		resp.setHeader（“content-disposition“?“attachment;fileName=“+URLEncoder.encode（fileName?“UTF-8“））;
		
		object?tmpsysvar?=????GetDataFromSysvar.getSysvar（“sys_toexcel_line“）;
		if（tmpsysvar!=null）{
			sys_toexcel_line?=（Double）?tmpsysvar;?
		}
		
//		String?filePath?=?ServletActionContext.getServletContext（）.getRealPath（“/xls/“?+?qh.getQuoid（）.trim（）?+?“.xls“）;
//		String?modelPath?=?ServletActionContext.getServletContext（）.getRealPath（“/xlsmodel/quo.xls“）;
//		File?myFile?=?new?File（filePath）;
//		File?myFile2?=?new?File（modelPath）;
//		
//		try?{
//			if（!myFile.exists（））{
//				myFil