Re: Convert query output to MS Excel
Posted in 1998
Topics: General Discussion
Try Discoverer 2000 In article <01bd59c5$763ed2e0$386710ac@jrinck.phcs.com>, "A. J. Narvaez" <nnn@mindspring.com> wrote: > > I don't know of any product that will do exactly what you need. An > alternate solution might be to produce a formatted text file in csv (comma > seperated) format. or some other well known format. > > If you have the spec for the Excel file format you could always write a > program/script to generate that format, but aside from formatting you'd > have to contend with endian problems when converting non-ascii fields. > > Perhaps some reporting software like SQR supports the data format you need? > > Or else there may be some software to generate RTF files. Its worth seeing > if there are any Perl modules that will generate Word or Excel format. If > so then along with module, use Sybperl to create a script that should > satisfy your needs. > > -Arthur > > Alexey Pushkin <A.Pushkin@mitsunari.matfys.lth.se> wrote in article > <351A71FA.231EFBC1@mitsunari.matfys.lth.se>... > > > > > > >Could anyone recommend a good product for > > > >converting query output to MS Excel and/or Word on the fly. > > > >(For a web application). > > > > > > > I am not sure if this is what you want. > > > > > > Do you want to get the query output on the Excel or do you want it on > > > the Web. > > > > What we need is that a customer sets query parameters in a web page, > > presses "submit" and gets a ready Excel file for download. We do not > > need HTML output. > > > > In fact I have already found one tool for that but if you know > > about others it's interesting. > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading