# Generating OOo-Calc charts with Ruby

**URL:** <https://www.ruby-forum.com/t/generating-ooo-calc-charts-with-ruby/89305>\
**Category:** Ruby\
**Created:** [March 19, 2007, 12:40pm UTC](https://www.ruby-forum.com/t/generating-ooo-calc-charts-with-ruby/89305 "2007-03-19T12:40:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![apanloco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/278dde/32.png) [@apanloco](https://www.ruby-forum.com/u/apanloco)\
**Post date:** [March 19, 2007, 12:40pm UTC](https://www.ruby-forum.com/t/generating-ooo-calc-charts-with-ruby/89305/1 "2007-03-19T12:40:34Z")

</div>

For a while I have been using Ruby to generate charts in Excel through  
WIN32OLE, i.e. require ‘win32ole’. I am now wondering if something  
similar can be achieved using [OpenOffice.org](http://OpenOffice.org) Calc and Ruby. I can’t find  
anything about this when googling, but I would be surprised if it isn’t  
possible.

/al

---

<div class="post-metadata">

**Author:** ![apanloco](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/278dde/32.png) [@apanloco](https://www.ruby-forum.com/u/apanloco)\
**Post date:** [March 19, 2007, 2:53pm UTC](https://www.ruby-forum.com/t/generating-ooo-calc-charts-with-ruby/89305/2 "2007-03-19T14:53:10Z")

</div>

On 3/19/07, apanloco [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> For a while I have been using Ruby to generate charts in Excel through  
> WIN32OLE, i.e. require ‘win32ole’. I am now wondering if something  
> similar can be achieved using [OpenOffice.org](http://OpenOffice.org) Calc and Ruby. I can’t find  
> anything about this when googling, but I would be surprised if it isn’t  
> possible.

Since the OO document format is an XML dialect, it should be possible to  
generate the files directly with e.g. REXML.