×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Search the archives for Scott Klement and excel. There's plenty of examples on creating the excel file on the IFS. Then you can use the SNDM (if available) to email the file as an attachment.
Personally, I use the CGIDEV2 stuff to create an HTML table, then use WrtHTMLToSTMF with an extension of xls then email it to the user. When they open the file, it opens excel and formats the table cells in the excel cells.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Voltz
Sent: Wednesday, September 29, 2010 1:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Automating Quary -> File -> Excel
Once a month I do the following:
1. Run a query to create a file.
2. Import that file into Excel.
3. Prettify the spreadsheet.
4. Email the prettified spreadsheet to a user.
What is the best way to automate this process?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
