@Overrideprotected voidBuildexceldocument (map<string, object> Map, Hssfworkbook hssfworkbook, HttpServletRequest HttpServletRequest, HttpServletResponse httpservletresponse)throwsException {List<TGcxxInvitationCode> list = (list<tgcxxinvitationcode>) map.get ("Map"); Hssfsheet sheet=Hssfworkbook.createsheet (); //Create a table headerHssfrow row = Sheet.createrow (0); Hssfcell Cell=NULL; String[] Headers=Newstring[]{"name", "Phone", "account", "Invitation Time", "Registration Time"}; for(inti=0;i) {cell=Row.createcell (i); Cell.setcellvalue (Headers[i]); } //CREATE TABLE Contents if(List! =NULL& List.size () >0) { for(intM=0;m<list.size (); m++) {Hssfrow Bodyrow= Sheet.createrow (M + 1); Tgcxxinvitationcode Invitation=List.get (m); Cell= Bodyrow.createcell (0); Cell.setcellvalue (Invitation.getusertruename ()); Cell= Bodyrow.createcell (1); Cell.setcellvalue (Invitation.getuserphone ()); Cell= Bodyrow.createcell (2); Cell.setcellvalue (Invitation.getloginname ()); Cell= Bodyrow.createcell (3); Cell.setcellvalue (Util.formatdate (Invitation.getcreatetime ())); Cell= Bodyrow.createcell (4); Cell.setcellvalue (Util.formatdate (Invitation.getcreatedate ())); }} String filename= "invitee Details"; Httpservletresponse.setcontenttype ("Application/vnd.ms-excel"); Httpservletresponse.setheader ("Content-disposition", "attachment;filename=" + urlencoder.encode (filename, "UTF-8") + ". xls"); OutputStream OutputStream=Httpservletresponse.getoutputstream (); Hssfworkbook.write (OutputStream); Outputstream.flush (); Outputstream.close (); }
Download of Excel File