请尝试：
function getJsonArrayFromData(data){ var obj = {}; var result = []; var headers = data[0]; var cols = headers.length; var row = []; for (var i = 1, l = data.length; i < l; i++) { // get a row to fill the object row = data[i]; // clear object obj = {}; for (var col = 0; col < cols; col++) { // fill object with new values obj[headers[col]] = row[col]; } // add object in a final result result.push(obj); } return result;}测试功能：
function test_getJsonArrayFromData(){ var data = [ ['Planet', 'Mainland', 'Country', 'City'], ['Earth', 'Europe', 'Britain', 'London'], ['Earth', 'Europe', 'Britain', 'Manchester'], ['Earth', 'Europe', 'Britain', 'Liverpool'], ['Earth', 'Europe', 'France', 'Paris'], ['Earth', 'Europe', 'France', 'Lion'] ]; Logger.log(getJsonArrayFromData(data)); // => [{Mainland=Europe, Country=Britain, Planet=Earth, City=London}, {Mainland=Europe, Country=Britain, Planet=Earth, City=Manchester}, {Mainland=Europe, Country=Britain, Planet=Earth, City=Liverpool}, {Mainland=Europe, Country=France, Planet=Earth, City=Paris}, {Mainland=Europe, Country=France, Planet=Earth, City=Lion}]}
