Java Import Export Excel

One, export Excel

1, using Excel templates

 Public voidExportlog ()throwsexception{systemuser currentusr=Getcurrentsystemuser (); //All logs for this userList<tloginfo> loglist=Logservice.getloginfosbyuserid (Currentusr.getid ()); List<TLogInfo> list=NewArraylist<tloginfo>(); if(loglist!=NULL&& loglist.size () >0){             for(Tloginfo log:loglist) {Tloginfo export=NewTloginfo ();                Export.setproname (Log.getproname ());                Export.setlogtitle (Log.getlogtitle ());                Export.setlogtype (Log.getlogtype ());                Export.setworktime (Log.getworktime ());                Export.setlogfilltime (Log.getlogfilltime ());            List.add (export); }} String Templatefilename= "Xlstemp/personallog.xls"; String Resultfilename= "Xlsresult/personallog.xls"; String Path=excelutil.createexcel (Templatefilename, List, resultfilename); File File=NewFile (path); byte[] bytes =Fileutils.readfiletobytearray (file); DownloadFile ("Information. xls", bytes);                    File.deleteonexit (); }

The Createexcel method of Excelutil class

 Public StaticString Createexcel (String templatefilename, list<?>list, String resultfilename) {        //Create a Xlstransformer objectXlstransformer transformer =NewXlstransformer (); //Get the Java Project post-compilation root pathString Class_path = Excelutil.class. getClassLoader (). GetResource (""). GetPath (); //Get template file pathString Srcfilepath = Class_path +Templatefilename; Map<string, object> beanparams =NewHashmap<string, object>(); Beanparams.put ("List", list); String Destfilepath= Class_path +Resultfilename; Try {            //To generate an Excel fileTransformer.transformxls (Srcfilepath, Beanparams, Destfilepath); returnDestfilepath; } Catch(parsepropertyexception e) {e.printstacktrace (); } Catch(invalidformatexception e) {e.printstacktrace (); }Catch(IOException e) {e.printstacktrace (); }        return NULL; }

Not to be continued ....

Java Import Export Excel