[Qt-interest] How to construct excel tables

[Jeffrey Brendecke]

OpenOffice calc .ods files are zip packages with resources largely in XML.

This means, as opposed to Excel, that you can create and manipulate documents 
by starting with initial files and using string or XML processessing 
operations, zip the thing back together with a .ods extension and voila! You 
have an usable .ods file! You don't need any special components for it as 
with Excel and you don't even need OpenOffice on the system! The only things 
to watch out for are: (1) OpenOffice doesn't seem to like line endings in the 
XML and (2) adhere to the prescribed schema.

By visually creating templates in OpenOffice itself and referencing styles in 
created documents, you can avoid a lot of the headaches of trying to do that 
in code.

Qt has functionality built in that should help make it easy to manipulate the 
component documents, so you can concentrate your code on the core stuff while 
leaving the design issues to someone else.

--------------------
Date: Wednesday 27 January 2010 22:41
From: Enrique Cuesta <enriquecues at gmail.com>
To: berkan kısaoğlu <berkankisaoglu at gmail.com>
Cc: qt-interest at trolltech.com
Subject: Re: [Qt-interest] How to construct excel tables
--------------------

> ActiveQt is the way to go. (it's just and ActiveX warp...)
> but... Excel must be installed in your system...
>
> if you want to read and write excel files withouth Excel installed in
> your system... that's pretty much Much much complicated...
> You should see how OpenOffice archieved that....
>
> 2010/1/27 berkan kısaoğlu <berkankisaoglu at gmail.com>:
> > Is there a way to construct excel tables with xls/xlsx/ods file
> > extensions. Also i want these tables to be formetted with some
> > color/borders etc. I cannot find anything. Maybe you could suggest some
> > other external libraries to use with QT.
> >
> > Thanks in advance.
> >
> > _______________________________________________
> > Qt-interest mailing list
> > Qt-interest at trolltech.com
> > http://lists.trolltech.com/mailman/listinfo/qt-interest
>
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest