Want to prepare some reports(with font styles / formatting) in excel format from Lazarus? Is it possible?
Newer Excel (I don't remember from what exact version), have their own
*XML* syntax:
http://www.microsoft.com/office/xml/default.mspx
And it seems that Microsoft try to make it even a standard format :)
Ido
On 9/22/06, Jonathan Chiu [EMAIL PROTECTED] wrote:
Want to prepare some reports(with
There are two ways to do this.
1. Create an OLE object and automate Excell from the application
2. Create a reader/writer to the MS Excell file format
Obviously #1is more simple and faster to implement, although it will only
work on the Windows platform.
Darius
Want to prepare some
I forgot to mention a third possibility. You can also output the data into
some commonly known format like CSV from lazarus. As a second step you
should make a maco in excell that reads this datafile and puts the
corresponding items into the proper cells.
This method is cross platform compatible
I create an html file, tables and embedded css, and save it with the xls extension. Even with formulas.Office 2000+, OpenOffice and Gnumericcanopen thisfilesvery well.Gustavo
2006/9/22, [EMAIL PROTECTED] [EMAIL PROTECTED]:
There are two ways to do this.1. Create an OLE object and automate Excell
Excuse my english.
I create an html file, tables and embedded css, and save it with the xls extension. Even with formulas.Office 2000+, OpenOffice and Gnumericcanopen thisfilesvery well.You can go further connecting your xls file with a cgi app in a web server. I do this to dinamically fill cells
On Friday 22 September 2006 14:13, [EMAIL PROTECTED] wrote:
There are two ways to do this.
1. Create an OLE object and automate Excell from the application
2. Create a reader/writer to the MS Excell file format
Obviously #1is more simple and faster to implement, although it will only
work