/**
* 生成Excel文件到D:/LOG/下
*
* @param list
* @param response
* @param filename
* @param title
*/
public static void createExcel(List list, HttpServletResponse response,
String filename, String title[]) {
int row = 1;
int page = 1;
OutputStream os = null;
WritableWorkbook workbook = null;
try {
os = response.getOutputStream();
response.setHeader("Content-disposition", "attachment; filename="
+ java.net.URLEncoder.encode(filename, "UTF-8") + ".xls"); // 设定输出文件头
response.setContentType("application/excel"); // 定义输出类型
// 判断文件夹是否存在,不存在则创建
try {
if (!(new File("D:/LOG/").isDirectory())) {
new File("D:/LOG/").mkdir();
}
} catch (SecurityException e) {
e.printStackTrace();
}
Calendar time = Calendar.getInstance();
workbook = Workbook.createWorkbook(new File(
"D:\\LOG\\Test报表get.xls"));
workbook = Workbook.createWorkbook(os);
WritableSheet sheet = null;
WritableFont font = new WritableFont(WritableFont.createFont("宋体"),
10, WritableFont.BOLD, false,
jxl.format.UnderlineStyle.NO_UNDERLINE);
WritableCellFormat format = new WritableCellFormat(font);
format.setBackground(Colour.GRAY_25);
if (list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
if (i % 60000 == 0 || i == 0) {
sheet = workbook.createSheet("页面" + page, page++);
for (int k = 0; k < title.length; k++) {
sheet.addCell(new Label(k, 0, title[k], format));
}
row = 1;
}
String str[] = (String[]) list.get(i);
for (int j = 0; j < str.length; j++) {
sheet.addCell(new Label(j, row, str[j]));
}
++row;
}
} else {
sheet = workbook.createSheet("页面" + page, page++);
for (int i = 0; i < title.length; i++) {
sheet.addCell(new Label(i, 0, title[i], format));
}
}
workbook.write();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
try {
workbook.close();
os.flush();
os.close();
} catch (Exception ex) {
System.out.println("Close os or workbook to error" + ex);
}
}
}
* 生成Excel文件到D:/LOG/下
*
* @param list
* @param response
* @param filename
* @param title
*/
public static void createExcel(List list, HttpServletResponse response,
String filename, String title[]) {
int row = 1;
int page = 1;
OutputStream os = null;
WritableWorkbook workbook = null;
try {
os = response.getOutputStream();
response.setHeader("Content-disposition", "attachment; filename="
+ java.net.URLEncoder.encode(filename, "UTF-8") + ".xls"); // 设定输出文件头
response.setContentType("application/excel"); // 定义输出类型
// 判断文件夹是否存在,不存在则创建
try {
if (!(new File("D:/LOG/").isDirectory())) {
new File("D:/LOG/").mkdir();
}
} catch (SecurityException e) {
e.printStackTrace();
}
Calendar time = Calendar.getInstance();
workbook = Workbook.createWorkbook(new File(
"D:\\LOG\\Test报表get.xls"));
workbook = Workbook.createWorkbook(os);
WritableSheet sheet = null;
WritableFont font = new WritableFont(WritableFont.createFont("宋体"),
10, WritableFont.BOLD, false,
jxl.format.UnderlineStyle.NO_UNDERLINE);
WritableCellFormat format = new WritableCellFormat(font);
format.setBackground(Colour.GRAY_25);
if (list.size() > 0) {
for (int i = 0; i < list.size(); i++) {
if (i % 60000 == 0 || i == 0) {
sheet = workbook.createSheet("页面" + page, page++);
for (int k = 0; k < title.length; k++) {
sheet.addCell(new Label(k, 0, title[k], format));
}
row = 1;
}
String str[] = (String[]) list.get(i);
for (int j = 0; j < str.length; j++) {
sheet.addCell(new Label(j, row, str[j]));
}
++row;
}
} else {
sheet = workbook.createSheet("页面" + page, page++);
for (int i = 0; i < title.length; i++) {
sheet.addCell(new Label(i, 0, title[i], format));
}
}
workbook.write();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
try {
workbook.close();
os.flush();
os.close();
} catch (Exception ex) {
System.out.println("Close os or workbook to error" + ex);
}
}
}