package?com.test.llp.jsonUtil;
import?java.io.File;
import?java.io.FileOutputStream;
import?java.io.OutputStream;
import?java.util.Iterator;


import?javax.swing.filechooser.FileSystemView;


import?jxl.Workbook;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;
import?net.sf.json.JSONArray;
//import?net.sf.json.JSONobject;
import?net.sf.json.JSONobject;




public?class?JsonTOExcel?{
public?static?void?main（String[]?args）?{
String?data?=?“{‘data‘:[{‘名稱‘:‘2單元抽屜左側(cè)板‘‘部件編碼‘:‘8GCS.050.1159XD‘‘柜體型號(hào)‘:‘低電壓配電柜‘‘外購/自產(chǎn)‘:‘自產(chǎn)‘‘?dāng)?shù)量‘:‘1‘‘加工時(shí)間‘:‘40‘‘所屬生產(chǎn)線‘:‘鈑金生產(chǎn)線（產(chǎn)線一）‘}{‘名稱‘:‘抽屜隔板‘‘部件編碼‘:‘ctgb‘‘柜體型號(hào)‘:‘低電壓配電柜‘‘外購/自產(chǎn)‘:‘自產(chǎn)‘‘?dāng)?shù)量‘:‘8‘‘加工時(shí)間‘:‘90‘‘所屬生產(chǎn)線‘:‘鈑金生產(chǎn)線（產(chǎn)線一）‘}{‘名稱‘:‘RC4-13二次動(dòng)插件‘‘部件編碼‘:‘RC4-13‘‘柜體型號(hào)‘:‘低電壓配電柜‘‘外購/自產(chǎn)‘:‘外購‘‘?dāng)?shù)量‘:‘1‘‘加工時(shí)間‘:‘null‘‘所屬生產(chǎn)線‘:‘鈑金生產(chǎn)線（產(chǎn)線一）‘}]}“;
print（data?“a“）;
}


public?static?void?print（String?dataString?name）{
System.out.println（data）;
JSONobject?jsonobject?=?JSONobject.fromobject（data）;
????//?將函數(shù)調(diào)用的結(jié)果返回給result
????//?保存路徑要改！！！！
FileSystemView?fsv??=?FileSystemView.getFileSystemView（）;
File?path=fsv.getHomeDirectory（）;?
String?desktoppath?=?path.getPath（）;
????JSONobject?result?=?Excel.createExcel（desktoppath+“\\“+name+“.xls“?jsonobject）;
????//?輸出結(jié)果
????System.out.println（result）;
}
}






class?Excel?{
????@SuppressWarnings（“unchecked“）
????//?創(chuàng)建excel文件函數(shù)
????//?src為待保存的文件路徑j(luò)son為待保存的json數(shù)據(jù)
????public?static?JSONobject?createExcel（String?src?JSONobject?json）?{
????????JSONobject?result?=?new?JSONobject（）;?//?用來反饋函數(shù)調(diào)用結(jié)果
????????try?{
????????????//?新建文件
????????????File?file?=?new?File（src）;
????????????file.createNewFile（）;


????????????OutputStream?outputStream?=?new?FileOutputStream（file）;//?創(chuàng)建工作薄
????????????W