Typically if there is a report that they want in excel format, we will write out a flat file that either can be imported into excel or a csv file. This avoids all the headers on each page to go through and remove, etc.

There are some pc tools out there that you can take a report and do such but my mind is blank. And the one even will do it from pdfs of a report.

Of course yes we do occasionally go and "copyprt" off a report to a flat file and sometimes will go and remove all the blank lines, headers, etc.

chris

There are 3rd party products that do this, though I've never used one of these tools. I believe they involve mapping - you tell it what columns have what fields, and so forth. Presumably they're using the QSP* API's to read the contents directly, or possibly just CPYSPLF and then processing the file contents.

Before doing a CPYSPLF and then reading the resulting file, I'd consider changing the program that produces the report to create a *STMF instead (or in addition), then send the *STMF as an e-mail attachment. CSV is generally good enough for the content, though I've also toyed with open source Java that can create and edit Excel files. Depends on how fancy you need to get.

Take a look at DRV's Spoolflex. I've used this in the past and it's a slick product to convert reports to excel, pdf, email, or many other options.

I've got another client who uses Web Query, so maybe I'll use that opportunity to learn Web Query and just use it with my previous client.

I also use Spoolflex, very flexable.  You can convert the report to xls, pdf, csv, html, txt, rft, ect. You can send to single receipent, the person who created the report or you can set up groups

We convert spool files to HTML, PDF, TIFF, or plain text files.  We do not waste time trying to reverse engineer for the purpose of creating a data file that we can work with.  Besides, many of our reports contain overrides that would be lost.  Spool files are treated like an "image file" here and we do not change them...even though we "could" if we really wanted to.

We convert data files (PF) to CSV, HTML tables, or XLS.

However, it sounds more like you are wanting to create an XLS from query results.  We use ASC Sequel here and it allows an XLS to be created.