Ⅰ 濡備綍瑙ｅ喅C#涓婁紶SFTP 鎶涘紓甯 Tamir.SharpSsh.jsch.SftpException
鍙傝冿細
http://stackoverflow.com/questions/25178410/upload-to-ftp-server-c-sharp-using-tamir-sharpssh
Ⅱ java璇誨彇excel鏃墮棿鏍煎紡鍑虹幇鏁板瓧鎬庝箞澶勭悊錛
鍦‥xcel涓鐨勬棩鏈熸牸寮,姣斿2009-12-24灝嗗叾杞鍖栦負鏁板瓧鏍煎紡鏃跺彉鎴愪簡40171錛屽湪鐢╦ava澶勭悊鐨勬椂鍊欙紝璇誨彇鐨勪篃灝嗘槸40171銆傚傛灉浣跨敤POI澶勭悊Excel涓鐨勬棩鏈熺被鍨嬬殑鍗曞厓鏍兼椂錛屽傛灉浠呬粎鏄鍒ゆ柇瀹冩槸鍚︿負鏃ユ湡綾誨瀷鐨勮瘽錛屾渶緇堜細浠NUMERIC綾誨瀷鏉ュ勭悊銆
姝ｇ『鐨勫勭悊鏂規硶鏄鍏堝垽鏂鍗曞厓鏍肩殑綾誨瀷鏄鍚﹀垯NUMERIC綾誨瀷錛岀劧鍚庡啀鍒ゆ柇鍗曞厓鏍兼槸鍚︿負鏃ユ湡鏍煎紡錛屽傛灉鏄鐨勮瘽錛屽壋寤轟竴涓鏃ユ湡鏍煎紡錛屽啀灝嗗崟鍏冩牸鐨勫唴瀹逛互榪欎釜鏃ユ湡鏍煎紡鏄劇ず鍑烘潵銆傚傛灉鍗曞厓鏍間笉鏄鏃ユ湡鏍煎紡錛岄偅涔堝垯鐩存帴寰楀埌NUMERIC鐨勫煎氨琛屼簡銆
鍏蜂綋浠ｇ爜濡備笅錛
涓昏佹槸鍒ゆ柇NUMERIC 鐨勬椂鍊 鍚屼簨鍒ゆ柇涓 鍗曞厓鏍兼槸涓嶆槸鏃ユ湡鏍煎紡 濡傛灉鏄 鏃ユ湡鏍煎紡鐩存帴 杞鎴愭棩鏈熸牸寮忓瓧絎︿覆榪斿洖鍊煎氨ok浜嗐
if(0==cell.getCellType()){ //鍒ゆ柇鏄鍚︿負鏃ユ湡綾誨瀷 if(HSSFDateUtil.isCellDateFormatted(cell)){ //鐢ㄤ簬杞鍖栦負鏃ユ湡鏍煎紡Dated=cell.getDateCellValue(); DateFormatformater=newSimpleDateFormat("yyyy-MM-ddHH:mm:ss"); str[k]=formater.format(d);}else{ //鐢ㄤ簬鏍煎紡鍖栨暟瀛楋紝鍙淇濈暀鏁板瓧鐨勬暣鏁伴儴鍒 DecimalFormatdf=newDecimalFormat("########"); str[k]=df.format(cell.getNumericCellValue()); }