: RE: systools.generate_spreadsheet

Just to add my 2 cents ... who knows what else you'll find here:

http://ibmireference.blogspot.com/p/ibm-i-freeware-shareware.html


Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
IBM i Personal Blog: https://ibmireference.blogspot.com/
"Success is not final. Failure is not fatal. It is the courage to continue that counts".









1. RE: systools.generate_spreadsheet
(VERNON HAMBERG Owner via MIDRANGE-L)

3. Re: systools.generate_spreadsheet (Peter Dow)



----------------------------------------------------------------------

message: 1
date: Wed, 28 Feb 2024 08:36:40 -0800
from: VERNON HAMBERG Owner via MIDRANGE-L
<midrange-l@xxxxxxxxxxxxxxxxxx>
subject: RE: systools.generate_spreadsheet

Hi Greg


We've also used SQL2XLS for years - I thought I'd heard there is an XLSX version, in fact, I think Giuseppe published something. Can you tell us where you acquired it?


Regards
Vern


On Wed, 28 Feb, 2024 at 9:51 AM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:


To: midrange systems technical discussion

I'll vote for that...

I have used something called SQL2XLS (now SQL2XLSX) for probably 20 years (from Giuseppe Costagliola) It allows you to do that (and other things). It just doesn't do CSV.

Greg

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Bryan Dietz
Sent: Wednesday, February 28, 2024 10:16 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: systools.generate_spreadsheet

maybe this would be good to vote on:
"Using SYSTOOLS.GENERATE_SPREADSHEET to export data to excel, using an existing excel template."
https://ibm-power-systems.ideas.ibm.com/ideas/IBMI-I-3911

Bryan

Greg Wilburn wrote on 2/28/2024 8:57 AM:

Thanks Gerald... I have it working in an RPG program (but I'm calling it).
I did not test this running under a standard user profile... I may run into issues given our exit point security software.

I think it's a nice addition to my toolbag, but... you lose a lot of granularities.
I have many RPG programs that use IFS tools I created to write data "row-by-row". Like you said, I can control the "column headers", delimiter, etc.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

.

------------------------------

message: 3
date: Wed, 28 Feb 2024 09:09:44 -0800
from: Peter Dow <petercdow@xxxxxxxxx>
subject: Re: systools.generate_spreadsheet

Giuseppe also has SQL2CSV and SQL2XML.

https://www.mcpressonline.com/programming/sql/techtip-sql2csv-and-sql2xml

Actually, there are several versions of SQL2CSV (google SQL2CSV) out there, one for .net, another written in python.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /


On 2/28/2024 7:50 AM, Greg Wilburn wrote:

I'll vote for that...

I have used something called SQL2XLS (now SQL2XLSX) for probably 20
years (from Giuseppe Costagliola) It allows you to do that (and other things). It just doesn't do CSV.

Greg

-----Original Message-----
From: MIDRANGE-L<midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Bryan Dietz
Sent: Wednesday, February 28, 2024 10:16 AM
To:midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: systools.generate_spreadsheet

maybe this would be good to vote on:
"Using SYSTOOLS.GENERATE_SPREADSHEET to export data to excel, using an existing excel template."
https://ibm-/
power-systems.ideas.ibm.com%2Fideas%2FIBMI-I-3911&data=05%7C02%7Cmicha
el.mayer%40ermco-eci.com%7C40a19c604a5a42f9c65808dc38871f36%7Cd2deeaf2
70e4425c91d7d99d784e89d6%7C0%7C0%7C638447400256083947%7CUnknown%7CTWFp
bGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn
0%3D%7C0%7C%7C%7C&sdata=mn37AKEQqk0wmZU4ohxP%2BSTMKOWvSwhmEgTCpcHaamA%
3D&reserved=0

Bryan

Greg Wilburn wrote on 2/28/2024 8:57 AM:

Thanks Gerald... I have it working in an RPG program (but I'm calling it).
I did not test this running under a standard user profile... I may run into issues given our exit point security software.

I think it's a nice addition to my toolbag, but... you lose a lot of granularities.
I have many RPG programs that use IFS tools I created to write data "row-by-row". Like you said, I can control the "column headers", delimiter, etc.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email:MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%25
2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=05%7C02%7C
michael.mayer%40ermco-eci.com%7C40a19c604a5a42f9c65808dc38871f36%7Cd2d
eeaf270e4425c91d7d99d784e89d6%7C0%7C0%7C638447400256089804%7CUnknown%7
CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXV
CI6Mn0%3D%7C0%7C%7C%7C&sdata=pEvpYtDqWprv7qUqhUQbMPsiSKTZgfqYHvt1jZmKh
TI%3D&reserved=0 or email:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

------------------------------