通过Google Apps脚本在Google网站上显示Google Spreadsheet数据的示例 [英] Example display of Google Spreadsheet data in Google site via Google Apps Script

问题描述

我发现有些人试图通过谷歌应用程序脚本从Google电子表格中抓取数据，以便将其保存在他们的谷歌网站： 如何通过Google Apps脚本访问不同Google电子表格中的数据？

我可以甩开代码片段，但我不认为任何人都可以在任何地方找到工作示例？

$ b

解决方案

我很想找这样的东西： $ b

https://sites.google.com/site/testappscript2/

目前我认为如果您未登录Google，则无法看到任何内容，但如果您是这样的话，它可能会显示：

欢迎，不知道您的名字，但是如果您在此添加您的详细信息： https://docs.google.com/spreadsheet/ccc?key=0Aq72y9iq5_1UdG5LR0tCVTRXOVQtbkNLR1Q3eE5MR0E#gid=0
我可以告诉你你的下一个任务如果你的谷歌邮件在电子表格中，它会显示个性化的信息。

我的想法是管理学生在Google网站上看到的课程内容，具体取决于教师如何在线电子表格中更新学生数据，以便学生可以看看他们完成了哪些任务 - 他们接下来要做什么，甚至可能是他们的成绩......

I see that some people are trying to grab data from google spreadsheets via google apps script to stick in their google sites:

How to access data on different Google Spreadsheet through Google Apps Script?

I could bash away at code snippets, but I don't suppose anyone has got a working example anywhere?

Many thanks in advance

解决方案

I was looking for something like this:

https://sites.google.com/site/testappscript2/

At the moment I don't think you'll see anything if you are not logged in to Google, but if you are then it might show this:

Welcome, don't know your name, but if you add your details here: https://docs.google.com/spreadsheet/ccc?key=0Aq72y9iq5_1UdG5LR0tCVTRXOVQtbkNLR1Q3eE5MR0E#gid=0 I could tell you your next assignment

if your google mail is in the spreadsheet it will show a personalized message.

My idea is to manage what a student sees in a Google site for a course depending on how the instructor has updated the students data in an online spreadsheet, so the student can see which assignments they've completed - what they have to do next, and possibly even their grades ...

这篇关于通过Google Apps脚本在Google网站上显示Google Spreadsheet数据的示例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！