Midrange News for the IBM i Community


Posted by: Viking
Information Systems
CA
Spoolfile to Excel
has no ratings.
Published: 06 Aug 2013
Revised: 16 Aug 2013 - 3906 days ago
Last viewed on: 26 Apr 2024 (4762 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Spoolfile to Excel Published by: Viking on 06 Aug 2013 view comments(7)

Hi all,

I know there are several software products that claim to convert spoolfiles to Excel.  I'm interested in your feedback/experience/pros and cons with these products which will help me pick the best one for my environment.

So, what do you have and are you happy with it?

Thanks!

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 20 days 22 hours 22 minutes ago

I'm sure most do what you need them to do. If you don't have one, you need to decide what it is you're going to do.

  • Copy to CSV?
  • Copy to legacy/standard Excel?
  • Copy to a multi-worksheet Excel?

Any of these are possible today with the various tools out there.

If you are copying only to CSV, the cozTools CPYTOCSV command support Excel functions such as column totals, date conversion, numeric to text conversion, and several others. But it does NOT do multi-worksheet Excel.

The "big" 3rd-Party SQL product does a lot of stuff when it comes to multiple formats.

Those are the only two that I've personally used.

 

 

Posted by: Viking
Premium member *
CA
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 20 days 21 hours 19 minutes ago

CPYTOCSV converts a database file to csv, correct...?  I need something to convert spoolfiles to Excel.

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 20 days 19 hours 49 minutes ago

Oh, so you expect me to read the Subject on your messages to get the context, huh?  LOL!

Well, I think that Sequel thing does just that, so my answer is still valid.

Posted by: Viking
Premium member *
CA
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 20 days 19 hours 24 minutes ago

The subject, or the actual post, yes! 

Sequel will convert a pre-existing spoolfile to Excel...?  (see what I did there?  I sneaked in "pre-existing" without you noticing even though I left that out from my original post!)

This one seems pretty nifty:

http://www.ariadnesoftware.co.uk/CoolSpoolsSpoolConverter.htm

 

Posted by: bobcozzi
Site Admin ****
Chicagoland
www.cozTools.com/qryfile
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 18 days 23 hours 58 minutes ago

I sure "wish" we could write directly to CSV and hence Excel using a Report redirect/override. That would be cool.

Posted by: Viking
Premium member *
CA
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 18 days 22 hours 56 minutes ago

  I have some RPGs that write straight to csv files on the IFS which users then open in Excel and it works great.  Unfortunately, I also have a bunch of ancient programs that create only printed output, and quickly getting those into Excel after the fact without changing the programs is the current need.  There seem to be a few decent options for this.

Posted by: Paulster
Premium member *
Sweden and The Netherlands
Comment on: Spoolfile to Excel
Posted: 10 years 8 months 11 days 12 hours 41 minutes ago

Wrote a CMD/CLLE thingie long time ago that converts a PF/Table to a .csv in the IFS where I mail it out to who ever ordered it. There's certainly enough stuff out there to buy but the budget dictates what can be done. Also, you may not want to pay for all the bells and whistles you don't need. Straight conversion is what we need and that is what we got, at low cost.