html - 仅在嵌入的 Google Spread 中显示特定工作表

Question

我可以在 html 网页中嵌入特定工作表而不是整个电子表格吗？

<iframe height="500" src="https://docs.google.com/spreadsheets/d/<key>/edit?usp=sharing" width="100%"></iframe>

Answer 1

一些有用的信息 from documentation将帮助:

To publish a file:

1. Open a document, spreadsheet, presentation, or drawing.
2. Click the File menu.
3. Select Publish to the Web.
4. While the entire file will be published, some file types have more publishing options: Spreadsheet: Choose to publish the entire spreadsheet or individual sheets. You can also choose a publishing format (web page, .csv, .tsv, .pdf, .xlsx, .ods).
5. Click Publish.
6. Copy the URL and send it to anyone you’d like to see the file. Or, embed it into your website.

如果您在第 4 步选择嵌入，

你会得到这个代码:

<iframe src="https://docs.google.com/spreadsheets/d/1S14JwcYCN30VlFG0ZsBS0kHOT1_AkGxV_HydQ5-UFcI/pubhtml?gid=0&amp;single=true&amp;widget=true&amp;headers=false"></iframe></div>