package?poiTest;

import?org.apache.poi.hssf.usermodel.HSSFCellstyle;
import?org.apache.poi.hssf.util.HSSFColor;
import?org.apache.poi.xssf.usermodel.XSSFCellstyle;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;

public?class?Cellstyle?{
	
	?public?static?XSSFCellstyle?getstyle（XSSFWorkbook?workbook）?{??
	????????
	????????//設置樣式;??
	????????XSSFCellstyle?style?=?workbook.createCellstyle（）;??
	????????//設置底邊框;??
	????????style.setBorderBottom（HSSFCellstyle.BORDER_THIN）;??
	????????//設置底邊框顏色;??
	????????style.setBottomBorderColor（HSSFColor.BLACK.index）;??
	????????//設置左邊框;??
	????????style.setBorderLeft（HSSFCellstyle.BORDER_THIN）;??
	????????//設置左邊框顏色;??
	????????style.setLeftBorderColor（HSSFColor.BLACK.index）;??
	????????//設置右邊框;??
	????????style.setBorderRight（HSSFCellstyle.BORDER_THIN）;??
	????????//設置右邊框顏色;??
	????????style.setRightBorderColor（HSSFColor.BLACK.index）;??
	????????//設置頂邊框;??
	????????style.setBorderTop（HSSFCellstyle.BORDER_THIN）;??
	????????//設置頂邊框顏色;??
	????????style.setTopBorderColor（HSSFColor.BLACK.index）;??
	????????//設置自動換行;??
	????????style.setWrapText（false）;??
	????????//設置水平對齊的樣式為居中對齊;??
	????????style.setAlignment（HSSFCellstyle.ALIGN_CENTER）;??
	????????//設置垂直對齊的樣式為居中對齊;??
	????????style.setVerticalAlignment（HSSFCellstyle.VERTICAL_CENTER）;??
	????????return?style;??
	????}??

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-21?17:45??POI模板導出\
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\
?????文件?????????588??2014-10-19?15:51??POI模板導出\poiTest\.classpath
?????文件????????1040??2014-10-19?15:51??POI模板導出\poiTest\.project
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\.settings\
?????文件?????????503??2014-10-19?15:51??POI模板導出\poiTest\.settings\.jsdtscope
?????文件?????????364??2014-10-19?15:51??POI模板導出\poiTest\.settings\org.eclipse.jdt.core.prefs
?????文件?????????473??2014-10-19?15:51??POI模板導出\poiTest\.settings\org.eclipse.wst.common.component
?????文件?????????305??2014-10-19?15:51??POI模板導出\poiTest\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-10-19?15:51??POI模板導出\poiTest\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-10-19?15:51??POI模板導出\poiTest\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\WebContent\
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\WebContent\meta-INF\
?????文件??????????39??2014-10-19?15:51??POI模板導出\poiTest\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\WebContent\WEB-INF\
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\WebContent\WEB-INF\lib\
?????文件??????313898??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\dom4j-1.6.1.jar
?????文件?????1949542??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\poi-3.10.1-20140818.jar
?????文件?????1035419??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\poi-ooxml-3.10.1-20140818.jar
?????文件?????4946391??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\poi-ooxml-schemas-3.10.1-20140818.jar
?????文件?????1239802??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\poi-scratchpad-3.10.1-20140818.jar
?????文件???????26514??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\stax-api-1.0.1.jar
?????文件?????2730866??2014-10-10?13:12??POI模板導出\poiTest\WebContent\WEB-INF\lib\xmlbeans-2.6.0.jar
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\build\
?????目錄???????????0??2018-11-20?11:08??POI模板導出\poiTest\build\classes\
?????目錄???????????0??2018-11-20?11:08??POI模板導出\poiTest\build\classes\poiTest\
?????文件????????1170??2018-11-20?11:08??POI模板導出\poiTest\build\classes\poiTest\Cellstyle.class
?????文件???????15448??2018-11-20?11:08??POI模板導出\poiTest\build\classes\poiTest\Test.class
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\src\
?????目錄???????????0??2014-10-20?18:03??POI模板導出\poiTest\src\poiTest\
?????文件????????1541??2014-10-20?17:32??POI模板導出\poiTest\src\poiTest\Cellstyle.java
............此處省略2個文件信息