/excel-xmltv

Convert MS Excel document into XMLTV compliant xml

Primary LanguageRuby

Description

This is a parser to convert program guide data from MS Excel spreadsheets to XMLTV compliant xml.

Given the schema followed, this will only ever really work with the spreadsheets created by Triangle TV in New Zealand.

The hope of this project is to provide a simple script to do one-line conversion. e.g;

ruby excel-xmltv.rb triangle.xls > triangle.xml

Dependecies

Requires Ruby, RebyGems. Also requires the 'builder' and 'roo' gems.

Howto

gem install builder
gem install roo

git clone git@github.com:jonathanhoskin/excel-xmltv.git

cd excel-xmltv

ruby excel-xmltv.rb [input file].xls > [output].xml

See also

XMLTV Wiki: http://wiki.xmltv.org

Triangle TV: http://www.tritv.co.nz/