Java读取Excel与生成Excel

Excel文件是我们生活中常见的表格形式，怎么用Java来实现，看看下面的例子就可以知道怎么操作

1.读取指定路径的Excel
ReadExcel.java

package com.cyberwise.excel;

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
 * title:读取一个Excel文件
 * @author Lyong
 *
 */
public class ReadExcel {
	
	public static void readExcelFile(){
		Workbook wb;
		
		try {
			
			wb = Workbook.getWorkbook(new File("F:/prjInfo.xls"));
			
			Sheet s = wb.getSheet(0);//第一个sheeet
			
			Cell c;
			
			int row = s.getRows();//总行数
			int col = s.getColumns();//总列数
			
			for(int i = 0;i<row;i++){
				
				for(int j = 0;j<col;j++){
					c = s.getCell(j, i);
					System.out.println(c.getContents()+" ");
				}
				//换行
				System.out.println();
			}
			
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	
	public static void main(String[] args) {
		ReadExcel.readExcelFile();
	}

}

1.生成指定路径的Excel
WriteExcel.java

package com.cyberwise.excel;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

import jxl.Workbook;
import jxl.format.Colour;
import jxl.write.Label;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;


public class WriteExcel {
	
	public static void createExcel(){
		
		//输出Excel文件名
		String tragetFile = "F:/test.xls";
		
		//输出Excel文件工作表名
		String worksheet = "Test";
		
		//Excel工作表的标题
		String[] title = {"姓名","年龄","地址"};
		
		WritableWorkbook  workbook = null;
		
		try {
			OutputStream os = new FileOutputStream(tragetFile);
			
			workbook = Workbook.createWorkbook(os);
			
			WritableSheet sheet  = workbook.createSheet(worksheet, 0);//添加第一个工作表
			
			//合并单元格
			sheet.mergeCells(0, 0, 2, 1);
			
			
			Label label = null;
			
			label = new Label(0,0,"员工基本信息");
			sheet.addCell(label);
			
			insertSheet(label,sheet);
			
			for(int i=0;i<title.length;i++){
				
				//Label(列号，行号，内容)
				label = new Label(i,2,title[i]);//把标题放到第一行
				sheet.addCell(label);
				
			}
			setSheet(sheet);
			workbook.write();
			
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		}finally{
			if(workbook != null){
				try {
					workbook.close();
				} catch (WriteException e) {
					e.printStackTrace();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
	}
	
	/*
	 * 设置sheet的样式
	 */
	public static void setSheet(WritableSheet sheet){
		sheet.getSettings().setProtected(true);//设置xls保护，单元格不能被修改
		sheet.getSettings().setDefaultColumnWidth(20);//设置列的默认宽度
		try {
			//定义字体
			WritableFont font = new WritableFont(WritableFont.TIMES,24,WritableFont.BOLD);	
			font.setColour(Colour.RED);
			
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		}
	}
	
	/*
	 * 写入内容
	 */
	public static  void insertSheet(Label label,WritableSheet sheet){
		try {
			
			label = new Label(0,3,"李四");
			sheet.addCell(label);
			
			label = new Label(1,3,"22");
			sheet.addCell(label);
			
			label = new Label(2,4,"湖南长沙");
			sheet.addCell(label);
			
			label = new Label(0,4,"张三");
			sheet.addCell(label);
			
			label = new Label(1,4,"22");
			sheet.addCell(label);
			
			label = new Label(2,4,"湖南株洲");
			sheet.addCell(label);
			
		} catch (RowsExceededException e) {
			e.printStackTrace();
		} catch (WriteException e) {
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) {
		WriteExcel.createExcel();
	}

}