Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
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.
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 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
