combine multiple excel sheets into one sheet

Label:Page section Entity class section Public Class test{ Private String ID; private String name; Private String address; The following is the Get, set method (omitted) } Action section Get file by strusts2 private file file;Private String FileName;Private String Filecontenttype; Add a Get, set method Get Workbook Object Xssfworkbook WorkBook = new Xssfworkbook (File.getinputstream ()); define Worksheet Xssfsheet workSheet = null; Defines the data obtained from

-id: {0}\r\n"+"content-type:text/html, charset=\ "gbk\" \r\n\r\n"+""+"xmlns:x=\ "urn:schemas-microsoft-com:office:excel\" >\r\n\r\n"+""+""+""+""+""+""+""+""+""+"", GID); Sbsheet.append (""); Sbsheet.append (""); for(inti =0; i ) {Sbsheet.appendformat ("", D.columns[i]. ColumnName); } sbsheet.append (""); for(intj =0; J ) {sbsheet.append (""); for(intK =0; K ) {Sbsheet.appendformat ("", Convert.ToString (D.rows[j][k])); } sbsheet.append (""); } sbsheet.append (""); Sbsheet.append ("

NPOI exports a large amount of EXCEL Data, multiple sheet display data, npoisheet // NPOIHelper class key code using System; using System. collections. generic; using System. linq; using System. text; using System. data; using System. IO; using NPOI. HSSF. userModel; using System. collections; using System. web; namespace Yikeba_htmlConverter {public class NPOIHe

Background code:public static string export2007Front Code:Public ActionResult exportexecl (int? pid) { if (!pid. HasValue) return null; var list = _userinfobo.getanswerbyuser (PID. Value); if (null = = list) return null; var newlist = list. Select (question = new Resultexecl () { //Load Data }). ToList (); var FilePath = excelutil.export2007 (newlist); var fileName = Path.getfilename (File