Jxl.jar包对Excel文档进行简单操作

package com.achievo;

import java.io.*;
import jxl.*;
import jxl.write.*;

public class JxlDemo{
	
	public static void main (String[] args)throws Exception {
		JxlDemo jd = new JxlDemo();
		jd.createXLS();
		jd.readXLS();
    }
    //创建XLS文档，并写入数据
    public  void createXLS()throws Exception{
    	//create new XLS document
		jxl.write.WritableWorkbook book = jxl.Workbook.createWorkbook(new File("测试.xls"));
		//生成名为“第一页”的工作表，参数0表示是第一页 
		jxl.write.WritableSheet sheet = book.createSheet("第一页",0);
		//在Label对象的构造出单元格第一列第一行(0,0,)的值为test
		jxl.write.Label label = new jxl.write.Label(0,0,"test");
		//将定义好的Label对象利用sheet对象添加到工作表中
		sheet.addCell(label);
		//生产数据的单元格
		jxl.write.Number number = new jxl.write.Number(1,0,123.21);
		sheet.addCell(number);
		//写入数据并进行关闭
		book.write();
		book.close();
	}
	//一次型读取XLS文档
	public  void readXLS()throws Exception{
		//获取XLS对象
		jxl.Workbook book = jxl.Workbook.getWorkbook(new File("测试.xls"));
		//获取XLS第一页的工作表
		jxl.Sheet sheet = book.getSheet(0);
		//进行读取，可根据自己的实际情况去读取
		int i=0;
		do{
			int j=0;
			String str1;
			
				do{
					jxl.Cell cell;
					try{
						//通过j,i的坐标找到单元格
						 cell = sheet.getCell(j,i);
					}catch(ArrayIndexOutOfBoundsException ex){
						break;
					}
					//用String接收单元格的值
					str1= cell.getContents();
					System.out.println(str1);
					j++;
				}while(true);
			i++;
		}while(true);
		
	}
}