Excel读取和输入要用到JXL包
输出Excel的代码示例
File file = new File("d:\\t.xls");
//也可以通过流输出,创建一个工作薄
WritableWorkbook book = Workbook.createWorkbook(file);
//创建一个工作表
WritableSheet sheet = book.createSheet("sheet1", 0);
//设置列宽
sheet.setColumnView(0,5);
sheet.setColumnView(1,15);
sheet.setColumnView(2,15);
sheet.setColumnView(3,15);
sheet.setColumnView(4,15);
sheet.setColumnView(5,15);
//定义标题的文字格式
WritableFont wf_title = new jxl.write.WritableFont(WritableFont.createFont("微软雅黑"), 14,WritableFont.BOLD);
WritableCellFormat wcf_title = new WritableCellFormat(wf_title);
wcf_title.setAlignment(Alignment.CENTRE);
//添加标题所在的单元格,Label参数,列序号,行序号,文字,[格式]
sheet.addCell(new Label(0,0,"测试标题",wcf_title));
//合并标题行单元格,参数起始列序号,起始行序号,结束列序号,结束行序号
sheet.mergeCells(0,0,5,0);//占用前6行
//定义列名称格式
WritableCellFormat wcf_title2 = new WritableCellFormat(wf_title);
wcf_title2.setAlignment(Alignment.CENTRE);
wcf_title2.setBackground(Colour.BLUE_GREY);//背景色
//输出列名称
sheet.addCell(new Label(0,1,"序号",wcf_title2));
sheet.addCell(new Label(1,1,"姓名",wcf_title2));
sheet.addCell(new Label(2,1,"性别",wcf_title2));
sheet.addCell(new Label(3,1,"电话",wcf_title2));
sheet.addCell(new Label(4,1,"地址",wcf_title2));
sheet.addCell(new Label(5,1,"备注",wcf_title2));
//输出列表,采用默认格式
for(int i=0;i<10;i++){
sheet.addCell(new Label(0,i+2,""+(i+1)));
sheet.addCell(new Label(1,i+2,"周哥哥"+i));
sheet.addCell(new Label(2,i+2,(i%2==0)?"男":"女"));
sheet.addCell(new Label(3,i+2,""+13+""+i+""+122312));
sheet.addCell(new Label(4,i+2,"地址"+i));
sheet.addCell(new Label(5,i+2,"无"));
}
//关闭和输出
book.write();
book.close();
System.out.println("done...");
读取Excel的代码示例:
public static void main(String[] args) throws Exception{
File file = new File("d:\\t.xls");
//也可以通过流读取,创建一个工作薄
Workbook book = Workbook.getWorkbook(file);
//取得第一张工作表
Sheet sheet = book.getSheet(0);
//取得索引列
Cell[] index = sheet.getRow(1);
//循环内容列
for(int i=2;i<sheet.getRows();i++){
for(int j=0;j<index.length;j++){
if(index[j].getContents().trim().equals("姓名")){
System.out.println(sheet.getRow(i)[j].getContents());
}
}
}
}