excel表的多页合并问题！很急！请多帮忙！

[shiguangxinno1]

请问各位高手，小弟怎样才能把一个excel表中多页中的纪录合成一个列表做到一个sheet中，不再分页？？？

由于时间很紧，还请各位高手多多帮忙！！
最好是能给小弟一段比较详细的代码！！
先谢谢各位了！！！！！！

[pleonheart]

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

[keke1]

用复制，粘贴不是就可以了

[pleonheart]

楼上说的也对，哈哈

[tiger_wkh52741]

你看看吧，乱码是日文，对你的问题没有影响！

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();
}

}