cross
New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
TIP SpreadsheetReaderPlugin is not installed on Foswiki.org.

SpreadsheetReaderPlugin

Read data from a spreadsheet

This plugin can read common spreadsheet documents and renders them as HTML. Supported file formats are:

  • xls
  • xlsx
  • ods
  • csv

Examples

%SPREADSHEET{"test.xlsx" sheet="2"}%

Syntax

The %SPREADHSHEET{...}% makro takes the following parameters:

Parameter Description Default
"..." or attachment="..." file name of an uploaded spreadsheet file  
web="...", topic="..." location of the spreadsheet file current topic
password="..." password to unlock a protected spreadsheet  
sep="..." (only csv) column separator for csv files  
quote="..." (only csv) quote character for cells in a csv files  
sheets="..." or sheet="..." sheets to extract (1-based); this may a single sheet or a comma separated list of sheets, or the keyword all 1
rows="..." list of rows to extract data from; this is either a comma separated list of row numbers, or the keyword =all" all
cols="..." list of columns to extract data from; this is either a comma separated list of column numbers, or the keyword =all" all
class="..." css class to add to the HTML table being rendered foswikiTable
showattrs="on/off" boolean switch to extract cell attributes such as bold, italic, foreground- and background colors, alignment; set this to off to get the raw HTML table only; note that this currently only works reliably for xls and xlsx files on
showindex="on/off" boolean switch to display a row index off

Installation Instructions

You do not need to install anything in the browser to use this extension. The following instructions are for the administrator who installs the extension on the server.

Open configure, and open the "Extensions" section. "Extensions Operation and Maintenance" Tab -> "Install, Update or Remove extensions" Tab. Click the "Search for Extensions" button. Enter part of the extension name or description and press search. Select the desired extension(s) and click install. If an extension is already installed, it will not show up in the search results.

You can also install from the shell by running the extension installer as the web server user: (Be sure to run as the webserver user, not as root!)
cd /path/to/foswiki
perl tools/extension_installer <NameOfExtension> install

If you have any problems, or if the extension isn't available in configure, then you can still install manually from the command-line. See https://foswiki.org/Support/ManuallyInstallingExtensions for more help.

Dependencies

NameVersionDescription
Spreadsheet::Read>=0.78Required
Spreadsheet::ReadSXC>=0.20Required
Spreadsheet::ParseExcel>=0.65Required
Spreadsheet::ParseXLSX>=0.27Required
Text::CSV_XS>=1.35Required

Change History

17 Apr 2018 initial release
Topic revision: r1 - 17 Apr 2018, MichaelDaum - This page was cached on 17 Apr 2018 - 14:38.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License