資源簡介
實現(xiàn)一個配置簡單功能強(qiáng)大的excel工具類搞定大多數(shù)導(dǎo)入導(dǎo)出.
http://blog.csdn.net/lk_blog/article/details/8007777 http://blog.csdn.net/lk_blog/article/details/8007837
對于J2EE項目導(dǎo)入導(dǎo)出Excel是最普通和實用功能,
本工具類使用步驟簡單,功能強(qiáng)大,只需要對實體類進(jìn)行簡單的注解就能實現(xiàn)導(dǎo)入導(dǎo)出功能,導(dǎo)入導(dǎo)出操作的都是實體對象.
看看這個類都有哪些功能吧:
* 1.實體屬性配置了注解就能導(dǎo)出到excel中,每個屬性都對應(yīng)一列.
* 2.列名稱可以通過注解配置.
* 3.導(dǎo)
代碼片段和文件信息
package?com.tgb.lk;
import?org.apache.poi.hssf.usermodel.HSSFSheet;
import?org.apache.poi.hssf.usermodel.HSSFDataValidation;
import?org.apache.poi.hssf.usermodel.DVConstraint;
import?org.apache.poi.hssf.usermodel.HSSFWorkbook;
import?org.apache.poi.ss.util.CellRangeAddressList;
import?java.io.FileOutputStream;
import?java.io.IOException;
public?class?ExportTest01?{
public?static?void?main（String[]?args）?throws?IOException?{
HSSFWorkbook?wb?=?new?HSSFWorkbook（）;//?excel文件對象
HSSFSheet?sheetlist?=?wb.createSheet（“sheetlist“）;//?工作表對象
FileOutputStream?out?=?new?FileOutputStream（“d:\\success1.xls“）;
String[]?textlist?=?{?“列表1“?“列表2“?“列表3“?“列表4“?“列表5“?};
sheetlist?=?setHSSFValidation（sheetlist?textlist?0?500?0?0）;//?第一列的前501行都設(shè)置為選擇列表形式.
sheetl?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????424??2012-09-20?16:09??ExcelDemo\.classpath
?????文件????????385??2012-09-14?10:36??ExcelDemo\.project
?????文件????????112??2012-09-20?16:09??ExcelDemo\.settings\org.eclipse.core.resources.prefs
?????文件????????629??2012-09-14?10:36??ExcelDemo\.settings\org.eclipse.jdt.core.prefs
?????文件???????3132??2012-09-22?15:37??ExcelDemo\bin\com\tgb\lk\ExportTest01.class
?????文件???????4178??2012-09-22?15:42??ExcelDemo\bin\com\tgb\lk\ExportTest02.class
?????文件???????1966??2012-09-22?16:21??ExcelDemo\bin\com\tgb\lk\test03\ExportTest03.class
?????文件???????1365??2012-09-22?15:40??ExcelDemo\bin\com\tgb\lk\test03\ImportTest03.class
?????文件???????2062??2012-09-22?15:40??ExcelDemo\bin\com\tgb\lk\test03\StudentVO.class
?????文件???????3294??2012-09-22?15:40??ExcelDemo\bin\com\tgb\lk\test04\ExportTest04.class
?????文件???????3110??2012-09-22?17:26??ExcelDemo\bin\com\tgb\lk\test04\ImportTest04.class
?????文件???????2012??2012-09-22?13:51??ExcelDemo\bin\com\tgb\lk\test04\Student.class
?????文件???????2051??2012-09-22?15:41??ExcelDemo\bin\com\tgb\lk\test04\StudentVO.class
?????文件??????10096??2012-09-22?16:37??ExcelDemo\bin\com\tgb\lk\util\ExcelUtil.class
?????文件????????592??2012-09-22?15:40??ExcelDemo\bin\com\tgb\lk\util\ExcelVOAttribute.class
?????文件????????287??2012-09-22?16:14??ExcelDemo\gc.log
?????文件?????725735??2012-09-14?17:10??ExcelDemo\lib\jxl-2.6.jar
?????文件????1516415??2012-09-14?11:00??ExcelDemo\lib\poi-3.5-FINAL-20090928.jar
?????文件???????3322??2012-09-22?15:37??ExcelDemo\src\com\tgb\lk\ExportTest01.java
?????文件???????3370??2012-09-22?15:42??ExcelDemo\src\com\tgb\lk\ExportTest02.java
?????文件???????1306??2012-09-22?16:21??ExcelDemo\src\com\tgb\lk\test03\ExportTest03.java
?????文件????????606??2012-09-22?15:40??ExcelDemo\src\com\tgb\lk\test03\ImportTest03.java
?????文件???????1322??2012-09-22?15:40??ExcelDemo\src\com\tgb\lk\test03\StudentVO.java
?????文件???????2515??2012-09-22?15:40??ExcelDemo\src\com\tgb\lk\test04\ExportTest04.java
?????文件???????2404??2012-09-22?17:26??ExcelDemo\src\com\tgb\lk\test04\ImportTest04.java
?????文件???????1122??2012-09-21?10:36??ExcelDemo\src\com\tgb\lk\test04\Student.java
?????文件???????1405??2012-09-22?15:41??ExcelDemo\src\com\tgb\lk\test04\StudentVO.java
?????文件??????10400??2012-09-22?16:37??ExcelDemo\src\com\tgb\lk\util\ExcelUtil.java
?????文件????????766??2012-09-22?15:40??ExcelDemo\src\com\tgb\lk\util\ExcelVOAttribute.java
?????目錄??????????0??2012-09-22?15:40??ExcelDemo\bin\com\tgb\lk\test03
............此處省略19個文件信息
評論
共有 條評論