jlahd / clods-export Goto Github PK
View Code? Open in Web Editor NEWCommon Lisp OpenDocument spreadsheet export library
License: MIT License
Common Lisp OpenDocument spreadsheet export library
License: MIT License
This is related to discussion on Reddit on reading and writing Excel files, and this library was mentioned.
I once wrote a private CL library for ABCL to use a Java Apache POI library to write Excel files.
My question is: When you defined your functions to generate the files, did you use any existing guides or libraries as guides? Or was it personal experience, taste, preference?
Thanks,
Mirko
Comparing against a simple ODS document made in Libreoffice, they are putting style:text-rotation-angle in the table-cell-properties element. CLODS is putting the angle parameter on style:text-properties. As a result, rotation isn't working.
I can't get the columns to use optimal width, I'm not sure if I'm using :use-optimal-width t
correctly because it wasn't used in the example.lisp
mentioned in the README file, here's a quick test example:
(let ((text-props-normal '(:color "#000000" :font-name "Libration Sans" :font-size "10pt" :font-weight :bold)))
(clods:with-spreadsheet ("test.ods"
:generator "tester"
:creator "tester")
(clods:using-fonts ()
(clods:font "Liberation Sans" :family "Liberation Sans"))
(clods:using-styles ()
;; number formats
(clods:number-text-style "n-text")
;; cell styles
(clods:cell-style "ce-normal" nil text-props-normal :data-style "n-text")
;; column styles
(clods:column-style "co-normal" nil :use-optimal-width t)
;; row styles
(clods:row-style "ro-normal" nil))
(clods:with-body ()
(clods:with-table ("TEST")
(clods:with-header-columns ()
(clods:column :style "co-normal" :cell-style "ce-normal"))
(clods:with-header-rows ()
(clods:with-row (:style "ro-normal")
(clods:cell "Long long long long long text")))))))
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.