用POI操作Excel，出现空指针异常，怎么办 使用java读取excel的时候遇到空指针异常
poi\u64cd\u4f5cExcel\u95ee\u9898\uff0c\u4e3a\u4ec0\u4e48\u8001\u62a5\u7a7a\u6307\u9488\u5355\u5143\u683c\u7684\u8d77\u59cb\u5750\u6807\u662f(0,0),\u4e5f\u5c31\u662f\u8bf4\u7b2cx\u884c,\u7b2cx\u5217\u7684\u5355\u5143\u683c\u5750\u6807\u662f(x-1,y-1)
\u53d6\u503c\u4e4b\u524d\u8981\u5224\u65ad\u7c7b\u578b:
if (number_Cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC)
{\u2026\u2026 }
else if (number_Cell.getCellType() == XSSFCell.CELL_TYPE_STRING)
{\u2026\u2026 }
else if (number_Cell.getCellType() == XSSFCell.CELL_TYPE_FORMULA)
{\u2026\u2026 }
\u4ea7\u751f\u5f02\u5e38\u4e5f\u662f\u53ef\u80fd\u7684\uff0c\u5982\u679c\u4f60\u628acell\u7684\u5f02\u5e38\u60c5\u51b5\u63d0\u524d\u5904\u7406\u5c31\u53ef\u4ee5\u907f\u514d\u4e86\u3002\u8bd5\u8bd5\uff1aif (cell != null) {
switch (cell.getCellType()) {\uff5d\uff5d
if(cell==null){
return null;
}
String value = "";
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
Date date = cell.getDateCellValue();
if (date != null) {
value = new SimpleDateFormat("yyyy-MM-dd").format(date);
} else {
value = "";
}
} else {
value =
new DecimalFormat("0").format(cell.getNumericCellValue());
}
break;
case Cell.CELL_TYPE_FORMULA: //导入时如果为公式生成的数据则无值
// System.out.println("Formula:" + cell.getStringCellValue());
if (!cell.getStringCellValue().equals("")) {
value = cell.getStringCellValue();
} else {
value = cell.getNumericCellValue() + "";
}
break;
case Cell.CELL_TYPE_BLANK:
break;
case Cell.CELL_TYPE_ERROR:
value = "";
break;
case Cell.CELL_TYPE_BOOLEAN:
value = (cell.getBooleanCellValue() == true ? "Y" : "N");
break;
default:
value = "";
}
return value;
}
绛旓細public static String getStringCellValue(Cell cell) { if(cell==null){ return null;} String value = "";switch (cell.getCellType()) { case Cell.CELL_TYPE_STRING:value = cell.getStringCellValue();break;case Cell.CELL_TYPE_NUMERIC:if (DateUtil.isCellDateFormatted(cell)) { Date ...
绛旓細瑙ｅ喅鏂规硶锛氬彲浠ュ湪鈥減oi鈥濇搷浣溾淓xcel鈥濇椂璇诲彇鍗曞厓鏍硷紙Cell锛夛紝鍗曞厓鏍间腑鏈夊唴瀹瑰垯鍙互璇诲彇鍑哄崟鍏冩牸涓殑鍊间簡銆侾OI缂栫▼锛坖ava绋嬪簭涓緭鍑烘寚瀹氭牸寮忕殑Excel琛ㄦ牸锛夊熀纭鐭ヨ瘑濡備笅锛氬垱寤哄伐浣滅翱Workbook锛學orkbook wb = new HSSFWorkbook()锛涘垱寤哄伐浣滆〃Sheet锛歐orkbook wb = new HSSFWorkbook()锛汼heet sheet = wb.c...
绛旓細浠庢暟鎹簱璇诲嚭璁板綍鍚庡啓鍏ワ細import java.io.FileOutputStream;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import jcmh.com.bean.JdbcUtils;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.h...
绛旓細1.浣犵殑excel妯＄増鏈韩鏈夐棶棰锛屽彲浠ュ皾璇曟柊寤轰竴涓ā鐗堛2.浣犵殑excel浣跨敤浜嗕竴浜汸OI涓嶆敮鎸佺殑鍑芥暟銆傝В鍐冲姙娉:鍙﹀瓨鏄敱excel閲嶅啓浜嗗畬鏁寸殑鏂囦欢锛屽彲浠ヨВ鍐抽棶棰樸傚叧闂枃浠朵緥瀛愶細FileOutputStream os = new FileOutputStream("workbook.xls");wb.write(os);os.close();鍦ㄤ繚鎶ょ姸鎬佷笅execl鐨勬牸寮忔湁鍙兘姝ｅ湪琚娇鐢紝...
绛旓細鍥犱负鏈夌殑鍗曞厓鏍肩殑鏁版嵁绫诲瀷鏄瓧绗︿覆锛屾湁鐨勬槸鏁板瓧銆傝繖涓綘鑷繁鍒ゆ柇涓涓嬪氨濂戒簡銆傚埆鐢╰ostring锛岀敤str==null?"":str.toString()锛氳繖鏍风殑鏂瑰紡杞竴涓嬪氨濂戒簡銆傚鏋滄湁鍒殑澶勭悊閫昏緫锛岃嚜宸辨敼涓涓嬨
绛旓細浣犳槸鎬庝箞璇诲彇鐨勶紵鎴戞槸鐢℉SSFRow hssfRow = hssfSheet.getRow(rowNum);锛宺owNum浠0寮濮嬪氨鑳借鍒扮涓琛岋紝浠1寮濮嬪氨鏄绗簩琛岋紝鍥犱负澶ч儴鍒嗘椂鍊欑涓琛屾槸鏍囬锛屾墍浠ユ垜浠墠鏁呮剰鍐欎粠1寮濮嬶紙涔熷氨鏄粠绗2琛屽紑濮嬭锛夈
绛旓細public static void test() throws IOException{ FileInputStream readFile = new FileInputStream("C:\\test.xls"); //姝.xls鏂囦欢鍙湁绗4琛屾湁杈撳叆鍊 HSSFWorkbook wb = new HSSFWorkbook(readFile);HSSFSheet st = wb.getSheetAt(0);HSSFRow row0 = st.getRow(0); //excel鏂囦欢鍒涙湭寤鸿繃...
绛旓細绌虹殑CELL涓嶆槸涓嶅鐞嗭紝杩欎釜鏁版嵁鏄彃鍏ユ暟鎹簱鐨勶紝鎵浠ユ湁浜涙槸鍙互鏈┖鐨勶紝鑰屼笖杈撳叆Excel琛ㄦ暟鎹笉鏄垜杈撶殑锛屾槸瀹㈡埛杈撳叆鐨勶紝濡傛灉鐢ㄦ埛涓嶆槸瀵笶xcel寰堢啛锛岀瓑涓涓鍑虹幇绌鸿鐪嬩笂鍘绘病鏁版嵁锛屽叾瀹炵┖琛屼笂鐨凜ELL閮藉競绌哄锛宲oi涔熶細璇荤殑锛屾墍浠ユ垜鎯宠В鍐宠繖涓狟UG
绛旓細鍙兘鏄洜涓轰綘鍦ㄨ缃殑鏃跺欒緭閿欎簡鍏紡锛屾墍浠ヤ笅鎷夊氨浼氭樉绀洪敊璇殑銆傛兂瑕佽緭鍏ユ纭殑鍏紡閫夋嫨涓鍒椾綘瑕佽绠楃殑鍗曞厓鏍硷紝鍦ㄥ父鐢ㄥ伐鍏锋爮閲岀偣鈥溾垜 鈥滆繖涓鍙凤紝鍦ㄥ畠鐨勬梺杈规湁涓涓悜涓嬬殑灏忎笁瑙掞紝浣犵偣涓涓嬶紝灏卞彲浠ュ湪閲岄潰閫夋嫨浣犳兂璁＄畻鐨勬柟寮忋傛嫇灞:EXCEL鍏紡鏄疎XCEL宸ヤ綔琛ㄤ腑杩涜鏁板艰绠楃殑绛夊紡銆傚叕寮忚緭鍏ユ槸浠モ=鈥濆紑濮嬬殑...
绛旓細鎴戝鍒朵簡浣犵殑浠ｇ爜鍘昏繍琛岋紝杩愯浜嗕竴涓嬫槸鏈夋暟鎹殑,鎴戝氨鍔犱簡涓や釜try catch XSSFWorkbook xssfWorkbook=null;try { xssfWorkbook = new XSSFWorkbook("C:\\Users\\Administrator.user-THINK\\Desktop\\鍖诲褰卞儚鎶ュ憡缁熻.xlsx");} catch (IOException e) { // TODO Auto-generated catch block e.print...
