package?test;

import?java.io.*;
import?org.apache.poi.ss.usermodel.Borderstyle;
import?org.apache.poi.ss.usermodel.HorizontalAlignment;
import?org.apache.poi.xssf.usermodel.XSSFCell;
import?org.apache.poi.xssf.usermodel.XSSFCellstyle;
import?org.apache.poi.xssf.usermodel.XSSFFont;
import?org.apache.poi.xssf.usermodel.XSSFRow;
import?org.apache.poi.xssf.usermodel.XSSFSheet;
import?org.apache.poi.xssf.usermodel.XSSFWorkbook;

import?javafx.scene.layout.Border;
public?class?demo01?{
	public?static?void?ExcelRead（）?throws?Exception?{
		//確定要操作的是c:/1.xls
		?XSSFWorkbook?workbook?=?new?XSSFWorkbook（new?FileInputStream（new?File（“D:/test.xlsx“）））;
//		HSSFWorkbook?workbook?=?new?HSSFWorkbook（）;
		//取第0個單元表
		XSSFSheet?sheet?=?workbook.getSheetAt（0）;
		//sheet.getPhysicalNumberOfRows（）;求出所有行數
		for?（int?i?=?0;?i?			//取一行操作
			XSSFRow?row?=?sheet.getRow（i）;
			//row.getPhysicalNumberOfCells（）;求出本行的單元格數，也就是列數
			for?（int?j?=?0;?j?				System.out.print（row.getCell（j）?+?“\t“）;
			}
			System.out.println（）;
		}
	}
?
	public?static?void?main（String[]?args）?throws?Exception?{
		//		ExcelRead（）;
		ExcelWrite（）;
	}
	
	
	
	public?static?void?setBoderstyle（XSSFCellstyle?style）?{
		style.setBorderTop（Borderstyle.DOUBLE）;?//?上邊框為雙線
		style.setBorderRight（Borderstyle.DASH_DOT_DOT）;?//?右邊框為虛線
		style.setBorderBottom（Borderstyle.DASHED）;?//?底邊框為單線
		style.setBottomBorderColor（（short）1）;//?底邊框為紅色
	}
?
	public?static?void?setFontstyle（XSSFWorkbook?workbook?XSSFCellstyle?style）?{
		XSSFFont?font?=?workbook.createFont（）;//?要設置字體樣式先要創建字體
		font.setFontHeightInPoints（（short）?16）;//?字號
		font.setBold（true）;//?加粗
		font.setItalic（true）;//?斜體
		font.setColor（（short）8）;//?字體顏色是紅色
		style.setFont（font）;?//?把這個設置好的字體樣色壓入樣式
	}
?
	public?static?void?allColumnAutoSize（XSSFSheet?sheet）?{
		//?遍歷所有單元格，把單元格皆設置為最優列寬。
		for?（int?i?=?0;?i?			XSSFRow?row?=?sheet.getRow（i）;
			for?（int?j?=?0;?j?				sheet.autoSizeColumn（j）;
			}
		}
	}
?
	public?static?void?ExcelWrite（）?{
?
		//?創建一個webbook，對應一個Excel文件
		XSSFWorkbook?workbook?=?new?XSSFWorkbook（）;
		//?在webbook中添加一個Excel單元表sheet，并設置單元表的問題
		XSSFSheet?sheet?=?workbook.createSheet（“單元表標題“）;
?
		//?在sheet中添加第0行，注意老版本poi對Excel的行數列數是有限制
		XSSFRow?row?=?sheet.createRow（0）;
		//?創建一個居中樣式
		XSSFCellstyle?style?=?workbook.createCellstyle（）;
		style.setAlignment（HorizontalAlignment.CENTER）;
		//?在于這個居中樣式的基礎上，添加表格邊框樣式
		setBoderstyle（style）;
		//?創建第0個單元格
		XSSFCell?cell?=?row.createCell（0）;
		//?設置這個單元格的內容為“一”
		cell.setCellValue（“一“）;
		//?設置這個單元格的格式為上面設置好的居中樣式+表格邊框樣式
		cell.setCellstyle（style）;
		//?同理創建第1個單元格并且設置好樣式，下面以此類推
		cell?=?row.createCell（1）;
		cell.setCellValue（“二“）;
		cell.setCellstyle（style）;
		cell?=?row.createCell（2）;
		cell.setCellValue（“三“）;
		cell.setCellstyle（style）;
?
		//?創建第1行

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-14?11:11??Read_Excel\
?????文件????????2256??2018-12-19?10:44??Read_Excel\.classpath
?????文件?????????910??2018-12-14?11:11??Read_Excel\.project
?????目錄???????????0??2018-12-14?11:11??Read_Excel\.settings\
?????文件?????????567??2018-12-14?11:11??Read_Excel\.settings\.jsdtscope
?????文件?????????364??2018-12-14?11:11??Read_Excel\.settings\org.eclipse.jdt.core.prefs
?????文件?????????482??2018-12-14?11:11??Read_Excel\.settings\org.eclipse.wst.common.component
?????文件?????????345??2018-12-14?11:11??Read_Excel\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-12-14?11:11??Read_Excel\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-12-14?11:11??Read_Excel\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-12-14?11:11??Read_Excel\WebContent\
?????目錄???????????0??2018-12-14?11:11??Read_Excel\WebContent\meta-INF\
?????文件??????????39??2018-12-14?11:11??Read_Excel\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2018-12-14?11:11??Read_Excel\WebContent\WEB-INF\
?????目錄???????????0??2018-12-19?11:01??Read_Excel\WebContent\WEB-INF\lib\
?????文件??????335042??2018-12-19?10:33??Read_Excel\WebContent\WEB-INF\lib\commons-codec-1.11.jar
?????文件??????752798??2018-12-19?10:59??Read_Excel\WebContent\WEB-INF\lib\commons-collections4-4.2.jar
?????文件??????591748??2018-12-19?11:01??Read_Excel\WebContent\WEB-INF\lib\commons-compress-1.18.jar
?????文件??????173587??2018-11-30?18:44??Read_Excel\WebContent\WEB-INF\lib\commons-io-2.2.jar
?????文件???????61829??2018-12-19?10:33??Read_Excel\WebContent\WEB-INF\lib\commons-logging-1.2.jar
?????文件??????314932??2018-12-19?10:33??Read_Excel\WebContent\WEB-INF\lib\junit-4.12.jar
?????文件??????489884??2018-12-19?10:33??Read_Excel\WebContent\WEB-INF\lib\log4j-1.2.17.jar
?????文件?????2718209??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-4.0.1.jar
?????文件??????424225??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-examples-4.0.1.jar
?????文件???????31336??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-excelant-4.0.1.jar
?????文件?????1766188??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-ooxml-4.0.1.jar
?????文件?????7771088??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-ooxml-schemas-4.0.1.jar
?????文件?????1383430??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\poi-scratchpad-4.0.1.jar
?????文件?????2572733??2018-12-19?10:32??Read_Excel\WebContent\WEB-INF\lib\xmlbeans-3.0.2.jar
?????文件?????????656??2018-12-14?11:11??Read_Excel\WebContent\WEB-INF\web.xml
?????目錄???????????0??2018-12-14?11:11??Read_Excel\build\
............此處省略6個文件信息