导出excel信息方法
来源:互联网 发布:ubuntu 装 anaconda 编辑:程序博客网 时间:2024/05/22 00:43
package com.sinosoft.utils;
import java.io.File;
import java.util.List;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExportFileUtil {
public static void exportExcelBaseInfo(List<Object[]> list,String filePath,String fileName,
String widths,String headers) throws Exception {
try {
String[] width = widths.split(";");
String[] header = headers.split(";");
/**
* 设置标题字体样式
*/
WritableFont wfTitle = new jxl.write.WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
/**
* 设置列表字体样式
*/
WritableFont wfBody = new jxl.write.WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.NO_BOLD,
false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat wcfTitle = new WritableCellFormat(wfTitle);
WritableCellFormat wcfBody = new WritableCellFormat(wfBody);
wcfTitle.setAlignment(jxl.format.Alignment.CENTRE);
wcfBody.setAlignment(jxl.format.Alignment.CENTRE);
File file = new File(filePath+fileName);
WritableWorkbook workbook = Workbook.createWorkbook(file);
workbook.createSheet("book1", 0);
WritableSheet sheet = workbook.getSheet(0);
Label label = new Label(0, 0, "序号", wcfTitle);
sheet.addCell(label);
/**设置标题列**/
for (int i = 0; i < header.length; i++) {
label = new Label((i + 1), 0, header[i], wcfTitle);
sheet.addCell(label);
/**设置列宽**/
sheet.setColumnView((i + 1), Integer.parseInt(width[i]) / 3);
}
/** 输入列值 **/
for (int j = 0; j < list.size(); j++) {
Object[] result = list.get(j);
label = new Label(0, (j + 1), (j + 1) + "", wcfBody);
sheet.addCell(label);
/**输入行值**/
for (int i = 0; i < result.length ; i++) {
Object temp = result[i];
if (temp==null) {
temp ="";
}
label = new Label((i + 1), (j + 1), temp.toString(), wcfBody);
sheet.addCell(label);
}
}
workbook.write();
workbook.close();
} catch (RuntimeException e) {
e.printStackTrace();
}
}
}
import java.io.File;
import java.util.List;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExportFileUtil {
public static void exportExcelBaseInfo(List<Object[]> list,String filePath,String fileName,
String widths,String headers) throws Exception {
try {
String[] width = widths.split(";");
String[] header = headers.split(";");
/**
* 设置标题字体样式
*/
WritableFont wfTitle = new jxl.write.WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
/**
* 设置列表字体样式
*/
WritableFont wfBody = new jxl.write.WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.NO_BOLD,
false, UnderlineStyle.NO_UNDERLINE, Colour.BLACK);
WritableCellFormat wcfTitle = new WritableCellFormat(wfTitle);
WritableCellFormat wcfBody = new WritableCellFormat(wfBody);
wcfTitle.setAlignment(jxl.format.Alignment.CENTRE);
wcfBody.setAlignment(jxl.format.Alignment.CENTRE);
File file = new File(filePath+fileName);
WritableWorkbook workbook = Workbook.createWorkbook(file);
workbook.createSheet("book1", 0);
WritableSheet sheet = workbook.getSheet(0);
Label label = new Label(0, 0, "序号", wcfTitle);
sheet.addCell(label);
/**设置标题列**/
for (int i = 0; i < header.length; i++) {
label = new Label((i + 1), 0, header[i], wcfTitle);
sheet.addCell(label);
/**设置列宽**/
sheet.setColumnView((i + 1), Integer.parseInt(width[i]) / 3);
}
/** 输入列值 **/
for (int j = 0; j < list.size(); j++) {
Object[] result = list.get(j);
label = new Label(0, (j + 1), (j + 1) + "", wcfBody);
sheet.addCell(label);
/**输入行值**/
for (int i = 0; i < result.length ; i++) {
Object temp = result[i];
if (temp==null) {
temp ="";
}
label = new Label((i + 1), (j + 1), temp.toString(), wcfBody);
sheet.addCell(label);
}
}
workbook.write();
workbook.close();
} catch (RuntimeException e) {
e.printStackTrace();
}
}
}
- 导出excel信息方法
- java导出Excel表格信息
- 导出信息到Excel实践
- 导出信息到excel表
- 导出excel的方法
- 导出excel的方法
- php导出Excel方法
- 导出excel的方法
- EXCEL导出方法
- 通用 Excel 导出方法
- Excel导出方法选择
- GridView导出Excel方法
- WPF 导出EXCEL 方法
- 导出excel的方法
- 导出Excel (application方法)
- 导出Excel方法
- 导出EXCEL方法汇总
- DataGrid导出EXCEL方法
- oracle10g 正则表达式语法
- 菜鸟和C++在一起的日子
- 我挑人的眼光蛮准的
- 类的默认构造函数能否定义为私有
- 供应链变革专案的利器 – SCORE方法论(一)
- 导出excel信息方法
- UIApplicationDelegate
- 重载函数
- 通过flashback_transaction_query查找最近运行过的所有DDL语句
- 分页sql
- libsvm
- Flex中的CSS: (1)本质:CSS被编译器转换为AS代码
- 关于TableView中图片的延时加载
- 用Apache Velocity模板引擎速造网站