內容簡介
Dan’s Google Sheets Data Embedder是出於非技術人員需要將複雜的計算從WordPress中搬移到更熟悉的電子試算表環境，以及能夠僅分享從試算表中所需的信息部分而不是分享整個文檔的需要而創建的。
Dan’s GSheets可以通過短代碼直接嵌入單個單元格值或範圍值。無需在WordPress中導入數據或直接管理數據。您只需要一個公開的Google Sheets文件（或多個！）和一個免費且易於獲取的API密鑰。
建議用途
將所有複雜的計算轉移到Google Sheets！從Google表格或任何其他地方獲取數據，並僅顯示結果
需要更新特定信息的非技術性客戶或用戶？只需通過短代碼將該位置映射到Google Sheets單元格，並與他們分享具有編輯權限的文檔
在WordPress中創建好的前端，並通過Google Sheets作為電子表格更新實時得分
你還有其他的想法嗎？我們很樂意聽取！在您的評論中或通過我的網站留言分享。
功能
以易於格式化的方式顯示公共Google Sheets文檔數據
頁面加載時實時更新。只需在表格中更改您的數據，它就會實時顯示在網站上！
顯示來自任何公共Google Sheet的單元格或單元格範圍
將個別單元格顯示為跨度
將單元格範圍顯示為表格，帶有可選標題
可以鎖定Google Sheets文檔中的任何選項卡
可在帖子/頁面中多次使用短代碼
所有選項都通過短代碼進行配置
能夠存儲和使用無限的Google Sheet文檔
短碼:
基本: [dansheet]（默認為第一個文檔，默認選項卡名稱）
單個單元格: [dansheet file=1 sheetname="Sheet1" cell=A1 class="gsheets-special"]
單元格範圍: [dansheet file=1 sheetname=Sheet1 cell=A1:C2 theaders="Col 1,Col 2,Col 3" class="gsheets-special2"]
可選屬性
文件=#（在設置頁面中設置的Google Doc數字）
表單名=文檔中的表單名稱
cell（必填）=帶有冒號的單元格號或範圍
class=在此處自定義類名稱
theaders = 範圍視圖中按順序的逗號分隔的列標題（可選）
如需幫助創建用於此外掛的API密鑰，請查閱外掛中的設置頁面或此處的FAQ選項卡。
要查看其他類似的外掛程序或有關這些程序的構建提示，請查閱我的博客。
依賴和許可
依賴於Google Sheets JSON API v4
外掛標籤
開發者團隊
原文外掛簡介
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 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. No need to import data or manage it directly in WordPress. All you need is a public Google Sheets Document (or multiple!) and a free, easy to get API key.
Suggested Uses
Offload all of your complex calculations to Google Sheets! Take data from Google forms, or wherever else you wish, and just display the results
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
Create a nice front end in WordPress, and update live scores via Google Sheets as a spreadsheet
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
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
Individual cells are displayed as spans
Spans of cells displayed as tables, with optional headers
Can target any tab within a Google Sheets document
Able to use shortcode multiple times per post / page
All options are configured via shortcode
Ability to store and use unlimited Google Sheet Documents
Shortcodes:
Basic: [dansheet] (defaults to first document, default tab name)
Single Cell: [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"]
Optional Attributes
file=# (number of the Google Doc you have set in the settings page)
sheetname= name of sheet in doc
cell (mandatory)= Cell Number or range, with :
class=custom class name or names here
theaders = Comma seperated list of column headers, in order, for range view (optional)
For help creating an API key to use with this plugin, either check out the settings page in plugin, or the FAQ tab here.
To see other plugins like this, or tips on how these are built, check out my blog.
Dependencies and Liscencing
Depends on Google Sheets JSON API v4
