Dokumentationen har automatiskt översatts med maskinöversättning.
<![CDATA[
function exportJSON() {
var sheet = SpreadsheetApp.getActiveSheet();
var sheet_id = SpreadsheetApp.getActiveSpreadsheet().getUrl();
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
var numCols = rows.getNumColumns();
var values = rows.getValues();
var output = "[";
for (var i = 0; i < numRows; i++) {
if (i > 0) output += ",";
var row = values[i];
output += "{\"0\":\"true\"";
for (var a = 0; a < numCols; a++) {
var cellValue = row[a].toString()
.replace(/\"/g, """) // Замена двойных кавычек
.replace(/'/g, "'"); // Замена одинарных кавычек
output += ",\"" + (a + 1) + "\":\"" + cellValue + "\"";
}
output += "}";
}
output += "]";
var result = UrlFetchApp.fetch('https://dimaker.app/api/v1/googlesheets-create/',
{"method" : "POST", "payload" : {"sheet_id" : sheet_id, "data" : output}, "muteHttpExceptions": true});
if (result.getResponseCode() == 200) {
var json = result.getContentText();
if (json) {
data = JSON.parse(json);
Object.keys(data).forEach(key => {
sheet.getRange(key).setValue(data[key]);
});
}
}
}
]]>
Andra integrationer