DHTMLX Docs & Samples Explorer

Plugin for Wordpress

To use functionality of the Spreadsheet plugin in WordPress you should perform the following actions:

The most recent version of Wordpress can be downloaded here.

Installing the plugin

WordPress offers the following way of adding the plugin to your page:

  • Download the Spreadsheet package to your local machine as a zip file;
  • From the Administration panel click on the Plugins tab;
  • Select Add New;
  • From the Workspace click on the Upload tab;
  • From the tab click the button Browse and choose the directory to your plugin package in the opened browse window;
  • Click the button Install Now.

Activating the plugin

Once you have uploaded the plugin to your WordPress plugin directory, you should activate it from the Plugins Management page.

  • From the Administration panel click on the Plugins tab;
  • Select Plugins;
  • To turn the plugin on, click Activate in the same row as the Spreadsheet plugin entry.

Using the plugin

Please note, the following users groups can edit Spreadsheet:

  • Administrator;
  • Editor.

To add Spreadsheet to a post or a page you should insert the appropriate Spreadsheet marker.

The Spreadsheet marker can be specified in 2 forms:

  1. Short form
    (doesn't contain any parameters. All the available parameters are set to default values)

    [[spreadsheet]]
    
  2. Full form
    (contains several available parameters. Non-specified parameters take default values)

    [[spreadsheet?&width=600px&height=400px&id=3&color_scheme=salad]]
    

Available parameters:

Parameter Type Description Default value
id string sets the id of a spreadsheet 1
height px or % or auto sets the height of a spreadsheet auto
width px or % or auto sets the width of a spreadsheet 100%
math boolean enables formulas in a spreadsheet false
skin dhx_skyblue or dhx_web sets the skin for a spreadsheet dhx_skyblue
color_scheme enum
(available values)
sets the color scheme for the specified skinnot applied
autoheight boolean sets the height at which all rows are visible without vertical scrolling true
autowidth boolean sets the width at which all columns are visible without horizontal scrolling false

Note, if the autoheight (autowidth) parameter is set to true, the height (width) parameter is ignored.

You can insert any text before
[[spreadsheet?&width=600px&height=250px&id=5&math=true]]
or after spreadsheet instance