这个也不叫原创的了,只是把别人的弄过来调试编译了一下,没问题的
这个需要第三方jxl.jar文件,网上执行下载
private static File createXLS(String path) {
File file = null;
try {
file = new File(path);
if (file.exists())
return file;
WritableWorkbook book = Workbook.createWorkbook(file);
WritableSheet sheet = book.createSheet("sheet1", 0);
book.write();
book.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
return file;
}
}
private static boolean addData(File file, List<String> table) throws IOException,
RowsExceededException, WriteException {
Workbook wb=null;
try {
wb = Workbook.getWorkbook(file);
} catch (BiffException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
WritableWorkbook book = Workbook.createWorkbook(file, wb);
WritableSheet sheet = book.getSheet(0);
List<String> attrs = table;
int i = sheet.getRows();
for (int attr = 0; attr < attrs.size(); attr++) {
Label label = new Label(attr, i, attrs.get(attr));
sheet.addCell(label);
}
book.write();
book.close();
wb.close();
return true;
}