poi使用大全.doc

poi使用大全 POI浣跨敤 2010-11-30 11:18:00| 鍒嗙被锛?Java |瀛楀彿 璁㈤槄 绗竴璁?锛氬熀鏈殑Excel璇诲啓 鏈枃涓昏婕旂ず涓€涓婸OI鐨勫熀鏈搷浣滐紝渚嬪鎬庢牱璇诲彇鍜屽垱寤轰竴涓叿浣撶殑Excel鏂囦欢銆傛寜鐓ф儻渚嬶紝鎷縃elloWorld璇翠簨鍎裤€? 璇存槑锛氭湰鏂囦富瑕佸唴瀹圭殕鍖呭惈浜庡畼鏂瑰府鍔╂墜鍐岋紝涔嬫墍浠ヨ鎷垮嚭鏉ワ紝鍑轰簬涓や釜鍘熷洜锛屾墜鍐屾槸鑻辨枃鐨?鎵嬪唽鏄搴?.5.1鐨勩€? 鏍稿績浠ｇ爜濡備笅锛屾敞閲婇儴鍒嗕负璁茶В銆?杩欓噷鍙寫骞茬殑璁诧紝瀹屾暣鐨勪唬鐮佽鍙傝€?涓嬭浇浠ｇ爜)銆? //鍒涘缓涓€涓┖鐧界殑WorkBook HSSFWorkbook wb = new HSSFWorkbook(); //鍩轰簬涓婇潰鐨刉orkBook鍒涘缓灞炰簬姝orkBook鐨凷heet锛? //3.0.1鐗堝湪浣跨敤鍏ㄨSheet鍚嶇殑鏃跺€欎笉蹇呭啀setEncdoing浜嗭紝涓汉鎰熻鏂逛究浜嗚澶氥€? HSSFSheet st = wb.createSheet(娴嬭瘯椤?); //鍒涘缓灞炰簬涓婇潰Sheet鐨凴ow锛屽弬鏁?鍙互鏄?锝?5535涔嬮棿鐨勪换浣曚竴涓紝 //娉ㄦ剰锛屽敖绠″弬鏁版槸Int绫诲瀷锛屼絾鏄疎xcel鏈€澶氭敮鎸?5536琛? HSSFRow row = st.createRow(0); //鍒涘缓灞炰簬涓婇潰Row鐨凜ell锛屽弬鏁?鍙互鏄?锝?55涔嬮棿鐨勪换浣曚竴涓紝 //鍚屾牱锛屾槸鍥犱负Excel鏈€澶ф敮鎸佺殑鍒楁暟涓?56鍒? HSSFCell cell = row.createCell((short) 0); //璁剧疆姝ゅ崟鍏冩牸鐨勬牸寮忎负鏂囨湰锛屾鍙ュ彲浠ョ渷鐣ワ紝Excel浼氳嚜鍔ㄨ瘑鍒€? //鍏朵粬杩樻湁鍑犵甯哥敤鐨勬牸寮忥紝璇峰弬鑰冩湰鏂囧簳閮ㄧ殑琛ュ厖閮ㄥ垎銆? cell.setCellType(HSSFCell.CELL_TYPE_STRING); //姝ゅ鏄?.0.1鐗堢殑鏀硅繘涔嬪锛屼笂涓€鐗堝彲浠ョ洿鎺etCellValue(Hello, World!)锛? //浣嗘槸鍦?.0.1閲岋紝琚玠eprecated浜嗐€? cell.setCellValue(new HSSFRichTextString(Hello, World!)); //鍒涘缓涓€涓枃浠惰緭鍑烘祦锛屾寚瀹氬埌C鐩樻牴鐩綍涓嬶紙C鐩橀兘鏈夊惂锛燂級 //xls鏄疎xcel97-2003鐨勬爣鍑嗘墿灞曞悕锛?007鏄痻lsx锛岀洰鍓嶇殑POI鑳界洿鎺ョ敓浜х殑杩樻槸xls鏍煎紡锛? //濡傛灉姝ゅ鎶婃墿灞曞悕鏀规垚xlsx锛屽湪鐢‥xcel2007鎵撳紑姝ゆ枃浠舵椂浼氭姤閿欍€? FileOutputStream writeFile = new FileOutputStream(c:/helloworld.xls); //鎶奧orkBook鍐欏埌娴侀噷 wb.write(writeFile); //璁板緱鎵嬪姩鍏抽棴娴侊紝瀹樻柟鏂囨。宸茬粡鍋氫簡鐗瑰埆璇存槑锛岃POI涓嶈礋璐ｅ叧闂敤鎴锋墦寮€鐨勬祦銆傛墍浠?.. writeFile.close(); 涓婇潰灏辨槸鍒涘缓涓€涓柊鏂囨。鐨勭畝鏄撲唬鐮侊紝涓嬮潰鐨勪緥瀛愭槸璇诲彇鍒氭墠鍒涘缓鐨凟xcel骞舵妸璇诲彇鍒扮殑鍐呭鏄剧ず鍦ㄦ帶鍒跺彴涓娿€? //鎸囧畾瑕佽鍙栫殑鏂囦欢锛屾湰渚嬩娇鐢ㄤ笂闈㈢敓鎴愮殑helloworld.xls FileInputStream readFile = new FileInputStream(c:/helloworld.xls); //鍒涘缓涓€涓猈orkBook锛屼粠鎸囧畾鐨勬枃浠舵祦涓垱寤猴紝鍗充笂闈㈡寚瀹氫簡鐨勬枃浠舵祦 HSSFWorkbook wb = new HSSFWorkbook(readFile); //鑾峰彇鍚嶇О涓衡€滄祴璇曢〉鈥濈殑sheet //娉ㄦ剰锛屽鏋滀笉鑳界‘瀹氬叿浣撶殑鍚嶇О锛屽彲浠ョ敤getSheetAt(int)鏂规硶鍙栧緱Sheet HSSFSheet st = wb.getSheet(娴嬭瘯椤?); //鑾峰緱绗竴琛岋紝鍚屼笂锛屽鏋滄琛屾病鏈夎鍒涘缓杩囧垯鎶涘嚭寮傚父 HSSFRow row = st.getRow(0); //鑾峰彇绗竴涓崟鍏冩牸锛屽鏋滄病鏈夎鍒涘缓杩囧垯鎶涘嚭寮傚父 HSSFCell cell = row.getCell((short) 0); //鎶奵ell涓殑鍐呭鎸夊瓧绗︿覆鏂瑰紡璇诲彇鍑烘潵锛屽苟鏄剧ず鍦ㄦ帶鍒跺彴涓? //娉ㄦ剰锛実etRichStringCellValue()鏂规硶鏄?