|
使用java操作Excel文件(11) ilength++; } System.out.print(sql); System.out.println("lenth of i:"+ilength); return sql; } //----------------------------------------------------------- public static void main(String[] args) { testxls testxls1 = new testxls(); testxls1.filechooer(); //testxls1.sheet= testxls1.getSheet(testxls1.filechooer()); //testxls1.generateinsertsql(testxls1.outresult()); //testxls1.outputXlsContent(testxls1.generateinsertsql(testxls1.outresult())); // System.exit(0); } } 文件过滤器类: package testxls; /** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2004</p> * <p>Company: </p> * @author ClarkHillm@hotmailcom * @version 1.0 */ import Java.io.*; import Javax.swing.filechooser.FileFilter; public class XlsFileFiliter extends Javax.swing.filechooser.FileFilter { public String getFilePostfix(String FileName)//截取文件后缀。 { return FileName.substring(FileName.lastIndexOf(".")+1); } //--------------------------------------------------
|