[wordpress插件] Dan's GSheets Data Embedder丹的GSheets数据嵌入器

Dan's Google Sheets Data Embedder was created out of a need for non-technical users to move complex calculations outside WordPress and into a more familiar spreadsheet environment, as well as the ability to share just the pieces of information needed from a spreadsheet rather

Dan的Google Sheets Data Embedder的创建是出于非技术用户将复杂的计算移至WordPress之外并转移到更熟悉的电子表格环境中的能力，以及能够仅共享电子表格中所需信息的能力

than sharing the entire document.

而不是共享整个文档。

Dan’s GSheets allows you to embed the values for either an individual cell, or for ranges directly via shortcode.

Dan的GSheets允许您直接通过短代码嵌入单个单元格或范围的值。

No need to import data or manage it directly in WordPress.

无需在WordPress中直接导入或管理数据。

All you need is a public Google Sheets Document (or multiple!) and a free, easy to get API key.

您需要的只是一个公开的Google表格文档（或多个！）和免费的易于获取的API密钥。

Suggested Uses

建议用途

• Offload all of your complex calculations to Google Sheets!

  将您所有复杂的计算量卸载到Google表格中！

  Take data from Google forms, or wherever else you wish, and just display the results

  从Google表单或其他任何地方获取数据，然后仅显示结果

• Have a non-techinical client or user that needs to be able to update a specific message?

  是否有需要更新特定消息的非技术客户或用户？

  Just map that spot to a Google Sheets Cell via shortcode, and share that document with them with edit abilities

  只需通过简码将该点映射到Google表格单元格，然后使用编辑功能与他们共享该文档

• Create a nice front end in WordPress, and update live scores via Google Sheets as a spreadsheet

  在WordPress中创建一个不错的前端，并通过电子表格通过Google表格更新实时得分

• Did you come up with something else?

  您还有其他建议吗？

  We’d love to hear about it!

  我们很想听听！

  Share in your review or via a message on my site.

  分享您的评论或通过我的网站上的消息。

Features

功能

• Displays public Google Sheet Document data in an easy-to-format view

  以易于格式化的视图显示公共Google表格文档数据

• Live updates on page load.

  页面加载时实时更新。

  Just change your data in your sheet, and it’s live on site!

  只需更改工作表中的数据，它就可以在网站上显示！

• Displays cells or ranges of cells from any public Google Sheet

  显示任何公开的Google表格中的单元格或单元格范围

• Individual cells are displayed as spans

  单个单元格显示为跨度

• Spans of cells displayed as tables, with optional headers

  显示为表格的单元格的范围，带有可选的标题

• Can target any tab within a Google Sheets document

  可以定位Google表格文档中的任何标签

• Able to use shortcode multiple times per post / page

  每个帖子/页面可以多次使用简码

• All options are configured via shortcode

  所有选项均通过简码配置

• Ability to store and use unlimited Google Sheet Documents

  能够存储和使用不受限制的Google表格文档

Shortcodes:

简码：

• Basic: [dansheet] (defaults to first document, default tab name)

  基本： [表格] （默认为第一个文档，默认标签名称）

• Single Cell: [dansheet file=1 sheetname="Sheet1" cell=A1 class="gsheets-special"]

  单个单元格： [dansheet file = 1 sheetname =“ Sheet1” cell = A1 class =“ gsheets-special”]

• Range of Cells: [dansheet file=1 sheetname=Sheet1 cell=A1:C2 theaders="Col 1,Col 2,Col 3" class="gsheets-special2"]

  单元格范围： [dansheet file = 1 sheetname = Sheet1 cell = A1：C2 theaders =“ Col 1，Col 2，Col 3” class =“ gsheets-special2”]

  >

  >

Optional Attributes

可选属性

• file=# (number of the Google Doc you have set in the settings page)

  file =＃（您在设置页面中设置的Google文档的编号）

• sheetname= name of sheet in doc

  sheetname =文档中的工作表名称

• cell (mandatory)= Cell Number or range, with :

  单元格（必填）=单元格编号或范围，带有：

• class=custom class name or names here

  class =自定义类名称或此处的名称

• theaders = Comma seperated list of column headers, in order, for range view (optional)

  theaders =逗号分隔的列标题列表，按顺序显示范围视图（可选）

For help creating an API key to use with this plugin, either check out the settings page in plugin, or the FAQ tab here.

要获取创建与此插件一起使用的API密钥的帮助，请查看插件中的设置页面或此处的“常见问题”标签。

To see other plugins like this, or tips on how these are built, check out my blog.<

要查看类似的其他插件，或有关其构建方式的提示，请查看我的博客。<

/p>

/ p>

Dependencies and Liscencing

依赖关系和许可

Depends on Google Sheets JSON API v4

取决于Google Sheets JSON API v4