On Tue, 2002-02-26 at 14:14, Iouri Michtchenko wrote:
> Hello,
> I am developing an application for exporting/importing data from/into a
> database
> by means of MS Excel files. To do that I convert an Excel file into an XML
> (I wrote a generator
> wich gives me 'gmr:' like file), then I use XSLT + another tool (like
> XML_DBMS, or Oracle XSU) to load
If you're interested in donating the generator let me know.
> data into the database. To import data into Excel I generate XML from a SQL
> query and
> then serialize the result by means of POI. At this point I use Oracle XSQL
> to produce XML and
> I wrote a serializer for it (it is just a wrapper class for HSSFSerializer).
> But I needed support for cell formating (font, colors),so I rewrote some
> classes in "net.sourceforge.poi.xml.hssf" package to handle
Font and colors are handled in the last development release of the
serializer.
> some new attributes of 'gmr:Cell' element. I did that because we needed
> something and it was very urgent.
> But now we see that we'll need support for creating Excel files containing
> formulas. As I see you have done
> a lot and it's almost ready. I can even use existing classes and start
> create my own implementation...
Umm...no its not.
> So could you tell me in what state the framework for formulas is? Does it
> take some days, weeks, years to make
> it available?
>
weeks to months. Late April/Early May for a release edition.
If you'd like it faster, perhaps you should consider collaborating with
Marc Johnson on the poi-dev list in creating this feature. Rather than
have to make changes yourself and redo them as the codebase changes, why
not work to get them in?
To All: There is plenty of work for anyone who wants it. Just ask. :-)
> Thanks in advance,
> Iouri.
>
>
-Andy
--
http://www.superlinksoftware.com
http://jakarta.apache.org - port of Excel/Word/OLE 2 Compound Document
format to java
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
- fix java generics!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh