读书人

透过Java生成Excel文件

发布时间: 2012-10-26 10:30:58 作者: rapoo

通过Java生成Excel文件

/** *  */package demo;import java.io.File;import javax.swing.filechooser.FileFilter;/** * @author XiaoQuan *  */public class ExcelFileFilter extends FileFilter {public final static String xls = "xls";public final static String XLS = "XLS";public final static String suffix = ".xls";public boolean accept(File file) {if (file.isDirectory()) {return true;}String extension = getExtension(file);if (extension != null) {if (extension.equals(ExcelFileFilter.xls)|| extension.equals(ExcelFileFilter.XLS)) {return true;} else {return false;}}return false;}public String getDescription() {return "保存为EXCEL";}public static String getExtension(File f) {String ext = null;String s = f.getName();int i = s.lastIndexOf('.');if (i > 0 && i < s.length() - 1) {ext = s.substring(i + 1).toLowerCase();}return ext;}}



1 楼 pipihu_yu 2008-08-15 org.apache.poi.*包找不到哟!请问一下这是什么包呢? 2 楼 pipihu_yu 2008-08-15 HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. It does not support the new Excel 2007 .xlsx OOXML file format, which is not OLE2 based.
POI可以到[url] http://www.apache.org/dyn/closer.cgi/jakarta/poi/[/url] 下载。 编译好的jar主要有这样4个:poi包,poi Browser包,poi hdf包,poi hssf例程包。

读书人网 >软件架构设计

热点推荐