package?xunsmart;

import?org.apache.poi.hssf.usermodel.HSSFCell;
import?org.apache.poi.hssf.usermodel.HSSFRow;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
?*?HSSF導(dǎo)出
?*?
?*?@author?xunsmart
?*
?*/
public?class?HssfDemo?{
	public?static?void?main（String[]?args）?throws?Exception?{
		//?定義一個(gè)表頭
		String[]?title?=?{?“id“?“name“?“sex“?};

		//?創(chuàng)建一個(gè)工作簿
		HSSFWorkbook?wb?=?new?HSSFWorkbook（）;
		//?創(chuàng)建一個(gè)工作表sheet
		HSSFSheet?sheet?=?wb.createSheet（“工作表名“）;
		//?創(chuàng)建第一行
		HSSFRow?row?=?sheet.createRow（0）;
		HSSFCell?cell?=?null;
		//?插入第一行數(shù)據(jù)（表頭）
		for?（int?i?=?0;?i?tle.length;?i++）?{
			cell?=?row.createCell（i）;
			cell.setCellValue（title[i]）;
		}
		//?插入數(shù)據(jù)
		for?（int?i?=?1;?i?<=?10;?i++）?{
			HSSFRow?nextRow?=?sheet.createRow（i）;
			HSSFCell?newCell?=?nextRow.createCell（0）;
			newCell.setCellValue（“a“?+?i）;

			newCell?=?nextRow.createCell（1）;
			newCell.setCellValue（“user“?+?i）;

			newCell?=?nextRow.createCell（2）;
			newCell.setCellValue（“男“?+?i）;
		}
		Utils.createExcel（wb?“工作簿.xls“）;
	}
}

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

?????文件????????841??2017-09-07?16:26??poiDemo\.classpath

?????文件???????1040??2017-09-07?15:23??poiDemo\.project

?????文件????????567??2017-09-07?15:23??poiDemo\.settings\.jsdtscope

?????文件????????364??2017-09-07?15:23??poiDemo\.settings\org.eclipse.jdt.core.prefs

?????文件????????473??2017-09-07?15:23??poiDemo\.settings\org.eclipse.wst.common.component

?????文件????????345??2017-09-07?15:23??poiDemo\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-09-07?15:23??poiDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-09-07?15:23??poiDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1903??2017-09-07?16:39??poiDemo\build\classes\xunsmart\HssfDemo.class

?????文件???????2160??2017-09-07?16:36??poiDemo\build\classes\xunsmart\HssfDemo2.class

?????文件???????1346??2017-09-07?16:51??poiDemo\build\classes\xunsmart\Utils.class

?????文件???????1904??2017-09-07?16:39??poiDemo\build\classes\xunsmart\XssfDemo.class

?????文件???????2161??2017-09-07?16:53??poiDemo\build\classes\xunsmart\XssfDemo2.class

?????文件???????1155??2017-09-07?16:39??poiDemo\src\xunsmart\HssfDemo.java

?????文件???????1096??2017-09-07?16:36??poiDemo\src\xunsmart\HssfDemo2.java

?????文件????????559??2017-09-07?16:51??poiDemo\src\xunsmart\Utils.java

?????文件???????1158??2017-09-07?16:39??poiDemo\src\xunsmart\XssfDemo.java

?????文件???????1104??2017-09-07?16:53??poiDemo\src\xunsmart\XssfDemo2.java

?????文件?????????39??2017-09-07?15:23??poiDemo\WebContent\meta-INF\MANIFEST.MF

?????文件?????751238??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\commons-collections4-4.1.jar

?????文件????2679259??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\poi-3.16.jar

?????文件????1433719??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\poi-ooxml-3.16.jar

?????文件????5871746??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\poi-ooxml-schemas-3.16.jar

?????文件????1384931??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\poi-scratchpad-3.16.jar

?????文件????2730866??2017-09-07?16:32??poiDemo\WebContent\WEB-INF\lib\xmlbeans-2.6.0.jar

?????目錄??????????0??2017-09-07?16:53??poiDemo\build\classes\xunsmart

?????目錄??????????0??2017-09-07?16:53??poiDemo\WebContent\WEB-INF\lib

?????目錄??????????0??2017-09-07?16:53??poiDemo\build\classes

?????目錄??????????0??2017-09-07?16:53??poiDemo\src\xunsmart

?????目錄??????????0??2017-09-07?16:53??poiDemo\WebContent\meta-INF

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