/**
* 根据上传的File对象解析xls文件中的内容,返回xls文件的内容数组
*
* @param file 要解稀的Excel文件
* @return String[l] xls文件每行数据 l = String[] xls文件每列数据
*
*/
public String[] readExcel(File file) {
logDebug("in ProposalFormManageAction.readExcel(File file)");
String[] phones = null;
try {
HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
HSSFSheet sheet = wb.getSheetAt(0);
int lastrow = sheet.getLastRowNum() + 1;
phones = new String[lastrow];
logDebug("所有的行数:" + lastrow);
HSSFRow row = null;
for (int i = 0; i < lastrow; i++) {
row = sheet.getRow(i);
String[] rows = null;
if (null != row) {
rows = getExcelData(row);
}
if (null != rows) {
phones[i] = rows;
} else {
phones[i] = "";
}
}
logDebug("查询EXCEL文件结束!");
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载