Geoff Howard wrote: >Well, I'll make a stab at what I would think could be useful for a generator >from an excel file. I can think of two logical directions people would want >to go. > >1) If you are serializing to some display format (html, pdf, etc) you'd want >to reproduce the data and formatting as it would appear viewed in, or >printed from excel. > You can of course do an approximation of this in any format via a stylesheet. Granted it won't look *eactly* the same due to differences (HTML borders are vastly different from Excel's).
>2) If you are using excel as a make-shift database, you would want to >preserve the data structure so that it can be transformed and acted on or >displayed. > > Yes. >I would assume that both of these uses could be accomplished by just >outputting the format that would have created the same style sheet to begin >with, except possibly for the option to output formula results instead of >the formulas. Most users would assume the formats and behaviour to be close >to symetric - if start with an .xls file, run it through the generator and >serializer, I ought to wind up pretty close to where I started if not >exactly where I started. > > great. >Does that work for a discussion starter? > > Yes so the question I guess is assuming you can transform it via XSLT to whatever you like given the effort. What format (XML tag format) makes most since? Preserving the gnumeric compatibility? A custom format that makes more sense? Striving for Excel 2000 XML format compatibility? Currently the serializer shares the gnumeric tag language. -Andy >Geoff > > > >>-----Original Message----- >>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, July 23, 2002 9:57 AM >>To: [EMAIL PROTECTED] >>Subject: Re: Excel generator >> >> >>But the more important part of my answer was "What do you >>want on your >>generator, and >>what do you wish you had on your serializer -- would you like fries >>too?" Meaning I need ideas! >>I'm on the fence, I want some input. >> >>-Andy >> >>Sven Kuenzler wrote: >> >> >> >>>>Is there an Excel Generator, which creates *from* an Excel >>>> >>>> >>(xls) file >> >> >>>>some XML? Or what approach would you take to convert existing Excel >>>>documents into some useful XML? >>>> >>>> >>>I think the previous responses missed the *from* (my emphasis) :-) >>>So, read Andy's answer on the dev list. In short: No, there is no >>>HSSFGenerator (yet). >>> >>> Sven >>> >>> >>> >>> >>> >>> >>> >>--------------------------------------------------------------------- >> >> >>>Please check that your question has not already been >>> >>> >>answered in the >> >> >>>FAQ before posting. >>> >>> >><http://xml.apache.org/cocoon/faq/index.html> >> >> >>>To unsubscribe, e-mail: >>> >>> >><[EMAIL PROTECTED]> >> >> >>>For additional commands, e-mail: >>> >>> >><[EMAIL PROTECTED]> >> >> >>> >>> >> >> >>--------------------------------------------------------------------- >>Please check that your question has not already been answered in the >>FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> >> >>To unsubscribe, e-mail: <[EMAIL PROTECTED]> >>For additional commands, e-mail: <[EMAIL PROTECTED]> >> >> >> > >--------------------------------------------------------------------- >Please check that your question has not already been answered in the >FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > >To unsubscribe, e-mail: <[EMAIL PROTECTED]> >For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
