src/com/util/XlsTools.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.util;

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

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

public class XlsTools {

	private Workbook readBook;
	
	private int currIndex;
	
	private ArrayList<String> alLineContent;
	
	private Cell cell;
	
	private Sheet sheet;
	
	private Label label;
	
	private int firstDataCount;
	
	private boolean isFirst;
	
	private WritableWorkbook writeBook;
	
	private WritableSheet writableSheet;
	
	/**
	 * 鍒濆鍖杧ls鏂囦欢璇诲彇鍙傛暟
	 * @param filePath
	 * @throws Exception
	 */
	public void read(String filePath) throws Exception{
		try{
			//鍒涘缓xls瀵硅薄
			readBook = Workbook.getWorkbook(new File(filePath));
			//鍙鍙栫涓?釜宸ヤ綔琛?
			sheet = readBook.getSheet(0);
			currIndex = 0;
			isFirst = true;
		}catch(Exception e){
			throw new Exception(e);
		}
	}
	
	public void read(InputStream is) throws Exception{
		try{
			//鍒涘缓xls瀵硅薄
			readBook = Workbook.getWorkbook(is);
			//鍙鍙栫涓?釜宸ヤ綔琛?
			sheet = readBook.getSheet(0);
			currIndex = 0;