学习java读取excel文件

读取excel文件代码如下：（原文链接https://www.cnblogs.com/gmq/archive/0001/01/01/1521496.html）

使用poi.jar读取，但发现若第一列为空，则本行无法读取

package com.spd.excelDemo;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ImportExcelDemo {

public static void main(String[] args) throws IOException {
	// TODO Auto-generated method stub
       File file = new File("D://1.xls");
       String[][] result = getData(file, 1);
       int rowLength = result.length;
       for(int i=0;i<rowLength;i++) {
           for(int j=0;j<result[i].length;j++) {
              System.out.print(result[i][j]+"\t\t");
           }
           System.out.println();
       }
}
/**
 * 获取xls文件内容并以String[][]返回
 * @param file
 * @param ingoreRows
 * @return String[][]
 * @throws IOException
 */
public static String[][] getData(File file,int ingoreRows) throws IOException{
	List<String[]> result = new ArrayList<String[]>();
	int rowSize = 0;
	BufferedInputStream in = new BufferedInputStream(new FileInputStream(file));
	//打开HSSFWorkbook
	POIFSFileSystem poifsFileSystem = new POIFSFileSystem(in);
	//
	HSSFWorkbook wb = new HSSFWorkbook(poifsFileSystem);
	HSSFCell cell = null;
	//遍历表单
	for(int sheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++ ) {
		//获取当前表单
		HSSFSheet hssfSheet = wb.getSheetAt(sheetIndex);
		//遍历行
		for(int rowIndex = 0; rowIndex <= hssfSheet.getLastRowNum(); rowIndex++ ) {
			HSSFRow hssfRow = hssfSheet.getRow(rowIndex);
			//如果hssfRow为空，遍历下一行
			if(null == hssfRow) {
				continue;
			}
			int tempRowSize = hssfRow.getLastCellNum() + 1;
			if(tempRowSize > rowSize) {
				rowSize = tempRowSize;
			}
			//创建字符串数组存储数据
			String[] values = new String[rowSize];
			//全部存空数据
			Arrays.fill(values, "");
			//定义标识符为false
			boolean hasValue = false;
			//遍历存储数据
			for(short columnIndex = 0; columnIndex <= hssfRow.getLastCellNum(); columnIndex++ ) {
				String value = "";
				cell = hssfRow.getCell(columnIndex);
				if(null != cell) {
					//设置编码格式，防止乱码
					cell.setEncoding(HSSFCell.ENCODING_UTF_16);
					switch(cell.getCellType()) {
					//字符串类型
					case HSSFCell.CELL_TYPE_STRING:
						value = cell.getStringCellValue();
						break;
					//数字类
						
					case HSSFCell.CELL_TYPE_NUMERIC:
						//判断是否是日期格式
						if(HSSFDateUtil.isCellDateFormatted(cell)) {
							Date date = cell.getDateCellValue();
							if(null != date) {
								value = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);
							}else {
								value = "";
							}
							//非日期格式
						}else {
							value = new DecimalFormat("0").format(cell.getNumericCellValue());
						}
						break;
					case HSSFCell.CELL_TYPE_FORMULA:
						if(!cell.getStringCellValue().equals("")) {
							value = cell.getStringCellValue();
						}else {
							value = cell.getNumericCellValue() + "";
						}
						break;
					case HSSFCell.CELL_TYPE_BLANK:
						break;
					case HSSFCell.CELL_TYPE_ERROR:
						value = "";
						break;
					case HSSFCell.CELL_TYPE_BOOLEAN:
						value = (cell.getBooleanCellValue() == true ? "Y" : "N");
						break;
					default:
						value = "";
					}
				}
				if(columnIndex == 0 && value.trim().equals("")) {
					break;
				}
				values[columnIndex] = rightTrim(value);
				hasValue = true;
			}
			if(hasValue) {
				result.add(values);
			}
		}
		
	}
	in.close();
	String[][] returnArray = new String[result.size()][rowSize];
	for(int i = 0; i < returnArray.length; i++ ) {
		returnArray[i] = (String[])result.get(i);
	}
	return returnArray;
	
}
/**
 * 去掉字符串右边的空格
 * @param Str 要处理的字符串
 * @return 处理后的字符串
 */
private static String rightTrim(String str) {
	// TODO Auto-generated method stub
	if(null == str) 
		return "";
	int length = str.length();
	for(int i = length - 1; i >= 0; i-- ) {
		if(str.charAt(i) != 0x20) {
			break;
		}
		length--;
	}
	return str.substring(0,length);
}

}