Loading...
 
Display data from a TikiSheet

Plugin Sheet

Use this wiki plugin to integrate data from a Tiki Spreadsheet into a page.


Parameters

Introduced in Tiki1.
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 Any valid CSS class Apply custom CSS class to the containing div. 6.0
height Number of pixels followed by 'px' or percent followed by %). Height in pixels or percentage. Default value is complete spreadsheet height. Spreadsheet height 5.0
range Cell range, e.g. "D1:F3" or "e14:e14" 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 Number of pixels followed by 'px' or percent followed by %). Width in pixels or percentage. Default value is page width, for example, 200px or 100% Page width 6.0
editable y or n Show edit button. Default is to show depending on user's permissions. y 6.0
subsheets y or n Show multi-sheets (default is to show) y 6.0
id Spreadsheet ID number 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:
{sheet}


And follow the instructions/links that you will be provided in the page after saving it.

Example

This code:
{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:

Image


Would produce, in the middle of a wiki page context:

Image


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.


doc.tiki.org


Bootstrap

AdminGuide

UserGuide

  • User selector
  • Static Text Tracker Field
  • Subscription Tracker Field
  • System Tracker Field
  • Textarea Tracker Field
  • URL Tracker Field
  • Adding items to a tracker
  • How to change tracker field types
  • Linking trackers
  • Multilingual trackers
  • Searching tracker items
  • Viewing Tracker Results
  • Export trackers
  • Terms and Conditions
  • Accounting
  • User Preferences
  • Inter-User Messages
  • Gmap User
  • Bookmarks
  • Watch
  • User Page
  • MyTiki Details
  • Score vs Karma
  • User Action log
  • Search User
  • Mobile Tiki User
  • User Wizard
  • Must Reads

  • Keywords

    Keywords serve as "hubs" for navigation within the Tiki documentation. They correspond to development keywords (bug reports and feature requests):

    Accessibility (WAI and 508)
    Accounting (7.x)
    Articles and Submissions
    Backlinks
    Banners
    Batch (6.x)
    BigBlueButton audio/video/chat/screensharing (5.x)
    Blog
    Bookmark
    Browser Compatibility
    Link Cache
    Calendar
    Category
    Chat
    Clean URLs
    Comments
    Communication Center
    Compression (gzip)
    Contacts (Address Book)
    Contact us
    Content Templates
    Contribution (2.x)
    Cookie
    Copyright
    Credit (6.x)
    Custom Home and Group Home Page
    Date and Time
    Debugger Console
    Directory of hyperlinks
    Documentation link from Tiki to doc.tiki.org (Help System)
    Docs 8.x
    Draw 7.x
    Dynamic Content
    Dynamic Variable
    External Authentication
    FAQ
    Featured links
    File Gallery
    Forum
    Friendship Network (Community)
    Gmap Google maps
    Groups
    Hotword
    HTML Page
    i18n (Multilingual, l10n, Babelfish)
    Image Gallery
    Import-Export
    Install
    Integrator
    Interoperability
    Inter-User Messages
    InterTiki
    Kaltura video management (4.x)
    Karma
    Live Support
    Login
    Logs (system & action)
    Look and Feel
    Lost edit protection
    Mail-in
    Map with Mapserver
    Menu
    Meta Tags
    Mobile Tiki and Voice Tiki
    Mods
    Module
    MultiTiki
    MyTiki
    Newsletter
    Notepad
    Payment
    Performance Speed / Load
    Permissions
    Platform independence (Linux-Apache, Windows/IIS, Mac, BSD)
    Polls
    Profiles
    Profile Manager
    Report
    Toolbar
    Quiz
    Rating
    Feeds
    Score
    Search engine optimization
    Search
    Search and Replace
    Security
    Semantic links (3.x)
    Shadowbox
    Shadow Layers
    Share
    Shopping cart
    Shoutbox
    Slideshow
    Smiley
    Social Networks
    Spam protection (Anti-bot CATPCHA)
    Spellcheck
    Spreadsheet
    Stats
    Surveys
    Tags (2.x)
    Task
    Tell a Friend, alert + Social Bookmarking
    TikiTests (2.x)
    Theme CSS & Smarty
    Trackers
    Transitions (5.x)
    TRIM
    User Administration including registration and banning
    User Files
    User Menu
    Watch
    WebHelp
    WebDAV (5.x)
    Webmail
    Web Services
    Wiki 3D
    Wiki History, page rename, etc
    Wiki Page Staging and Approval (2.x)
    Wiki Plugin extends basic syntax
    Wiki Syntax
    Wiki structure (book and table of content)
    Workspace
    WSOD
    WYSIWYCA
    WYSIWYG (2.x)
    XMLRPC


    Tiki Newsletter

    Delivered fresh to your email inbox!
    Newsletter subscribe icon
    Don't miss major announcements and other news!
    Contribute to Tiki