Re: Convert query output to MS Excel

Maybe there are more sophisticated products but I've found that the standard Unix (AIX 4.1) tools do the job pretty well. I just use a shell script that unloads the query results to a temp file. Then I use awk to create an HTML table from the data. That table appears in the web browser and a user can look at it, print it or cut and paste it to Excel or Word.
There are queries that simply last too long. In that cases I use another approach. The shell script that proceses the HTML form schedules an at job to be executed at night (in order to avoid performance degradation people that use those reports agreed to receive the results the day after). Again, the at job does an unload using commas as field separators. The data is saved in a temp file with .csv extension. The file is then converted using uuencode and attached to a mail message. Excel does the .csv -> .xls conversion automatically when the user opens the attachment.

-----Original Message-----
From: Alexey Pushkin <A.Pushkin_at_mitsunari.matfys.lth.se> To: informix-list_at_iiug.org <informix-list_at_iiug.org> Date: Lunes 23 de Marzo de 1998 19:12
Subject: Q: Convert query output to MS Excel

>Could anyone recommend a good product for
>converting query output to MS Excel and/or Word on the fly.
>(For a web application).
>
>Thanks.
>
Received on Tue Mar 24 1998 - 00:00:00 CET