package?cn.good;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.util.ArrayList;
import?java.util.Date;
import?java.util.List;

import?jxl.Workbook;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;
import?jxl.write.WriteException;
import?jxl.write.biff.RowsExceededException;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
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?cn.good.domain.Order;

public?class?ExcelOpt?{

	/**
	??*?生成一個(gè)Excel文件?jxl
	?????*?@param?fileName??要生成的Excel文件名??
	?????*?@jxl.jar?版本：2.6?
	?????*/???
	????public?static?void?writeExcel（String?fileName）{????
	????????WritableWorkbook?wwb?=?null;????
	????????try?{????
	????????????//首先要使用Workbook類的工廠方法創(chuàng)建一個(gè)可寫(xiě)入的工作?。╓orkbook）對(duì)象????
	????????????wwb?=?Workbook.createWorkbook（new?File（fileName））;
	???????????
	????????}?catch?（IOException?e）?{????
	????????????e.printStackTrace（）;????
	????????}????
	????????if（wwb!=null）{????
	????????????//創(chuàng)建一個(gè)可寫(xiě)入的工作表????
	????????????//Workbook的createSheet方法有兩個(gè)參數(shù)，第一個(gè)是工作表的名稱，第二個(gè)是工作表在工作薄中的位置????
	????????????WritableSheet?ws?=?wwb.createSheet（“工作表名稱“?0）;????
	????????????????
	????????????//下面開(kāi)始添加單元格????
	????????????for（int?i=0;i<10;i++）{????
	????????????????for（int?j=0;j<5;j++）{????
	????????????????????//這里需要注意的是，在Excel中，第一個(gè)參數(shù)表示列，第二個(gè)表示行????
	????????????????????Label?labelC?=?new?Label（j?i?“這是第“+（i+1）+“行，第“+（j+1）+“列“）;?
	????????????????????try?{????
	????????????????????????//將生成的單元格添加到工作表中????
	????????????????????????ws.addCell（labelC）;????
	????????????????????}?catch?（RowsExceededException?e）?{????
	????????????????????????e.printStackTrace（）;????
	????????????????????}?catch?（WriteException?e）?{????
	????????????????????????e.printStackTrace（）;????
	????????????????????}????
	???
	????????????????}????
	????????????}????
	???
	????????????try?{????
	????????????????//從內(nèi)存中寫(xiě)入文件中????
	????????????????wwb.write（）;????
	????????????????//關(guān)閉資源，釋放內(nèi)存????
	????????????????wwb.close（）;????
	????????????}?catch?（IOException?e）?{????
	????????????????e.printStackTrace（）;????
	????????????}?catch?（WriteException?e）?{????
	????????????????e.printStackTrace（）;????
	????????????}????
	????????}????
	????}?
	????
	????/**???
	?????*???生成一個(gè)Excel文件POI
	?????*???@param???inputFile???輸入模板文件路徑???
	?????*???@param???outputFile???輸入文件存放于服務(wù)器路徑???
	?????*???@param???dataList???待導(dǎo)出數(shù)據(jù)???
	?????*???@throws???Exception???
	?????*???@roseuid:???
	?????*/?

	????public?static?void?exportExcelFile（String?inputFileString?outputFileList?dataList）?throws?Exception{
	??//用模板文件構(gòu)造poi???
	??POIFSFileSystem?fs?=?new?POIFSFileSystem（new?FileInputStream（inputFile））;

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????571??2013-07-11?16:59??DateToExcel\.classpath

?????文件????????387??2013-07-11?16:39??DateToExcel\.project

?????文件???????8319??2013-07-11?17:26??DateToExcel\src\cn\good\ExcelOpt.java

?????文件???????2787??2013-07-11?17:09??DateToExcel\src\cn\good\domain\Company.java

?????文件???????1707??2013-07-11?17:09??DateToExcel\src\cn\good\domain\Order.java

?????文件?????720702??2013-07-11?16:49??DateToExcel\lib\jxl.jar

?????文件?????908318??2013-07-11?16:59??DateToExcel\lib\poi-3.0-rc4-20070503.jar

?????文件??????59170??2013-07-11?16:59??DateToExcel\lib\poi-contrib-3.0-rc4-20070503.jar

?????文件?????811170??2013-07-11?16:59??DateToExcel\lib\poi-scratchpad-3.0-rc4-20070503.jar

?????文件???????6677??2013-07-11?17:26??DateToExcel\bin\cn\good\ExcelOpt.class

?????文件???????2897??2013-07-11?17:09??DateToExcel\bin\cn\good\domain\Company.class

?????文件???????2361??2013-07-11?17:09??DateToExcel\bin\cn\good\domain\Order.class

?????文件????????629??2013-07-11?16:39??DateToExcel\.settings\org.eclipse.jdt.core.prefs

?????文件????????666??2012-10-09?08:49??ExcelToMysql\.classpath

?????文件????????309??2013-07-09?11:09??ExcelToMysql\.mymetadata

?????文件???????1755??2012-10-09?08:49??ExcelToMysql\.project

?????文件???????1116??2013-07-09?08:57??ExcelToMysql\WebRoot\index.jsp

?????文件????????813??2008-08-19?20:53??ExcelToMysql\WebRoot\WEB-INF\web.xml

?????文件?????394517??2008-08-19?20:40??ExcelToMysql\WebRoot\WEB-INF\lib\jxl.jar

?????文件?????493105??2008-08-19?21:05??ExcelToMysql\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.3-bin.jar

?????文件??????41984??2013-07-09?11:14??ExcelToMysql\WebRoot\WEB-INF\classes\20130626.xls

?????文件??????13824??2008-08-19?20:24??ExcelToMysql\WebRoot\WEB-INF\classes\student.xls

?????文件???????1478??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\servlet\ExcelServlet.class

?????文件????????466??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\server\ExcelServer.class

?????文件????????931??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\dto\Category.class

?????文件???????1939??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\dto\Goods.class

?????文件????????900??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\dto\Student.class

?????文件???????3584??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\dao\Date.class

?????文件???????1068??2013-07-11?10:41??ExcelToMysql\WebRoot\WEB-INF\classes\net\company\connect\ConnCOnnection.class

?????文件?????????39??2008-08-19?20:32??ExcelToMysql\WebRoot\meta-INF\MANIFEST.MF

............此處省略51個(gè)文件信息