java读取和输出Excel

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());
				}
			}
		}
	}