import?java.io.File;
import?java.util.Date;
import?java.util.Scanner;

import?jxl.Cell;
import?jxl.Sheet;
import?jxl.Workbook;
import?jxl.format.Colour;
import?jxl.format.Underlinestyle;
import?jxl.write.DateFormat;
import?jxl.write.DateTime;
import?jxl.write.Label;
import?jxl.write.NumberFormat;
import?jxl.write.WritableCellFormat;
import?jxl.write.WritableFont;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;

/**
?*?企業級大數據錄入-java操作excel
?*?@author?Tony?Liu
?*?@version?1.0
?*?2014-08-18
?*
?*/
public?class?OperatorExcel?{
	
	/**
	?*?生成一個excle文件
	?*?@param?fileName
	?*/
	public?static?void?writeExcel（String?fileName）{
		
		WritableWorkbook?wwb?=?null;
		
		try?{
			//?創建一個可寫入的工作簿（WorkBook）對象
			//這里用父類方法createWorkbook創建子類WritableWorkbook讓我想起了工廠方法
			wwb?=?Workbook.createWorkbook（new?File（fileName））;
			
			//?創建一個可寫入的工作表?
			//?Workbook的createSheet方法有兩個參數，第一個是工作表的名稱，第二個是工作表在工作簿中的位置
			WritableSheet?ws?=?wwb.createSheet（“sheetTest“?0）;
			for（int?i=0;i<10;i++）{
				for（int?j=0;j<5;j++）{
					Label?labelC?=?new?Label（ji“第“+（i+1）+“行，第“+（j+1）+“列“）;
					ws.addCell（labelC）;
				}
			}
			
			wwb.write（）;//?從內從中寫入文件中
			wwb.close（）;
		}?catch?（Exception?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		System.out.println（“生成第一個Excel文件“+fileName+“成功“）;
	}
	
????/**
?????*?excel文件的修改
?????*?@param?fileName?文件路徑+文件名+文件后綴
?????*/
	public?static?void?writeConentToExcel（String?fileName）?throws?Exception{
		
		jxl.write.Number?n?=?null;
		jxl.write.DateTime?d?=?null;
		
		File?tempFile?=?new?File（fileName）;
		WritableWorkbook?workbook?=?Workbook.createWorkbook（tempFile）;
		WritableSheet?sheet?=?workbook.createSheet（“TestCreateExcel“0）;
		
		//?預定義的一些字體和格式，?字形、大小、加粗、傾斜、下劃線、顏色
		//?頭文件
		WritableFont?headerFont?=?new?WritableFont（WritableFont.ARIAL15WritableFont.BOLDfalseUnderlinestyle.NO_UNDERLINEColour.GREEN）;
		WritableCellFormat?headerFormat?=?new?WritableCellFormat（headerFont）;
		
		//?標題
		WritableFont?titleFont?=?new?WritableFont（WritableFont.ARIAL10WritableFont.NO_BOLDfalseUnderlinestyle.NO_UNDERLINEColour.RED）;
		WritableCellFormat?titleFormat?=?new?WritableCellFormat（titleFont）;
		
		//?內容
		WritableFont?detFont?=?new?WritableFont（WritableFont.ARIAL10WritableFont.NO_BOLDfalseUnderlinestyle.NO_UNDERLINEColour.BLACK）;
		WritableCellFormat?detFormat?=?new?WritableCellFormat（detFont）;
		
		//?number?格式
		NumberFormat?nf=new?NumberFormat（“0.000“）;
		WritableCellFormat?priceFormat?=?new?WritableCellFormat（nf）;
		
		//?日期
		DateFormat?df?=?new?DateFormat（“yyyy-MM-dd“）;
		WritableCellFormat?dateFormat?=?new?WritableCellFormat（df）;
		
		//?創建單元格
		Label?l?=?new?Label（00“文件的頭信息“headerFormat）;
		sheet.addCell（l）;
		
		//?添加標題
		int?column=0;?//　列
		l?=?new?Label（column++2“姓名“titleFormat）;
		sheet.addCell（l）;
		l?=?new?Label（column++2“日期“titleFormat）;
		sheet.addCell（l）;
		l?=?new?Label（col

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????456??2014-11-19?14:47??OperatorExcel\.classpath

?????文件????????389??2014-11-19?14:42??OperatorExcel\.project

?????文件????????598??2014-11-19?14:42??OperatorExcel\.settings\org.eclipse.jdt.core.prefs

?????文件???????6069??2014-11-19?14:56??OperatorExcel\bin\OperatorExcel.class

?????文件???????6287??2014-11-19?14:56??OperatorExcel\src\OperatorExcel.java

?????目錄??????????0??2014-11-19?14:42??OperatorExcel\.settings

?????目錄??????????0??2014-11-19?14:47??OperatorExcel\bin

?????目錄??????????0??2014-11-19?14:47??OperatorExcel\src

?????目錄??????????0??2014-11-19?14:42??OperatorExcel

-----------?---------??----------?-----??----

????????????????13799????????????????????9