Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Prolog based spreadsheet analyzer (prototype)
branch: master

This branch is 12 commits ahead of JanWielemaker:master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
Background.md
Jocelyn.mail
README.TXT
alpino.pl
bisect.pl
data.pl
datasource.pl
exp_labels.pl
formula.pl
gv_attrs.pl
gvugraph.pl
kmeans.pl
labels.pl
ods_table.pl
of_functions.pl
om.pl
recognise.pl
rtree.pl
table.pl
test.pl
test_rtree.pl
tordf.pl
varnames.pl
webui.css
webui.pl

README.TXT

# PlSheet: a SWI-Prolog library for analyzing ODF spreadsheets

PlSheet is a SWI-Prolog  library  for   analysing  ODF  spreadsheets. It
covers representing the spreadsheet as a Prolog fact base which includes
cell contents, cell types,  cell  formulas   and  cell  style (spanning,
colour, font, etc). On top of  that,   it  provides facilities to reason
about formula dependencies and discover  regions with similar properties
(e.g., a region of cells with labels).

The file test.pl contains sample toplevel  code   that  can be used as a
starting point to use the library.

## Home

PlSheet is hosted on GitHub at https://github.com/Data2Semantics/plsheet

## Installation

Plsheet depends on two SWI-Prolog add-ons,  which can be installed using
the following commands (to be typed at the Prolog prompt)

  ==
  ?- pack_install(webconsole).
  ?- pack_install(graphml).
  ==

## Documentation

The library is documented in the source using PlDoc. The simplest way to
view the documentation is by running the   command  below, which opens a
browser with interactive facilities for  exploring the documentation and
sources.

  ==
  % swipl --pldoc test.pl
  ==


## Processing MicroSoft Excel files

This library only processes ODF (Open Document Format) files. ODS is the
ODF sub-format for spreadsheets. Open Office  and Libre Office ship with
a tool called =unoconv= to do batch  conversion of MicroSoft excel files
using the following command:

  ==
  % unoconv -f ods *.xlsx
  ==

## Acknowledgements

This library was developed in the context  of COMMIT/, and in particular
the Data2Semantics project thereof.

[commit.png;height="80pt"](http://www.commit-nl.nl/)
[data2semantics.png;height="80pt",align="right"](http://www.data2semantics.org/)















Something went wrong with that request. Please try again.