用POI(http://jakarta.apache.org/poi)吧,将所有的内容读出来,然后放到一个sheet里就可以了

解决方案 »

  1.   

    你看看吧,乱码是日文,对你的问题没有影响!public void downExcel(String filename, F90JJV09ActionForm actionForm) throws
           java.io.IOException, java.io.FileNotFoundException {     POIExcel poi = new POIExcel(filename, "狠诉缷@婍匕綎緧讖憗i桳壙徹寯曬崘彂嶌惉梡乯");
         HSSFCellStyle cellStyle = poi.getWorkbook().createCellStyle();
         cellStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT);
         poi.writeString(0, 0, "狠诉缷@婍匕綎緧讖憗i桳壙徹寯曬崘彂嶌惉梡乯" + "    " + Tools.getLocaleCurrentTime());
         String[] array = {
             "昞帵懳徾擭寧", actionForm.getSdate()," 晹栧",actionForm.getDropList()};
         poi.writeStringArray(2, 0, array);     String[] titleName = {
             "姩掕壢栚", " 暔審柤徧", "僔儕傾儖斣崋", " 愝抲晹栧", " 宊栺擔", " 宊栺婜娫", "儕乕僗椏","巟暐僒僀僋儖","擭娫儕乕僗","宊栺嬥妟"};
         String[] tableTitle = {
             "SUBJECT_NAME", "THING_NAME", "SERIAL_NO", "SET_DEPART",
             "CONTRACT_DATE", "BETWEEN_DATE", "LISLIO_NAME","SAIKLU_NAME","YEAR","CONTRACT_AMOUNT"};
         String[] total={"2040,000","8160,000"};
         LinkedList table = actionForm.getResultList();
         poi.writeStringArray(4, 0, titleName);
         poi.writeLinkedList(5, 0, table, tableTitle,cellStyle);
         poi.writeStringArray(table.size()+5,titleName.length -2,total);
         poi.saveFile();
       }}