创建一个EXCEL报表。有多个Sheet,通过循环输出每一个Sheet不同的内容。
代码如下:
// 创建工作薄
WritableWorkbook workbook = Workbook.createWorkbook(new File(
"C:\Users\ycx\Desktop/" + "JAVA生成EXCEL测试1.xls"));
int sum = 0;
for (String key : boxCode_Num.keySet()) {
WritableSheet sheet = workbook.createSheet(key, sum);
Map<String, List<String>> map = boxCode_Num.get(key);
int k = 0;
for (String key_in : map.keySet()) {
Label BoxCode = new Label(0, k, "boxCode:" + key_in);
sheet.addCell(BoxCode);
List<String> list = new ArrayList();
list = map.get(key_in);
for (int i = 0; i < list.size(); i++) {
String a = list.get(i);
Label branthNum = new Label(3, k++, "branthCode:" + a);
sheet.addCell(branthNum);
}
}
sum++;
}
// 把创建的内容写入到输出流中,并关闭输出流
workbook.write();
workbook.close();
比如我有两个sheet,但是两个sheet的内容完全重复。除了sheet的名字不一样