java excel 数组_java 读取excel内容转为JSONArray详解

需要引入的JAR

net.sourceforge.jexcelapi

jxl

2.6.8

com.alibaba

fastjson

1.2.7

测试类

import com.alibaba.fastjson.JSONArray;

import com.alibaba.fastjson.JSONObject;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import java.io.File;

public class ExcelOperate {

public static void main(String[] args) {

Sheet sheet;

Workbook book;

Cell cell1, cell2, cell3, cell4, cell5;

JSONArray array = new JSONArray();

try {

//为要读取的excel文件名

book = Workbook.getWorkbook(new File("D://b.xls"));

//获得第一个工作表对象(ecxel中sheet的编号从0开始,0,1,2,3,....)

sheet = book.getSheet(0);

for (int i = 1; i < sheet.getRows(); i++) {

//获取每一行的单元格

cell1 = sheet.getCell(0, i);//(列，行)

cell2 = sheet.getCell(1, i);

cell3 = sheet.getCell(2, i);

cell4 = sheet.getCell(3, i);

cell5 = sheet.getCell(4, i);

if ("".equals(cell1.getContents())) {//如果读取的数据为空

break;

}

JSONObject object = new JSONObject();

object.put("ID",cell1.getContents());

object.put("编号",cell2.getContents());

object.put("姓名",cell3.getContents());

object.put("数量",cell4.getContents());

object.put("住址",cell5.getContents());

array.add(object);

}

System.out.println(array.toString());

book.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

读取的文件格式

输出：