Geek Answers Handbook

Is there a generic lisp library for creating Excel tables?

Is there a generic lisp library for creating Excel tables? I would really like it to output one of the XML formats.

Update:

To add some more context, creating a csv file from regular lisp is pretty trivial, and what am I doing now.

The XML Spreadsheet format is pretty simple, and there are generic lisp libraries that make it easy to output arbitrary XML, so native will be pretty easy, but if something already exists to make the process easier, I would prefer it.

+6
excel common-lisp
source share
3 answers

buildnode seems to be what you want. It lacks documentation, but it contains a basic working example of an Excel spreadsheet.

It can also be quickly inserted, so easy to start playing.

(ql:quickload 'buildnode-excel)...

I just leave it here because I almost decided to write my own Excel generator before opening buildnode.

+2
source share

I have not used it, but the xml-emitter library looks useful. To get the generated XML in Excel or in any spreadsheet should be trivial.

http://www.cliki.net/xml-emitter

Hope this helps!

+1
source share

I suspect you will have to output the CSV files and import them into Excel. If you need more than just data, Lisp may not be the best tool ... You can automate Excel for this through the COM interface, but a quick search does not find COM bindings for Lisp. I know that one (used) exists for the Schema, though.

-one
source share

More articles:


All Articles