{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["convert to json"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"convert to json","index":0,"n_rows":11,"n_cols":6,"rows_kept":11}
["Convert each row in Excel into an element of JSON array"]
["Copyright 2013. Prasert Kanawattanachai (bluecotton.k@gmail.com)"]
[]
["usage:","=jsonArray(column_header_range, data_range)"]
[null,"=jsonArray(C8:F8,C9:F11)",null,"---->",{"$f":"jsonarray(C8:F8,C9:F11)","v":"[{\"Fruit\":\"apple\",\"Price\":1.5,\"IsOnSale\":true,\"ExpireDate\":\"2013-07-08T00:00:00Z\"},{\"Fruit\":\"banana\",\"Price\":2,\"IsOnSale\":false,\"ExpireDate\":\"2013-04-05T00:00:00Z\"},{\"Fruit\":\"kiwi\",\"Price\":1.8,\"IsOnSale\":true,\"ExpireDate\":\"2013-09-10T00:00:00Z\"}]"}]
[{"$nulls":4},"just copy the result to any text editor and save as a JSON file, or visit http://jsonformat.com/ to pretty format JSON"]
[]
["Column header ->",null,"Fruit","Price","IsOnSale","ExpireDate"]
[null,null,"apple",1.5,true,"2013-07-08"]
[null,null,"banana",2,false,"2013-04-05"]
[null,null,"kiwi",1.8,true,"2013-09-10"]