利用GoogleSheets自定义函数实现Ajax调用-ExecutingAjaxRequestsviaGoogleSheetsCustomFunctions

Hey guys have anyone of you ever tried to write a script inside a Google Spreadsheet to make an ajax call to a website. I want to make it so that the spreadsheet updates itself from the website. But after just putting this short block of code, I get thrown an error: "ReferenceError: "XMLHttpRequest" is not defined." Any help guys? Do I have to call a certain library?

嘿伙计们，你们中的任何人都试过在Google电子表格中写一个脚本来对网站进行ajax调用。我想这样做，以便电子表格从网站更新自己。但是在刚刚放入这么短的代码块之后，我就会抛出一个错误：“ReferenceError：”XMLHttpRequest“没有被定义。”有帮助吗？我必须打电话给某个图书馆吗？

xmlhttp=new XMLHttpRequest();
xmlhttp.open("GET", eventObject[1], true);
xmlhttp.send();

1 个解决方案