Question

利用java向汇总表中粘贴多个excel文档，代码应该如何修改

package jexcel;

import java.io.File;
import java.io.IOException;
import java.io.OutputStream;

import jxl.Cell;
import jxl.JXLException;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class test {

public static void main(String[] args) throws JXLException, IOException {

addtest();
}

private static void addtest() throws JXLException, IOException {

Workbook wb = Workbook.getWorkbook(new File("C:\\Users\\AYLX4B\\Desktop\\360\\汇总表.xls"));
Sheet st = wb.getSheet(0);
int lie = st.getColumns();
int hang = st.getRows();

Workbook wb1 = Workbook.getWorkbook(new File("C:\\Users\\AYLX4B\\Desktop\\360\\1.xls"));
Sheet st1 = wb1.getSheet(0);
int lie1 = st1.getColumns();
int hang1 = st1.getRows();
wb1.close();

WritableWorkbook wwb = Workbook.createWorkbook(new File("C:\\Users\\AYLX4B\\Desktop\\360\\1.xls"),wb);
WritableSheet sheet = wwb.getSheet(0);
for (int i = 0; i < hang; i++) {
for (int j = 0; j < lie; j++) {
Cell cell = st.getCell(j, i);
sheet.addCell(new Label(j,( hang1+i), cell.getContents()));

}
}
wwb.write();
wwb.close();

wb.close();
}

}

Answer 1

用poi，逐个读取每个excel中的sheet，然后新建一个新的excel文件，把读出来的所有sheet加载进去就OK了，poi的具体用法参考下帖/blog/845035

Answer 2

读取出excle中数据，再插入数据库