问题描述:

I've about 400 cells, that're using my script. Script is working, but i can only call it 20 000 times/day due to google regulations. I've been trying to use this function:

function readXml2(url) {

var parameters = {method : "get", payload : ""};

var xmlFeed = UrlFetchApp.fetch(url, parameters).getContentText();

return XmlService.parse(xmlFeed);

}

to put xml data to cell and then just use this same data for these 400 cells instead of calling it in every cell(it's this same url). But i guess, that it tries to convert document to string format so it doesn't work. Is there any way to put that data into cell 1 and just refresh this one cell to refresh all the data, or do something similar to that?

相关阅读:
Top