TotalSheets is an online spreadsheet platform. Similar to Google Sheets in concept, but with the intention to give a greater control to users over the appearance of their published spreadsheets.
TotalSheets For WP is a simple plugin that helps to show TS spreadsheets in WordPress posts or pages. Just insert a shortcode wherever in a post or page.
Shortcode with a minimal requirement:
[totalsheets-for-wordpress spreadsheetid=”spreadsheet_id“]
where spreadsheet_id indicates the last 12 chars in the published spreadsheet link
A number of optional parameters for the shortcode can be set:
id – a unique identifier if more than one spreadsheet is to be shown in post/page. Default = “totalsheets-for-wordpress”.
width – width of the frame in % or px (100% by default).
height – height of the frame in % or px (auto by default).
autosize – auto sizing of the frame based on the content. Default = “true”.
border – show a border around the frame. Default = 0. Border style can be specified e.g., “3px solid black”
header – show a header bar with logo and ‘copy spreadsheet’ link (if copylink is set to “true”). Default = “true”.
headercolor – set a color for the header. Default = “#eee”.
copylink – show a ‘copy spreadsheet’ link. Default = “false”.
Example:
[totalsheets-for-wordpress spreadsheetid=”rYjVX5XlmlLV” width=”100%” height=”400px” autosize=”false” border=”1px solid #eee” copylink=”true”]
Download & install the zip archive
The plugin package installer can be downloaded from the WP2E project tab called “code”.
1 – Select the version to download if this option is available otherwise the “latest” version of the main plugin will be used.
2 – After downloading the zip archive install the plugin package installer in you local environment and activate the script from the plugin list.
3 – Under the section “Plugins” of the admin dashboard you should see a new “Dependencies & Licenses” link. Follow the instructions from this panel to finalize the installation of the missing dependencies.
-
- Give a name to your project
-
- Download the Installer Package
-
- Install & activate the plugin locally
-
- Install the suggested dependencies
Tips: Use the WP2E panel to add/suggest new dependencies to the local installation. Press F5 in the list of dependencies if the changes are not displayed right away.