Re: Automating Quary -> File -> Excel

<verndor response>

Allow me to second my boss' reply - our RPG2SQL product isn't free, of course. You do have complete control of the look and feel of the spreadsheet - you can do anything from RPG that you can do with an instance of Excel on a middleware PC that we use. A command is included to export any PF or single-format LF to a spreadsheet. It formats columns according to data type in the PF/LF (those leading zeroes in text fields are preserved!) and autofits column widths as well as can be done automatically, using built-in Excel functionality.

Free 30-day evaluations are always available. Contact me or Rich or Sales if this sounds interesting. The product also lets you work with SQL-based DBMS from RPG directly, in real-time.

</verndor response>

On 9/29/2010 1:23 PM, Nick_Radich@xxxxxxxxxxxxxx wrote:

Hi Bob,

We use Kemetech's CVTDBFXLS tool for creating spreadsheets from Physical
Files.

Create a CL program to:
1) Run the Query
2) Use CVTDBFXLS to create a spreadsheet, or use one of Scott
Klement's tools to create the spreadsheet
3) You can not 'Prettify' the spreadsheet automatically
4) We use the SNDM command to email the spreadsheet. I found this
free on the internet.

HTH.




Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



From: "Bob Voltz"<bob.voltz@xxxxxxxxxx>
To:<midrange-l@xxxxxxxxxxxx>
Date: 09/29/2010 01:08 PM
Subject: Automating Quary -> File -> Excel
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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?