package?com.itcast.poi.helloworld;

import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.math.BigDecimal;
import?java.text.SimpleDateFormat;
import?java.util.Date;
import?java.util.HashMap;
import?java.util.linkedList;
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.DataFormat;
import?org.apache.poi.ss.usermodel.DateUtil;
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.ss.usermodel.WorkbookFactory;

import?com.itcast.poi.util.NumberUtils;

/**
?*?POI3.9版本?工具類?版本01
?*?@author?呂鵬
?*?@date?2012-12-22
?*/
public?class?PoiHelloworld?{
	static?SimpleDateFormat?sFormat?=?new?SimpleDateFormat（“yyyy-MM-dd“）;
	static?Mapyle>?styleMap?=?new?HashMapyle>（）;?//存儲單元格樣式的Map
	
	
	public?static?void?main（String[]?args）?{
		/**
		?*?讀文件
		?*/
		readExcel（“D:/a.xlsx“）;
		
		/**
		?*?寫文件
		?*/
		testWrite（“D:/a.xlsx““D:/b.xlsx“）;
	}
	
	/**
	?*?讀excel?
	?*?@param?filePath?excel路徑
	?*/
	public?static??void?readExcel（String?filePath）{
		Workbook?book?=?null;
		try?{
			book?=?getExcelWorkbook（filePath）;
			Sheet?sheet?=?getSheetByNum（book1）;
			System.out.println（“sheet名稱是：“+sheet.getSheetName（））;
			
			int?lastRowNum?=?sheet.getLastRowNum（）;
			
			Row?row?=?null;
			for（int?i=0;i<=lastRowNum;i++）{
				row?=?sheet.getRow（i）;
				if（row?!=?null）{
					System.out.println（“正在讀第“+（i+1）+“行：“）;
					int?lastCellNum?=?row.getLastCellNum（）;
					Cell?cell?=?null;
					StringBuilder?sb?=?null;
					for（int?j=0;j						cell?=?row.getCell（j）;
						if（cell?!=?null）{
							sb?=?new?StringBuilder（“第“+（j+1）+“列的單元格內容是：“）;
							String?type_cn?=?null;
							String?type_style?=?cell.getCellstyle（）.getDataFormatString（）.toUpperCase（）;
							String?type_style_cn?=?getCellstyleByChinese（type_style）;
							int?type?=?cell.getCellType（）;
							String?value?=?““;
							switch?（type）?{
								case?0:
									if（DateUtil.isCellDateFormatted（cell））{
										type_cn?=?“NUMBER-DATE“;
										Date?date?=?cell.getDateCellValue（）;
										value?=?sFormat.format（date）;
									}else?{
										type_cn?=?“NUMBER“;
										double?tempValue?=?cell.getNumericCellValue（）;
										value?=?String.valueOf（tempValue）;
									}
									break;
								case?1:
									type_cn?=?“STRING“;
									value?=?cell.getStringCellValue（）;
									break;
								case?2:
									type_cn?=?“FORMULA“;
									value?=?cell.getCellFormula（）;
									break;
								case?3:
									type_cn?=?“BLANK“;
									value?=?cell.getStringCellValue（）;
									break;
								case?4:
									type_cn?=?“BOOLEAN“;
									boolean?tempValue?=?cell.getBooleanCellValue（）;

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

?????文件????????847??2012-12-22?16:54??POI3.9\.classpath

?????文件????????291??2012-12-22?16:54??POI3.9\.mymetadata

?????文件???????1008??2012-12-22?16:54??POI3.9\.project

?????文件???????9012??2012-12-22?21:36??POI3.9\src\com\itcast\poi\helloworld\PoiHelloworld.java

?????文件???????2144??2012-12-22?19:33??POI3.9\src\com\itcast\poi\util\NumberUtils.java

?????文件????????834??2012-12-22?16:54??POI3.9\WebRoot\index.jsp

?????文件?????????39??2012-12-22?16:54??POI3.9\WebRoot\meta-INF\MANIFEST.MF

?????文件??????10054??2012-12-22?21:36??POI3.9\WebRoot\WEB-INF\classes\com\itcast\poi\helloworld\PoiHelloworld.class

?????文件???????2297??2012-12-22?19:33??POI3.9\WebRoot\WEB-INF\classes\com\itcast\poi\util\NumberUtils.class

?????文件?????313898??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\dom4j-1.6.1.jar

?????文件????1869113??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\poi-3.9-20121203.jar

?????文件?????936648??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\poi-ooxml-3.9-20121203.jar

?????文件????4802621??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\poi-ooxml-schemas-3.9-20121203.jar

?????文件??????26514??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\stax-api-1.0.1.jar

?????文件????2666695??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib\xmlbeans-2.3.0.jar

?????文件????????381??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\web.xml

?????目錄??????????0??2012-12-22?16:55??POI3.9\WebRoot\WEB-INF\classes\com\itcast\poi\helloworld

?????目錄??????????0??2012-12-22?18:56??POI3.9\WebRoot\WEB-INF\classes\com\itcast\poi\util

?????目錄??????????0??2012-12-22?18:56??POI3.9\WebRoot\WEB-INF\classes\com\itcast\poi

?????目錄??????????0??2012-12-22?16:55??POI3.9\src\com\itcast\poi\helloworld

?????目錄??????????0??2012-12-22?18:56??POI3.9\src\com\itcast\poi\util

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\classes\com\itcast

?????目錄??????????0??2012-12-22?18:56??POI3.9\src\com\itcast\poi

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\classes\com

?????目錄??????????0??2012-12-22?16:54??POI3.9\src\com\itcast

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\classes

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF\lib

?????目錄??????????0??2012-12-22?16:54??POI3.9\src\com

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\meta-INF

?????目錄??????????0??2012-12-22?16:54??POI3.9\WebRoot\WEB-INF

............此處省略7個文件信息