Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 3721 invoked by uid 500); 23 Jul 2002 18:51:34 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 3710 invoked from network); 23 Jul 2002 18:51:33 -0000 To: cocoon-users@xml.apache.org X-Injected-Via-Gmane: http://gmane.org/ Path: not-for-mail From: Sven Kuenzler Newsgroups: gmane.text.xml.cocoon.user Subject: Re: Excel generator Date: Tue, 23 Jul 2002 20:52:26 +0200 Lines: 230 Message-ID: <3D3DA5EA.1010103@imost.de> References: <3D3D8FC0.5010909@apache.org> NNTP-Posting-Host: p508664cc.dip0.t-ipconnect.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: main.gmane.org 1027450278 10645 80.134.100.204 (23 Jul 2002 18:51:18 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Tue, 23 Jul 2002 18:51:18 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; de-AT; rv:1.0.0) Gecko/20020530 X-Accept-Language: de, de-at, en-us, en Sender: news X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I'd also prefer the Gnumeric format. That's because it's open source, it's used by other oss project(s) and there are people maintaining documentation for it. So, keeping this format would create some kind of open source synergy. Plus, it would not break apps which depend on the serializer already. Sven Koen Pellegrims schrieb: > Personally, I think it makes most sense to use the Gnumeric format. Granted, > it is not the easiest format, but it allows you to express most anything you > have in your stylesheet. > I think that -at least in theory- the Generator, followed by the Serializer > should give you the same worksheet back... > > IMHO it makes more sense to get aquinted well with one format (Gnumeric), > rather than constantly swapping between two different formats. > > If we were to invent a new representation, it would probably come very close > to the Gnumeric format anyway... > > Koen. > > >>-----Oorspronkelijk bericht----- >>Van: Andrew C. Oliver [mailto:acoliver@apache.org] >>Verzonden: dinsdag 23 juli 2002 19:18 >>Aan: cocoon-users@xml.apache.org; Marc Johnson >>Onderwerp: Re: Excel generator >> >> >>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:acoliver@apache.org] >>>>Sent: Tuesday, July 23, 2002 9:57 AM >>>>To: cocoon-users@xml.apache.org >>>>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. >>>>> >>>>> >>>> >>>> >>>> >>>> >>>>>To unsubscribe, e-mail: >>>>> >>>>> >>>> >>>> >>>> >>>> >>>>>For additional commands, e-mail: >>>>> >>>>> >>>> >>>> >>>> >>>> >>>>> >>>> >>>>--------------------------------------------------------------------- >>>>Please check that your question has not already been answered in the >>>>FAQ before posting. >>>> >>>>To unsubscribe, e-mail: >>>>For additional commands, e-mail: >>>> >>>> >>>> >>>--------------------------------------------------------------------- >>>Please check that your question has not already been answered in the >>>FAQ before posting. >>> >>>To unsubscribe, e-mail: >>>For additional commands, e-mail: >>> >>> >>> >>> >> >> >> >>--------------------------------------------------------------------- >>Please check that your question has not already been answered in the >>FAQ before posting. >> >>To unsubscribe, e-mail: >>For additional commands, e-mail: >> >> > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. > > To unsubscribe, e-mail: > For additional commands, e-mail: > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: