从GoogleSheets生成的文件中提取数据

时间:2022-01-02 01:20:41

I have created the following data file and using JavaScript code calling a google spreadsheet. I am lost on how to get the information that is stored within this file and use it as values with my JavaScript code.

我创建了以下数据文件,并使用调用谷歌电子表格的JavaScript代码。我迷失在如何获取存储在此文件中的信息并将其用作我的JavaScript代码的值。

The file I am trying to get values from is below: https://spreadsheets.google.com/feeds/cells/1ayp5hzHWVk_Gj9-lhzNULOrMof2BVFk3PlAmCtyfeKw/od6/public/values?alt=json-in-script&callback=sheet

我试图从中获取值的文件如下:https://spreadsheets.google.com/feeds/cells/1ayp5hzHWVk_Gj9-lhzNULOrMof2BVFk3PlAmCtyfeKw/od6/public/values?alt=json-in-script&callback=sheet

My issue is that I have no idea how to take any of the information from this file and the entire thing looks like gibberish to me because of my limited coding experience. Any help and explanation of how to go about this would be greatly appreciated.

我的问题是我不知道如何从这个文件中获取任何信息,因为我有限的编码经验,整个事情看起来像是胡言乱语。如何解决这个问题的任何帮助和解释将不胜感激。

1 个解决方案

#1


0  

You shouldn't do this manually, there are libraries that lets you fetch information from google spreadsheets. Check out this for starters: https://developers.google.com/apps-script/guides/sheets

您不应手动执行此操作,有些库可让您从Google电子表格中获取信息。请查看以下内容:https://developers.google.com/apps-script/guides/sheets

#1


0  

You shouldn't do this manually, there are libraries that lets you fetch information from google spreadsheets. Check out this for starters: https://developers.google.com/apps-script/guides/sheets

您不应手动执行此操作,有些库可让您从Google电子表格中获取信息。请查看以下内容:https://developers.google.com/apps-script/guides/sheets