使用jxl 实现对Excel的导入与导出

package com.lin;

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

import jxl.Cell;
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;
/**
 * @description java 实现Excel表格的导入与导出 </br>
 * 使用jxl.jar
 * @author ljh
 */
public class JavaExcelDemo {

	public static void main(String[] args) throws RowsExceededException, WriteException {
		//exportExcel();
		try {
			importExcel();
		} catch (Exception e) {
			
			e.printStackTrace();
		} 
	}
    /**
     * Exel 的导出
     * @throws WriteException
     * @throws RowsExceededException
     */
	private static void exportExcel() throws WriteException, RowsExceededException {
		File file=new File("e:/jxl_text.xls");
		String[] title={"id号","姓名","性别"};//注意：如果有中文会出现乱码，也会有显示不出来的情况
		
		try {
			file.createNewFile();
			//创建一个可写工作簿
			
			/*WorkbookSettings workbookSettings = new WorkbookSettings();
            workbookSettings.setEncoding("ISO-8859-1");*/
			WritableWorkbook workbook=Workbook.createWorkbook(file);
           // WritableWorkbook workbook =Workbook.createWorkbook(file, workbookSettings);
			//创建一个可写sheet页
			WritableSheet sheet=workbook.createSheet("第一个sheet1", 0);
			Label label=null;
			//第一行，设置列名
			for (int i = 0; i < title.length; i++) {
				//第几列第几行，值
				label=new Label(i, 0, title[i]);
				sheet.addCell(label);
			}
			//追加10行数据
			//注意：如果有中文会出现乱码，也会有显示不出来的情况
			for (int i = 1; i <=10; i++) {
				
				label=new Label(0, i, i+"");
				sheet.addCell(label);
				
				label=new Label(1, i, "张三"+i);
				sheet.addCell(label);
				if(i%2==0){
					label=new Label(2, i, "男");
					sheet.addCell(label);
				}else{
					label=new Label(2, i, "女");
					sheet.addCell(label);
				}
				
			}
			//写入数据
			workbook.write();
			//关闭数据
			workbook.close();
			
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	/**
	 * @description Excel 的导入
	 * @throws BiffException
	 * @throws IOException
	 */
	private static void importExcel() throws BiffException, IOException{
		//获取工作簿
		Workbook workbook=Workbook.getWorkbook(new File("e:/jxl_text.xls"));
		//获取第一个sheet页
		Sheet sheet=workbook.getSheet(0);
		//获取数据
		for (int i = 0; i < sheet.getRows(); i++) {
			for (int j = 0; j < sheet.getColumns(); j++) {
				Cell cell=sheet.getCell(j,i);
				System.out.print(cell.getContents()+"\t");
			}
			System.out.println();
		}
		workbook.close();
	}

}