poi怎样判断cell值是int还是double? Poi判断单元格的数据类型问题
java \u8bfb\u53d6excel \u5224\u65ad\u662fint\u7c7b\u578b\u8fd8\u662fdouble\u7c7b\u578b\u5148\u53d8\u6210String\uff0c\u770b\u770b\u5b57\u7b26\u4e32\u4e2d\u6709\u6728\u6709\u201c.\u201d int tag = str.indexof("."),
tag>0\u5c31\u4e0d\u662fint
if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC){
String form = cell.getCellStyle().getDataFormatString();
DecimalFormat format = new DecimalFormat(form);
format.format(cell.getNumericCellValue());
}
switch (cType) {
case Cell.CELL_TYPE_NUMERIC://数值处理
break;
}
if(cell.getCellType()==Cell.CELL_TYPE_NUMERIC){
int
}else{
double
}
绛旓細棣栧厛鍒ゆ柇鏄涓嶆槸鍏紡,濡傛灉鏄缃叾鍗曞厓鏍肩被鍨嬩负鏁板瓧,鐒跺悗鑾峰彇鍊煎氨鍙互寰楀埌 case HSSFCell.CELL_TYPE_FORMULA: //棣栧厛鍒ゆ柇涓涓嬫槸涓嶆槸鍏紡 cell.setCellType(Cell.CELL_TYPE_NUMERIC); //璁剧疆鍏跺崟鍏冩牸绫诲瀷涓烘暟瀛 result = cell.getNumericCellValue(); //鑾峰彇鏁板瓧鍊 break;...
绛旓細//浣犵幇鍦ㄥ彇鍑烘潵鐨勬槸Excel鍗曞厓鏍煎璞★紒姝ｇ‘鍋氭硶濡備笅锛 /** * * 鑾峰彇鍗曞厓鏍兼暟鎹唴瀹逛负瀛楃涓茬被鍨嬬殑鏁版嵁 * TODO * @param cell Excel鍗曞厓鏍 * @returnString 鍗曞厓鏍兼暟鎹唴瀹 */ private String getStringCellValue(HSSFCell cell) { String cellValue = ""; DecimalFo...
绛旓細鏃ユ湡鍙互鐩存帴鎸夊瓧绗︿覆澶勭悊锛屽鏋滆繖涓棩鏈熼渶瑕佸拰鍏跺畠cell杩涜浜掑姩锛岄偅灏辫浣跨敤鍏紡鍨嬨11.64%涔熸槸瀛楃涓层侲xcel铏界劧鎻愪緵浜嗗ぇ閲忕殑鐢ㄦ埛鐣岄潰鐗规э紝浣嗗畠浠嶇劧淇濈暀浜嗙涓娆剧數瀛愬埗琛ㄨ蒋浠禫isiCalc鐨勭壒鎬э細琛屻佸垪缁勬垚鍗曞厓鏍硷紝鏁版嵁銆佷笌鏁版嵁鐩稿叧鐨勫叕寮忔垨鑰呭鍏朵粬鍗曞厓鏍肩殑缁濆寮曠敤淇濆瓨鍦ㄥ崟鍏冩牸涓備唬鐮:Workbook excelWB = ...
绛旓細姝ゆ枃姒傝鎬х殑璁茶堪浜嗕竴涓嬪崟鍏冩牸鐨勮竟妗嗐佸瓧浣撲互鍙婇鑹茬殑璁剧疆鏂瑰紡,鍦POI涓,杩欎竴鍒囬兘鏄氳繃瀹炰緥鍖朒SSFCellStyle瀵硅薄鏉ュ疄鐜扮殑,HSSFCellStyle绫昏繕鏈夊緢澶氬叾浠栧疄闄呮湁鐢ㄦ柟娉,鏈緥涓彧鏄彇骞虫椂鐢ㄧ殑姣旇緝鏅亶鐨勪竴浜涜缃潵鍋氭紨绀虹殑銆傚ソ,寮濮嬭瑙ｄ簡鈥︹ // 璁剧疆琛屽彿row.setHeightInPoints((short) 50);// 璁剧疆鍒楀,(256 * ...
绛旓細System.out.println("绗"+(rowIndex+1)+"琛岋紝绗"+(cellnull+1)+"鍒楋紝cellType涓猴細CELL_TYPE_BLANK");}else if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING){ name =String.valueOf(cell.getRichStringCellValue());// getNumericCellValue()浼氬洖浼燿ouble鍊硷紝鑻ヤ笉甯屾湜鍑虹幇灏忔暟鐐癸紝璇...
绛旓細鐢ㄧ殑POI鍚э紝浣犵殑鍒ゆ柇鏉′欢鏈夐棶棰樺惂 if (cell== null &&cell.equals(" ")&& cell.getCellType() == Cell.CELL_TYPE_BLANK)杩欓噷鍙鏈変竴涓弧瓒冲氨鍙互return false浜嗗惂 if (cell== null || cell.equals(" ") || cell.getCellType() == Cell.CELL_TYPE_BLANK)鏄笉鏄杩欐牱鍒ゆ柇鍛 ...
绛旓細璨屼技娌℃湁鏁磋鍒ょ┖鐨勬柟娉曞惂銆傚彲浠ヨ繖涔堝仛锛氫粠浣犺璇诲彇鐨勯偅涓琛岀殑绗竴涓cell寮濮嬶紝鐩村埌瑕佺粨鏉鍒ゆ柇鐨刢ell缁撴灉銆傛瘡鍙栦竴娆″硷紝鍒ゆ柇涓娆★紝闈炵┖鍗砨reak锛岀┖鍒欑户缁紝鐩磋嚦寰幆缁撴潫銆
绛旓細鏍规嵁鍐呭鍒ゆ柇锛屾垜娌℃湁鐢ㄨ繃锛屼篃娌℃湁瑙佸埌杩囪繖涓柟娉曘備笉杩囨湁涓ょ鍔炴硶锛1.寰幆涓琛屼腑鐨cell锛屾嬁鍒鍊间负"Name"鐨勶紝灏辫鍙栦笅涓涓猚ell鐨勫 2.鎴戞兂锛屼綘鐨"Li Men" 杩欎釜cell鑲畾鍦ㄥ悓涓涓垪鍚э紝浣犲彲浠ヨ鍙栨寚瀹氱储寮昪ell鐨勫 鏈夊叾浠栭棶棰橈紝灏辫拷鍔
绛旓細鏄寚璁＄畻鍏紡浠ュ強璁＄畻缁撴灉銆傜鍒拌鍙栧叕寮忕被鍨嬬殑鍗曞厓鏍艰涓嶅嚭鏉,璇曚簡HXSSFWorkbook涔熻涓嶅嚭鏉ワ紝鍚庢潵璇曚簡涓媂SSFCell.getCTCell().getV() 灏辫鍑烘潵浜嗐備絾鏈変釜闂灏辨槸XSSFCell.getCTCell().getV() 鏄噸鏂拌绠椾竴閬嶇殑锛屽鏋滃崟鍏冩牸鐨鍊兼槸鍙﹀鍑犱釜鍗曞厓鏍肩殑澶嶆暟鍊艰绠楃殑锛屽崟鍏冨煎彲鑳戒細鍑虹幇111.000000000001 ...
绛旓細鍥犱负鏈夌殑鍗曞厓鏍肩殑鏁版嵁绫诲瀷鏄瓧绗︿覆锛屾湁鐨勬槸鏁板瓧銆傝繖涓綘鑷繁鍒ゆ柇涓涓嬪氨濂戒簡銆傚埆鐢╰ostring锛岀敤str==null?"":str.toString()锛氳繖鏍风殑鏂瑰紡杞竴涓嬪氨濂戒簡銆傚鏋滄湁鍒殑澶勭悊閫昏緫锛岃嚜宸辨敼涓涓嬨
