前言介紹
- 這款 WordPress 外掛「Inline Google Spreadsheet Viewer」是 2010-08-18 上架。 目前已經下架不再更新，不建議安裝使用。
- 目前有 9000 個安裝啟用數。
- 上一次更新是 2020-04-02，距離現在已有 1857 天。超過一年沒更新，安裝要確認版本是否可用。以及後續維護問題！
- 外掛最低要求 WordPress 4.0 以上版本才可以安裝。
- 有 68 人給過評分。
- 還沒有人在論壇上發問，可能目前使用數不多，還沒有什麼大問題。
外掛協作開發者
meitar |
外掛標籤
google | web apps | google docs | spreadsheet | Google Apps Script |
內容簡介
可以輕易地將存儲在Google電子表格、CSV檔案、MySQL數據庫或Google Apps Script輸出中的數據轉換為美麗的互動圖表或圖形、可排序和可搜索的表格或兩者兼備。嵌入由Google Docs Viewer支持的PDF、XLS、DOC和其他文件格式的實時預覽。內置緩存提供額外的速度。
更新您的博客文章或頁面，每當Google電子表格或CSV文件發生更改時。
輕鬆從您的Google電子表格或CSV文件創建美麗的交互式圖形和圖表。
使用強大而靈活的查詢語言和眾多配置選項自定義表格或圖表的外觀和感覺。
從多種不同來源使用數據：Google電子表格、Google Apps Scripts、CSV文件、WordPress數據庫或遠程MySQL數據庫。
嵌入幾乎任何在線文件以在不離開您的博客的情況下查看。
此插件的捐款佔了我收入的一部分。如果您繼續喜歡這個插件，請考慮捐贈。🙂感謝您的支持！
快速入門
在WordPress文章或頁面中將您的公共Google表格或Google Apps Script Web應用程式的URL粘貼在自己的行中，然後保存您的文章。就這樣。🙂您的數據將出現在一個排序的、可搜索的HTML表格中。Web應用程序輸出將使用Web應用程序定義的HTML顯示。請參見屏幕截圖以瞭解示例。
如果使用Google電子表格，則必須使用“網上公開”或“具有鏈接的任何人”選項共享電子表格(了解如何共享您的電子表格)。當前，不支持私有Google電子表格或與“指定人員”共享的電子表格。Web應用程序必須使用“任何人，甚至匿名”的訪問權限部署(請參見權限)。CSV文件必須對公眾開放，不需要登錄到它們托管的站點。
獲得支持
本文檔是此插件的唯一支持文檔。
由於有大量重複的文章要求問題已經在本文件或支持論壇的早期發帖中得到回答，因此我不再志願為此插件的用戶在任何情況下提供支援，超出我已經製作的文檔。
換言之：
不要給我發電子郵件期望得到回覆。我會刪除您的電子郵件。
不要在支持論壇上張貼期望得到我的回復。我不會閱讀您的帖子，因此不會回覆。
有十年以上的問題和回答涵蓋了這個插件，您可以在這些資源中尋找支援。
原文外掛簡介
Easily turn data stored in a Google Spreadsheet, CSV file, MySQL database, or the output of a Google Apps Script into a beautiful interactive chart or graph, a sortable and searchable table, or both. Embed live previews of PDF, XLS, DOC, and other file formats supported by the Google Docs Viewer. A built-in cache provides extra speed.
Update your blog post or page whenever a Google Spreadsheet or CSV file changes.
Create beautiful interactive graphs and charts from your Google Spreadsheet or CSV files with ease.
Customize the table’s or chart’s look and feel using a powerful and flexible query language and a plethora of configuration options.
Use data from a variety of different sources: Google Spreadsheets, Google Apps Scripts, CSV files, your WordPress database, or a remote MySQL database.
Embed almost any online document to view without leaving your blog.
Donations for this plugin make up a chunk of my income. If you continue to enjoy this plugin, please consider making a donation. 🙂 Thank you for your support!
Quick start
Paste the URL of your public Google Spreadsheet or Google Apps Script Web App on its own line in your WordPress post or page, then save your post. That’s it. 🙂 Your data will appear in a sorted, searchable HTML table. Web App output will be displayed using the HTML defined by the Web App. See the screenshots for an example.
If using a Google Spreadsheet, the spreadsheet must be shared using either the “Public on the web” or “Anyone with the link” options (learn how to share your spreadsheet). Currently, private Google Spreadsheets or Spreadsheets shared with “Specific people” are not supported. Web Apps must be deployed with the “Anyone, even anonymous” access permissions. CSV files must be available to the public, without the need to log in to the site where they’re hosted.
Getting support
This document is the only support document for this plugin.
Due the sheer volume of repetitive posts asking questions that have already been answered in this document or by earlier postings on the support forum, I no longer volunteer any of my time to give support to users of this plugin under any circumstances beyond the documentation I have already produced.
In other words:
Do not email me expecting a reply. I will delete your email.
Do not post on the support forum expecting a reply from me. I will not read your posting and will therefore not respond.
There are more than ten years of questions and answers to those questions covering almost every conceivable use case and situation in which this plugin has been used or is likely to ever be used on the support forum that I have been present for. The meager amount of donations I receive for this plugin does not even register against the fathomingly high amount of effort I have put into monitoring support queries for this plugin. Worse, this effort was often in vain because the answers to the questions almost every single person who asked a question was seeking was already answered in this document or in a previous posting already. Enough is enough.
Your only options to get support for this plugin are:
actually read this document, or
use the Internet to search for answers previously answered elsewhere, or
seek help from someone other than me.
Hopefully, since no one can actually get my support any longer, more of them will do the thing they should have done in the first place and actually read this document, saving everyone involved a lot of time.
User guide
You can transform your spreadsheet into an interactive chart or graph, embed documents other than spreadsheets, and customize the HTML of your table using a [gdoc key=""] WordPress shortcode. The only required parameter is key, which specifies the document you’d like to retrieve. All additional attributes are optional.
Google Spreadsheets
After saving the appropriate Sharing setting, copy the URL you use to view the Google Spreadsheet from your browser’s address bar into the shortcode. For example, to display the spreadsheet at https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=123456, use the following shortcode in your WordPress post or page:
[gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/edit#gid=123456"]
CSV files
Using a CSV file works the same way as Google Spreadsheets. Set the key to the URL of the file to display it as an HTML table:
[gdoc key="http://example.com/research_data.csv"]
HTML Tables
Customizing the HTML tables that are produced is easy. For instance, to supply the table’s title,
[gdoc key="ABCDEFG" class="my-sheet" title="Tooltip text displayed on hover"]This is the table's caption.[/gdoc]
The above shortcode will produce HTML that looks something like the following:
By default, all tables are progressively enhanced with jQuery DataTables to provide sorting, searching, and pagination functions on the table display itself. If you’d like a specific table not to include this functionality, use the no-datatables class in your shortcode. For instance:
[gdoc key="ABCDEFG" class="no-datatables"]
Web addresses and email addresses in your data are turned into links. If this causes problems, you can disable this behavior by specifying no to the linkify attribute in your shortcode. For instance:
[gdoc key="ABCDEFG" linkify="no"]
Each table can be customized per-table, using shortcode attributes, or globally for your entire site, using the plugin’s settings screen. You can freeze the table header, columns, control pagination length, and more. Refer to the Other Notes section for a full listing of supported customization attributes.
Charts
Data from Google Spreadsheets or CSV files can be graphed in interactive charts. To visualize your data as a chart, add the chart attribute to your shortcode and supply a supported chart type. You can make:
AnnotatedTimeLine charts
Annotation charts
Area charts
Bar charts
Bubble charts
Candlestick charts
Column charts
Combo charts
Gauge charts
Geo charts
Histogram charts
Line charts
Pie charts
Scatter charts
Stepped area charts
Timeline charts
For example, if you have data for a sports league that records the goals each team has scored (where the first column is the team name and the second column is their total goals), you can create a bar chart, with an optional title, from that data using a shortcode like this:
[gdoc key="ABCDEFG" chart="Bar" title="Total goals per team"]
You can customize your chart with a number of options, such as colors. For example, to create a 3D red and green pie chart whose slices are labelled with your data’s values:
[gdoc key="ABCDEFG" chart="Pie" chart_colors="red green" chart_dimensions="3" chart_pie_slice_text="value"]
Pre-processing data with Google Queries
You can pre-process your Google Spreadsheets or CSV files before retrieving data from them by passing a Google Charts API Query Language query to the shortcode’s query attribute. This lets you interact with the data in your Google Spreadsheet or CSV file as though it were a relational database table. For instance, if you wish to display the team that scored the most goals on your website, you might use a shortcode like this to query your Google Spreadsheet and display the highest-scoring team, where the team name is the first column (column A) and that team’s score is the second column (column B):
[gdoc key="ABCDEFG" query="select A where max(B)"]
Queries are also useful if your spreadsheet contains complex data from which many different charts can be created, allowing you to select only the parts of your spreadsheet that you’d like to use to compose the interactive chart.
Using a MySQL Database
After an administrator enables the SQL queries option in the plugin’s settings screen, privileged users can also retrieve data from the WordPress database by supplying the keyword wordpress to the key attribute of your shortcode along with a valid MySQL SELECT statement. This can be useful for displaying information that other plugins save in your website’s database or that WordPress itself maintains for you.
For example, to show a table of user registration dates from the current blog:
[gdoc key="wordpress" query="SELECT display_name AS Name, user_registered AS 'Registration Date' FROM wp_users"]
Remote MySQL databases are also accessible by supplying a MySQL connection URL with valid access credentials. For example, to show the prices from an inventory database hosted by a MySQL server at server.example.com by logging in as user with the password password and querying for items that are in stock:
[gdoc key="mysql://user:[email protected]/inventory" query="SELECT sku AS 'Item No.', product_name AS Product, price AS Price WHERE in_stock=TRUE"]
Using Google Apps Script Web Apps
You can also supply the URL endpoint of any Google Apps Script Web App to retrieve the output from that app and insert it directly into your WordPress post or page. This works exactly the same way as Google Spreadsheets do, so you can use this feature to display arbitrary data on your WordPress site.
For example, suppose you maintain a GMail account for fans of your podcast to write you questions, and you want to automatically display some information from these emails on your website. Using GMail filters and labels, you can access these emails through a Google Apps Script that reads your email, counts the number of mail messages in your different labels, and returns that count as an HTML list fragment. Deploy that Google Apps Script as a Web App and supply its URL to the gdoc shortcode:
[gdoc key="https://script.google.com/macros/s/ABCDEFG/exec"]
Now your website is automatically updated whenever you receive a new question in email from your listeners.
Embedding other documents
You can also supply the URL of any file online to load a preview of that file on your blog. To do so, supply the file’s URL as your key:
[gdoc key="http://example.com/my_final_paper.pdf"]
To tweak the way your preview looks, you can use the width, height, or style attributes:
[gdoc key="http://example.com/my_final_paper.pdf" style="min-height:780px;border:none;"]
If you like this plugin, please consider making a donation for your use of the plugin, purchasing one of Meitar’s web development books or, better yet, contributing directly to Meitar’s Cyberbusking fund. (Publishing royalties ain’t exactly the lucrative income it used to be, y’know?) Your support is appreciated!
Shortcode attribute documentation
This plugin provides one shortcode (gdoc) that can do many things through a combination of shortcode attributes. Every attribute must have a value. These attributes and their recognized values are documented here.
key – Specifies the document to retrieve.
required Every gdoc shortcode must have one and only one key attribute. (All other attributes are optional.)
key can be one of six types:
The fully-qualified URL of a Google Spreadsheet that has been publicly shared, like [gdoc key="https://docs.google.com/spreadsheets/d/ABCDEFG/htmlview#gid=123456"]
The fully-qualified URL of a Google Apps Script Web App, like [gdoc key="https://script.google.com/macros/s/ABCDEFG/exec"]
The fully-qualified URL of a CSV file or a web service endpoint that produces CSV data, like [gdoc key="http://viewportsizes.com/devices.csv"]
The fully-qualified URL of a document on the Web. PDF, DOC, XLS, and other file formats supported by the Google Docs Viewer will be rendered using the Viewer, like [gdoc key="http://example.com/my_final_paper.pdf"]
The keyword wordpress to make a SQL query against the current blog’s database, like [gdoc key="wordpress" query="SELECT * FROM custom_table"]
A MySQL connection URL to make a SQL query against an arbitrary MySQL server, like [gdoc key="mysql://user:[email protected]:12345/database" query="SELECT * FROM custom_table"]
chart – Displays Google Sheet data as a chart instead of a table. Valid values are:
AnnotatedTimeLine
Annotation
Area
Bar
Bubble
Candlestick
Column
Combo
Gauge
Geo
Histogram
Line
Pie
Scatter
Stepped
Timeline
class – An optional custom HTML class value or space-separated list of values. The following class names are treated specially:
no-datatables deactivates all DataTables features.
no-responsive deactivates only DataTables’ Responsive features.
FixedHeader or its synonym, FixedHeader-top, freezes the table header (its
FixedHeader-footer freezes the table footer (its content) to the bottom of the window while scrolling vertically.
FixedHeader-left or FixedHeader-right freezes the left- or right-most column of the table while scrolling horizontally. (You will also need to set datatables_scroll_x="true" in your shortcode to enable horizontal scrolling.)
FixedColumns-left-N or FixedColumns-right-N freezes the left- or right-most N columns in the table, respectively. For example, class="FixedColumns-left-3" will freeze the three left-most columns.
csv_headers – Whether or not to include textual headers in Google Sheet CSV exports when using query or chart. (Default: 0, which is to exclude them, which is equivalent to the Google default. Use 1 to include them.)
expire_in – How long to cache responses for, in seconds. Set this to 0 to cache forever. (Default: 600, which is ten minutes.)
footer_rows – A number specifying how many trailing rows to place in the output’s
header_cols – A number specifying how many column cells should be written with
header_rows – A number specifying how many leading rows to place in the output’s element. (Default: 1.)
height – Height of the containing HTML element. Tables ignore this, use style instead. (Default: automatically calculated.)
http_opts – A JSON string representing options to pass to the WordPress HTTP API, like [gdoc key="ABCDEFG" http_opts='{"method": "POST", "blocking": false, "user-agent": "My Custom User Agent String"}'].
lang – The ISO 639 language code declaring the human language of the spreadsheet’s contents. For instance, use nl-NL to declare that content is in Dutch. (Default: your site’s global language setting.)
linkify – Whether or not to automatically turn URLs, email addresses, and so on, into clickable links. Set to no to disable this behavior. (Default: true.)
query – A Google Query Language query if the data source is a Google Spreadsheet or CSV file, or a SQL SELECT statement if the data source is a MySQL database. Note: Arrow bracktets () in queries must be URL-encoded (%3C and %3E, respectively) to avoid confusing the WordPress HTML parser. (Default: none.)
strip – The number of leading data source rows to omit from the resulting HTML table. (Default: 0.)
style – An inline CSS rule applied to the containing HTML element. For example, to set a fixed height on a table, use [gdoc key="ABCDEFG" style="height: 480px;"]. (Default: none.)
summary – A brief description of the information displayed for the summary attribute of the resulting HTML
will show up. However, if the datasource is editable by a malicious user, this is easily abused and is considered a security risk. The author strongly advises caution here and suggests you do not do this unless you are absolutely sure you need this functionality. A much safer technique is to include only the filename of an image in the original datasource (my-image.png) and then write your filter function to append the value of the cell’s data to a base URL so that you can control the source of embedded objects in your HTML pages. Security vulnerabilities are serious, so please make use of the WordPress support forums if you are unsure whether your code is safe.