package?com.gzbugu.util;

import?java.io.File;
import?java.io.IOException;
import?java.util.Set;

import?jxl.Workbook;
import?jxl.read.biff.BiffException;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;
import?jxl.write.WriteException;
import?jxl.write.biff.RowsExceededException;
import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

public?class?CreateJsonToExcel?{

	public?static?void?main（String[]?args）?throws?BiffException?IOException?RowsExceededException?WriteException?{
		
		//json數據字符串
		String?str=“[“+
		“{‘name‘:1‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:2‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:3‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:4‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:5‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:1‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:2‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:3‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:4‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:5‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:2‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:3‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:4‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:5‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:2‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:3‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:4‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“+
		“{‘name‘:5‘firstname‘:‘mo‘‘lastname‘:‘zeliang‘‘age‘:10‘addr‘:‘廣州‘}“;
		
		String?filePath=“c:\\json.xls“;
		createExcel（filePathstr）;
	}
	
	/**
	?*?生成excel文件
	?*?@param?filePath??生成的文件路徑
	?*?@param?jsonStr??json數據字符串
	?*?@throws?IOException
	?*?@throws?RowsExceededException
	?*?@throws?WriteException
	?*?@author?mzl
	?*/
	public?static?void?createExcel（String?filePathString?jsonStr）?throws?IOException?RowsExceededException?WriteException{

		//興建workbook
		WritableWorkbook?workbook=?Workbook.createWorkbook（new?File（filePath））;
		WritableSheet?sheet=workbook.createSheet（“json“?0）;
	????int?row=0;
	????
	????//把字符串轉為json數組
		JSONArray?array=JSONArray.fromobject（jsonStr）;
		//獲取json的全部key
		object?[]?keys=array.getJSONobject（0）.keySet（）.toArray（）;
		
		//把json數據的key作為excel的表頭
		for（int?i=0;i			Label?label=new?Label（irowkeys[i].toString（））;
			sheet.addCell（label）;
		}
		
		//插入內容
		for（int?i=0;i			row++;
			JSONobject?object=array.getJSONobject（i）;
			for（int?j=0;j				
				Labe

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????735??2011-04-12?15:55??ExcelToJson\.classpath

?????文件????????387??2011-04-12?15:24??ExcelToJson\.project

?????文件????????629??2011-04-12?15:24??ExcelToJson\.settings\org.eclipse.jdt.core.prefs

?????文件???????3608??2011-04-28?10:56??ExcelToJson\bin\com\gzbugu\util\CreateJsonToExcel.class

?????文件???????2244??2011-04-28?10:58??ExcelToJson\bin\com\gzbugu\util\CreatJsonData.class

?????文件?????188671??2011-04-12?15:55??ExcelToJson\jar\commons-beanutils.jar

?????文件?????559366??2011-04-12?15:54??ExcelToJson\jar\commons-collections-3.1.jar

?????文件?????245274??2011-04-12?15:52??ExcelToJson\jar\commons-lang-2.3.jar

?????文件??????38015??2011-04-12?15:53??ExcelToJson\jar\commons-logging.jar

?????文件??????86381??2011-04-12?15:54??ExcelToJson\jar\ezmorph-1.0.4.jar

?????文件?????140060??2011-04-12?15:41??ExcelToJson\jar\json-lib-2.2.1-jdk15.jar

?????文件?????720702??2011-04-12?15:28??ExcelToJson\jar\jxl.jar

?????文件???????3363??2011-04-28?10:56??ExcelToJson\src\com\gzbugu\util\CreateJsonToExcel.java

?????文件???????1756??2011-04-28?10:58??ExcelToJson\src\com\gzbugu\util\CreatJsonData.java

?????目錄??????????0??2011-04-28?10:59??ExcelToJson\bin\com\gzbugu\util

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\src\com\gzbugu\util

?????目錄??????????0??2011-04-28?10:59??ExcelToJson\bin\com\gzbugu

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\src\com\gzbugu

?????目錄??????????0??2011-04-28?10:59??ExcelToJson\bin\com

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\src\com

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\.settings

?????目錄??????????0??2011-04-28?10:59??ExcelToJson\bin

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\jar

?????目錄??????????0??2011-04-28?11:00??ExcelToJson\src

?????目錄??????????0??2011-04-28?11:00??ExcelToJson

-----------?---------??----------?-----??----

??????????????1991191????????????????????25