Plugin Sheet
Use this wiki plugin to integrate data from a Tiki Spreadsheet into a page.
Parameters
Display data from a TikiSheetIntroduced in Tiki 1.
Go to the source code
Preferences required: wikiplugin_sheet, feature_sheet
| Parameters | Accepted Values | Description | Default | Since |
|---|---|---|---|---|
| (body of plugin) | Spreadsheet Heading | |||
url |
url | Internal URL of the Table to use as a spreadsheet. Either id or url is
required. |
6.0 | |
class |
Apply custom CSS class to the containing div. | 6.0 | ||
height |
Height in pixels or percentage. Default value is complete spreadsheet height. | Spreadsheet height | 5.0 | |
range |
Show a range of cells (or single cell). Default shows all. e.g. D1:F3 or
e14:e14 |
All cells | 6.0 | |
simple |
(blank) y n |
Show a simple table view (Default: n = jquery.sheet view if feature enabled). |
n | 5.0 |
width |
Width in pixels or percentage. Default value is page width, for example, 200px or
100% |
Page width | 6.0 | |
editable |
Show edit button. Default is to show depending on user's permissions. | y | 6.0 | |
subsheets |
Show multi-sheets (default is to show) | y | 6.0 | |
id |
Internal ID of the TikiSheet. Either id or url is required. |
1 |
In Tiki7, you can use an internal or external url to a csv file in the url param of the sheet plugin, in order to show the csv file as a spreadsheet within Tiki.
Add one
Insert this code in a wiki page in order to have on spreadsheet added there:
Copy to clipboard
{sheet}
And follow the instructions/links that you will be provided in the page after saving it.
Example
This code:
Copy to clipboard
{SHEET(id="15")}Table 2. Advantages and disadvantages detected by the teaching staff after using Wiki methodology{SHEET}
A tiki site with sheet id 15 (tiki-view_sheets.php?sheetId=15) as:
Would produce, in the middle of a wiki page context:
The edit sheet button is shown while a registered user is logged in to the site. When logged out, no "edit sheet" button is shown.