检索Google表格中的行数 [英] Retrieve number of rows in Google Sheets
问题描述
我需要一种JavaScript方法来计算网页中的Google工作表(用作表单的响应表)中的行数.我一直在网上搜寻有关如何将Google表格制作成数据库的简单教程.
I need a JavaScript method for my webpage to count how many rows are in a Google sheet (it's used as a response sheet for a form). I've been scouring the web for easy tutorials on how to make Google Sheets into a database.
有更简单的方法吗?
我在Google脚本方面经验不足,但是我所需要的只是使用Ajax或类似的JavaScript方法对电子表格进行读取访问的方式.
I don't have much experience in Google scripts, but all I need is a way I can have read access to the spreadsheet using preferably Ajax or some similar JavaScript method.
推荐答案
要检索Google电子表格中的行数,请使用以下命令:
To retrieve the number of rows in your Google Spreadsheet use the following:
var ss = SpreadsheetApp.openById("1qNCf0wKl................");
var sheet = ss.getSheetByName("sheet_name");
var number = sheet.getMaxRows().toString();
var number = number.replace(".0","");
Logger.log(number);
为了对电子表格具有读取权限,以下链接中提供的指导已经足够好:
In order to have read access to a Spreadsheet the guidance provided in the following link is good enough:
例如,如果要在电子表格中获取所有带有单词"budget"的单元格,请使用以下脚本:
For example, if you want to get all the cells with the word «budget» in your Spreadsheet, use the following script:
var id = "1qNCf0wKlx1RF......";
var column = "A";
var query = "budget";
var url = "https://docs.google.com/spreadsheets/d/"+id+"/gviz/tq?tq=SELECT%20*%20where%20"+column+"%20contains%20%22"+query+"%22";
var text = UrlFetchApp.fetch(url).getContentText().toString();
Logger.log(text);
为此,必须先发布电子表格.检索预算"行后,必须对文本进行格式化,但这是另一个问题.
For this, the Spreadsheet has to be published previously. After retrieving the «budget» rows the text has to be formated, but that's another issue.
这篇关于检索Google表格中的行数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!