描述
A wordpress plugin which imports Google Spreadsheet Data into the WordPress Page/Post using shortcode.
You have to provide Sheet Key, Worksheet Name, Username and Password in shortcode.
Usage:
[gdata_import key=”spreadsheet_key” worksheet=”worksheet_name” user=”your_username” pass=”your_password”]
Example:
[gdata_import key=”0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV”
worksheet=”Sheet1″ user=”your_username” pass=”your_password”]
螢幕截圖
Spreadsheet Key 
Worksheet Name 
Data in Spreadsheet 
Imported Data in wordpress
安裝
- Upload
gdata-importerto the/wp-content/plugins/directory - Activate the plugin through the ‘Plugins’ menu in WordPress
- Place shortcode [gdata_import key=”spreadsheet_key”
worksheet=”worksheet_name” user=”yourusername” pass=”yourpassword”] in your post
常見問題
- Where to get spreadsheet key?
-
You can get the spreadsheet key from the Spreadsheet URL.
Example Spreadsheet URL: https://docs.google.com/spreadsheet/ccc?key=0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV#gid=0
Then your Spreadsheet key is: 0AqJJ6fnIoHPYdE1qTFF0OWtFX2xfRHU1OC1oY0JIeVV
- Where to get worksheet parameter?
-
The worksheet parameter refers to the worksheet name.
Example: Sheet1
- I am getting error “ERROR: Unable to Connect to ssl://docs.google.com:443. Error #110: Connection timed out”
-
Some hosting providers do not allow https connections to be made from their servers, Contact your Hosting to assist & solve the problem.
Refer: https://developers.google.com/gdata/articles/php_client_lib#appendix_issues_proxy
評價
There are no reviews for this plugin.
貢獻者及開發者
修改日誌
1.0.2
Bug Fixes.
Added Title for Sheets.
1.0.1
Bug Fixes.
1.0.0
Initial Release.