I'm afraid you're correct on the formulas. But, back in the days, when I was programming in Visual Basic, I wrote a "script calculator". That calculator loaded a simple text script that contained Visual Basic code. It then executed the code, and showed the result. I had to use a DLL for that, a scripting dll that came from Internet Explorer, and that was using a Java function, called evaluate. With evaluate, I was able to calculate things that were in pure string format. Eg. "a=1 ; b=2; c = a + b;" -> evaluate "c" would have given me "3" and not "a + b".
I have a small background in Java, but can't this be used ?? -----Original Message----- From: Joerg Heinicke [mailto:[EMAIL PROTECTED] Sent: vrijdag 9 januari 2004 0:38 To: [EMAIL PROTECTED] Subject: Re: Excel Generator On 08.01.2004 22:53, Yves Vindevogel wrote: > What if we start from this ?? > http://www.onjava.com/pub/a/onjava/2003/01/22/poi.html > http://www.onjava.com/pub/a/onjava/2003/04/16/poi_excel.html Why not, we can later go on to output Gnumeric file format. A start is always important. > To be honest, I do not require the formulas in the Excel file. AFAIK only the formulas are stored in the file, not their result. > I need the results of the cells. > > And output like: > <Workbook file="AZERTY"> > <Sheet name="QSDFGH"> > <A><A1>MyName</A1><A2>Something Else</A2></A> > <B><B1>.... > </Sheet> > </Workbook> > > I'm willing to contribute on it, and I have a developer at hands who can > spend time at it. I willing to give him 3 days (tomorrow friday and two > days in his weekend off ;-)) to produce something .... What a poor guy! ;-) Joerg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
