Java Excel操作控件JExcel

package com.practice.excel;
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.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
 * 利用java excel向excel中写入数据
 * @author lb
 *
 */
public class JExcelTest {
	public static void main(String []args){
		File f = new File("D:"+File.separator+"test.xls");
		String str[][] = {{"姓名","罗彬"},{"email","2362688032@qq.com"}};
		 try {
			WritableWorkbook workbook = Workbook.createWorkbook(f);
			WritableSheet sheet = workbook.createSheet("测试表", 0);
			Label label = null;
			for(int i=0;i<str.length;i++){
				for(int j=0;j<str[i].length;j++){
					label = new Label(j,i,str[i][j]);
					try {
						sheet.addCell(label);
					} catch (RowsExceededException e) {
						e.printStackTrace();
					} catch (WriteException e) {
						e.printStackTrace();
					}
				} 
			}
			workbook.write();
			try {
				workbook.close();
			} catch (WriteException e) {
				System.out.println("关闭出现异常！！");
			}
			
		} catch (IOException e) {
			e.printStackTrace();
		}
		 
	}

}

package com.practice.excel;
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.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
 * 
 * 利用JExcel读取excel内容
 * @author lb
 *
 */
public class JExcelTest {
	public static void main(String []args){
		  Workbook workbook = null;
		try {
			workbook = Workbook.getWorkbook(new File("D:"+File.separator+"test.xls"));
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		  Sheet sheet[] = workbook.getSheets();
		  String lab = null;
		  for(int a=0;a<sheet.length;a++){
		   for(int i=0;i<sheet[a].getRows();i++){
		    for(int j=0;j<sheet[a].getColumns();j++){
		     lab = sheet[a].getCell(j,i).getContents();
		     System.out.print(lab+"、");
		    }
		    System.out.println();
		   	}
		  
		  }
  
		}
	
	}
	

Jexcel对读写excel非常方便，但是相对于POI来说还是逊色了些。