Java使用jxl对excel文件进展简单的读写

Java使用jxl对excel文件进行简单的读写

jxl的Jar包下载地址：百度网盘

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

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCellFeatures;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

/**
 * 
 * 2014年12月30日 下午7:16:14
 * @author sunfeilong1993
 * 简介：利用jxl实现简单的从excel文件中读取数据和那数据写入到excel文件中
 * 
 */

public class ExcelInputAndOutput {
	public static void main(String[] args) {
		writeToFile();
		readFromFile();
	}
	
	
	//readFromFile
	public static void readFromFile(){
		File file = new File("d:/test.xls");
		StringBuffer sb = new StringBuffer();
		try {
			
			Workbook book = Workbook.getWorkbook(file);
			try{
				
				Sheet sheet = book.getSheet(0);
				for(int i = 0 ; i < 10 ; i++){
					for(int j = 0 ; j < 10 ; j++){
						//第一个参数代表列，第二个参数代表行。(默认起始值都为0)
						sb.append(sheet.getCell(j, i).getContents()+"\t");
					}
					sb.append("\n");
				}
				System.out.println(sb);
			}finally{
				if(book != null){
					book.close();
				}
			}
			
		} catch (BiffException e) {
			System.err.println(e+"");
		} catch (IOException e) {
			System.err.println(e+"文件读取错误");
		}
	}//end readFromFile
	
	//witeToFile
	public static void writeToFile(){
		File file = new File("d:/test.xls");
		try {
			
			WritableWorkbook book = Workbook.createWorkbook(file);
			//创建一个工作区。(默认的excel文件有三个sheet,在excel的左下角可以看到sheet1/sheet2/sheet3）
			WritableSheet sheet = book.createSheet("第一页", 0);
			//在工作区上面添加内容
			try {
				for(int i = 0; i < 10 ; i ++ ){
					for(int j = 0 ; j < 10 ; j++){
						Label newLabel;
						if(0 == i){
							//第一个参数代表列，第二个参数代表行(默认起始值都为0),第三个参数是要在单元格里面填写的内容发
							newLabel = new Label(j,i,String.valueOf(j));
						}else if(0 == j){
							newLabel = new Label(j,i,String.valueOf(i));
						}else{
							newLabel = new Label(j,i,String.valueOf(i*j));
						}
						//在单元格上面添加注释
						WritableCellFeatures cellFeatures = new WritableCellFeatures();
						cellFeatures.setComment("这里是"+i+"*"+j+"的值");
						newLabel.setCellFeatures(cellFeatures);
						sheet.addCell(newLabel);
					}
				}
			} catch (RowsExceededException e) {
				System.err.println(e+"行或列参数错误！");
			} catch (WriteException e) {
				System.err.println(e+"写入失败");
			}finally{
				if(book != null){
					book.write();
					try {
						book.close();
					} catch (WriteException e) {
						System.err.println(e+"文件关闭失败！");
					}
				}
			}
			
		} catch (IOException e) {
			System.err.println(e+"创建文件失败！");
		}
	}
	
	
}