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
