資源簡介
excel轉(zhuǎn)json的java代碼,內(nèi)有excel文件測試,有java環(huán)境可直接運(yùn)行

代碼片段和文件信息
package?com.commen.json;
import?java.io.UnsupportedEncodingException;
public?class?base64Util?{
????private?static?char[]?base64EncodeChars?=?new?char[]{
????????????‘A‘?‘B‘?‘C‘?‘D‘?‘E‘?‘F‘?‘G‘?‘H‘
????????????‘I‘?‘J‘?‘K‘?‘L‘?‘M‘?‘N‘?‘O‘?‘P‘
????????????‘Q‘?‘R‘?‘S‘?‘T‘?‘U‘?‘V‘?‘W‘?‘X‘
????????????‘Y‘?‘Z‘?‘a(chǎn)‘?‘b‘?‘c‘?‘d‘?‘e‘?‘f‘
????????????‘g‘?‘h‘?‘i‘?‘j‘?‘k‘?‘l‘?‘m‘?‘n‘
????????????‘o‘?‘p‘?‘q‘?‘r‘?‘s‘?‘t‘?‘u‘?‘v‘
????????????‘w‘?‘x‘?‘y‘?‘z‘?‘0‘?‘1‘?‘2‘?‘3‘
????????????‘4‘?‘5‘?‘6‘?‘7‘?‘8‘?‘9‘?‘+‘?‘/‘};
????private?static?byte[]?base64DecodeChars?=?new?byte[]{
????????????-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1
????????????-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1
????????????-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?-1?62?-1?-1?-1?63
????????????52?53?54?55?56?57?58?59?60?61?-1?-1?-1?-1?-1?-1
????????????-1?0?1?2?3?4?5?6?7?8?9?10?11?12?13?14
????????????15?16?17?18?19?20?21?22?23?24?25?-1?-1?-1?-1?-1
????????????-1?26?27?28?29?30?31?32?33?34?35?36?37?38?39?40
????????????41?42?43?44?45?46?47?48?49?50?51?-1?-1?-1?-1?-1};
???
????public?static?String?encode(byte[]?data)?{
????????StringBuffer?sb?=?new?StringBuffer();
????????int?len?=?data.length;
????????int?i?=?0;
????????int?b1?b2?b3;
????????while?(i?????????????b1?=?data[i++]?&?0xff;
????????????if?(i?==?len)?{
????????????????sb.append(base64EncodeChars[b1?>>>?2]);
????????????????sb.append(base64EncodeChars[(b1?&?0x3)?<4]);
????????????????sb.append(“==“);
????????????????break;
????????????}
????????????b2?=?data[i++]?&?0xff;
????????????if?(i?==?len)?{
????????????????sb.append(base64EncodeChars[b1?>>>?2]);
????????????????sb.append(base64EncodeChars[((b1?&?0x03)?<4)?|?((b2?&?0xf0)?>>>?4)]);
????????????????sb.append(base64EncodeChars[(b2?&?0x0f)?<2]);
????????????????sb.append(“=“);
????????????????break;
????????????}
????????????b3?=?data[i++]?&?0xff;
????????????sb.append(base64EncodeChars[b1?>>>?2]);
????????????sb.append(base64EncodeChars[((b1?&?0x03)?<4)?|?((b2?&?0xf0)?>>>?4)]);
????????????sb.append(base64EncodeChars[((b2?&?0x0f)?<2)?|?((b3?&?0xc0)?>>>?6)]);
????????????sb.append(base64EncodeChars[b3?&?0x3f]);
????????}
????????return?sb.toString();
????}
???
????public?static?byte[]?decode(String?str)?throws?UnsupportedEncodingException?{
????????StringBuffer?sb?=?new?StringBuffer();
????????byte[]?data?=?str.getBytes(“US-ASCII“);
????????int?len?=?data.length;
????????int?i?=?0;
????????int?b1?b2?b3?b4;
????????while?(i????????????
????????????do?{
????????????????b1?=?base64DecodeChars[data[i++]];
????????????}?while?(i?????????????if?(b1?==?-1)?break;
???????????
????????????do?{
????????????????b2?=?base64DecodeChars
????????????????????????[data[i++]];
????????????}?while?(i?????????????if?(b2?==?-1)?break;
?????
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????406??2014-08-01?16:40??Excel2Json\.classpath
?????文件????????386??2014-08-01?17:21??Excel2Json\.project
?????文件?????????57??2014-08-01?15:42??Excel2Json\.settings\org.eclipse.core.resources.prefs
?????文件????????598??2014-08-01?15:40??Excel2Json\.settings\org.eclipse.jdt.core.prefs
?????文件???????3185??2014-08-01?17:22??Excel2Json\bin\com\commen\json\ba
?????文件????????917??2014-08-01?17:22??Excel2Json\bin\com\commen\json\ba
?????文件???????2897??2014-08-01?17:26??Excel2Json\bin\com\commen\json\ExcelOperater.class
?????文件???????1239??2014-08-01?17:22??Excel2Json\bin\com\commen\json\MD5Util.class
?????文件?????180110??2014-07-29?09:01??Excel2Json\lib\gson-2.1.jar
?????文件?????720702??2014-08-01?15:58??Excel2Json\lib\jxl.jar
?????文件???????3771??2014-08-01?17:22??Excel2Json\src\com\commen\json\ba
?????文件????????381??2014-08-01?17:22??Excel2Json\src\com\commen\json\ba
?????文件???????1689??2014-08-01?17:26??Excel2Json\src\com\commen\json\ExcelOperater.java
?????文件???????1321??2014-08-01?17:22??Excel2Json\src\com\commen\json\MD5Util.java
?????文件???????7680??2014-08-01?17:28??Excel2Json\test.xls
?????目錄??????????0??2014-08-01?17:28??Excel2Json\bin\com\commen\json
?????目錄??????????0??2014-08-01?17:28??Excel2Json\src\com\commen\json
?????目錄??????????0??2014-08-01?17:28??Excel2Json\bin\com\commen
?????目錄??????????0??2014-08-01?17:28??Excel2Json\src\com\commen
?????目錄??????????0??2014-08-01?17:28??Excel2Json\bin\com
?????目錄??????????0??2014-08-01?17:28??Excel2Json\src\com
?????目錄??????????0??2014-08-01?17:28??Excel2Json\.settings
?????目錄??????????0??2014-08-01?17:28??Excel2Json\bin
?????目錄??????????0??2014-08-01?17:28??Excel2Json\lib
?????目錄??????????0??2014-08-01?17:28??Excel2Json\src
?????目錄??????????0??2014-08-01?17:28??Excel2Json
-----------?---------??----------?-----??----
???????????????925339????????????????????26
評論
共有 條評論