jxl简单创建Excel文件以及文件解析

jxl创建excel文件

用时需要下载jxl的jar包.

package com.excel.demo;

import java.io.File;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class JxlCreateExcel {
	
	/**
	 *  jxl创建Excel文件
	 */
	
	public static void main(String[] args) {
		String[] title = {"id","name","age"};
		// 创建excel文件
		File file = new File("D:/jxl_test.xls");
		try {
			// 判断文件是否已经被创建
			file.createNewFile();
			// 创作工作簿
			WritableWorkbook workbook = Workbook.createWorkbook(file);
			// 创作sheet
			WritableSheet sheet = workbook.createSheet("sheet1", 0);
			Label lable = null;
			// 第一行设置列名
			for (int i = 0; i < title.length; i++) {
				lable = new Label(i,0,title[i]);
				sheet.addCell(lable);
			}
			//追加数据
			for (int i = 1; i < 10; i++) {
				lable = new Label(0, i, "0" + i);
				sheet.addCell(lable);
				lable = new Label(1, i, "张" + i);
				sheet.addCell(lable);
				lable = new Label(2, i, "1" + i);
				sheet.addCell(lable);
			}
			
			//写入数据
			workbook.write();
			//关流
			workbook.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}

jxl解析文件

package com.excel.demo;

import java.io.File;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class JxlAnalysisExcel {
	
	/**
	 *  jxl解析Excel
	 */
	
	public static void main(String[] args) {
		try {
			// 获取工作簿
			Workbook workbook = Workbook.getWorkbook(new File("D:/jxl_test.xls"));
			// 获取第一个sheet
			Sheet sheet = workbook.getSheet(0);
			// 获取到sheet后先遍历行数据
			for (int i = 0; i < sheet.getRows(); i++) {
				// 在遍历列数据
				for (int j = 0; j < sheet.getColumns(); j++) {
					Cell cell = sheet.getCell(j,i);
					// 这里要注意为了是内容一行一行展示出来需要去掉ln
					System.out.print(cell.getContents()+"   ");
				}
				System.out.println();
			}
			workbook.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}