Convert each row in Excel to JSON's array element.
Get the converter file from http://goo.gl/h2nxAK
Important Note++: Due to the limitation of Excel that each formula will not be able to return more than 32,767 characters, hence the jsonArray() function I created will return #VALUE! if the output exceeded 32,767 characters. The workaround is to partially convert the ranges and combine them together in the normal text editor. Don't forget to remove extra square brackets [.
![post-title](https://i.ytimg.com/vi/qeFHOe-97fw/hqdefault.jpg?sqp=-oaymwEbCKgBEF5IVfKriqkDDggBFQAAiEIYAXABwAEG&rs=AOn4CLBWGuFUUjDUypoK8bZhuejFbMpRIw)
jsonarray 在 JSONArray 的推薦與評價
A JSONArray is an ordered sequence of values. Its external text form is a string wrapped in square brackets with commas separating the values. ... <看更多>