Is there a common lisp library for creating excel spreadsheets?
Is there a common lisp library for creating excel spreadsheets? I'd much much prefer that it output one of the XML formats.
Update:
To add some m开发者_如何学编程ore context, creating a csv file from common lisp is pretty trivial, and that's what I'm doing now.
The XML Spreadsheet format is pretty simple, and there are common lisp libraries that make it easy to output arbitrary XML, so rolling my own would be pretty easy, but if something already exists to ease the process I would prefer that.
buildnode seems to be what you want. It lacks documentation, but includes a basic working example of an Excel spreadsheet.
It's also quicklisp-installable, so easy to start playing with.
(ql:quickload 'buildnode-excel)...
I'm just leaving this here, because I almost decided to write my own Excel generator before discovering buildnode.
I haven't used it, but the xml-emitter library looks useful. It ought to be trivial to get the generated XML into Excel, or any spreadsheet.
http://www.cliki.net/xml-emitter
Hope this helps!
I suspect you will have to output CSV files and import them into Excel. If you need more than just data, Lisp might not be the best tool... You could automate Excel to do it via COM interface, but a quick search doesn't find a COM binding for Lisp. I know one (used to) exists for Scheme though.
精彩评论