采用jxl操作读取Excle

最新推荐文章于 2020-01-15 18:00:59 发布

haloouworld

最新推荐文章于 2020-01-15 18:00:59 发布

阅读量438

点赞数

分类专栏： JAVA 文章标签： java

本文链接：https://blog.csdn.net/haloouworld/article/details/37915387

版权

JAVA 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

采用jxl操作Excle

<span style="font-family:Courier New;">package com.demo;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

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

public class PraseExcelUtil {
	/**
	 * 解析数据源
	 * @param file
	 * @return
	 * @throws Exception
	 */
	public static List<Loaction> parseExcelLoaction(File file)throws Exception{
		List<Loaction> list=new ArrayList<Loaction>();
		Cell cell=null;
		Loaction loaction=null;
		//获得文件输入流
		InputStream stream=new FileInputStream(file);
		jxl.Workbook readwb=null;
		readwb=Workbook.getWorkbook(stream);
		//获取第2张sheet表
		Sheet readSheet=readwb.getSheet(1);
		//获取包含的总列数
		int cols=readSheet.getColumns();
		//获取总行数
		int rows=readSheet.getRows();
		for(int i=1;i<rows;i++){
			loaction=new Loaction();
			for(int j=0;j<cols;j++){
				cell=readSheet.getCell(i,j);
				switch(j){
					case 0:
						loaction.setShiId(cell.getContents());
						System.out.println(cell.getContents());
						break;
					case 1:
						loaction.setShiName(cell.getContents());
						break;
					case 2:
						loaction.setShiJi(cell.getContents());
						break;
					case 3:
						loaction.setQuxianId(cell.getContents());
						break;
					case 4:
						loaction.setQuxianName(cell.getContents());
						break;
					case 5:
						loaction.setQuxianJi(cell.getContents());
						break;
					case 6:
						loaction.setXiangId(cell.getContents());
						break;
					case 7:
						loaction.setXiangName(cell.getContents());
						break;
					case 8:
						loaction.setCunId(cell.getContents());
						break;
					case 9:
						loaction.setCunName(cell.getContents());
						break;
					case 10:
						loaction.setYoubian(cell.getContents());
						break;
					case 11:
						break;
					case 12:
						break;
					case 13:
						break;
					case 14:
						break;
				}
			}
			list.add(loaction);
		}
		return list;
	}
	
}
</span></span>