It would appear that LAUNCH and Powershell are your friends, here.
B
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From "'Karen Tellef' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 3/16/2023 1:14:31 PM
Subject Re: Re[2]: [RBASE-L] - Printing spreadsheets
I guess I needed to be more clear. This is a random existing
spreadsheet, has nothing to do with RBase at all
Karen
-----Original Message-----
From: 'Jim Belisle' via RBASE-L <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Mar 16, 2023 2:10 pm
Subject: RE: Re[2]: [RBASE-L] - Printing spreadsheets
Karen,
Try this.
GATEWAY EXPORT XLSW +
.. set up location of your file here ….xlsx +
SELECT * FROM (table you created with the info) +
OPTION COL_NAMES ON +
|SHEET_INDEX 1 +
|RAW_GEN ON +
|BLANK_IF_NULL ON +
|BLANK_IF_ZERO OFF +
|SHOW_PROGRESS ON +
|MERGE_DATA ON +
|TAB_NAME ( name of tab in the workbook)
This overwrites the info in the tab you are pointing to.
I use this to add info to multiple tabs in one Excel book.
James Belisle
Making Information Systems People Friendly Since 1990
From: 'Karen Tellef' via RBASE-L <[email protected]>
Sent: Thursday, March 16, 2023 1:18 PM
To:[email protected]
Subject: Re: Re[2]: [RBASE-L] - Printing spreadsheets
CAUTION:This is an EXTERNAL EMAIL, STOP! and think before clicking on
any links or opening attachments.
This is an already existing spreadsheet, not printing a report to a
spreadsheet format
Karen
-----Original Message-----
From: Bruce Chitiea <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Mar 16, 2023 1:15 pm
Subject: Re[2]: [RBASE-L] - Printing spreadsheets
Have you considered:
PRINT reportname ARRANGE clause WHERE clause .. ORDER BY clause ..
OPTION XLSX
(from RSyntax)
Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From "'Karen Tellef' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 3/16/2023 11:11:51 AM
Subject Re: [RBASE-L] - Printing spreadsheets
This will be a "batch" operation so we wouldn't want to launch them
all right away. He claims it's "not a big deal unless it's easy to
print them".
I tried your first link, but get a "page not found"
One place to explore solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcommand-line-switches-for-microsoft-office-products&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=oUPA%2FN8l7DoDkilKLEqtVuvfxjt5is7qruAifYEEQMo%3D&reserved=0>
Karen
-----Original Message-----
From: Bruce Chitiea <[email protected]>
To: [email protected] <[email protected]>
Sent: Thu, Mar 16, 2023 1:08 pm
Subject: Re: [RBASE-L] - Printing spreadsheets
Karen:
Just riffin' here.
LAUNCH excel.exe gets you part of the way there, maybe
One place to explore solution:
https://support.microsoft.com/en-us/office/command-line-switches-for-microsoft-office-products
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcommand-line-switches-for-microsoft-office-products&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=oUPA%2FN8l7DoDkilKLEqtVuvfxjt5is7qruAifYEEQMo%3D&reserved=0>
Another possible source:
www.windows-commandline.com/run-command-for-excel/
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.windows-commandline.com%2Frun-command-for-excel%2F&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PM%2BYUi%2BvA8ISn%2FvWvEtM3QZyf3zZoDyLJiAnP0I4pIs%3D&reserved=0>
In the end PowerShell may be the solution.
Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From "'Karen Tellef' via RBASE-L" <[email protected]>
To "[email protected]" <[email protected]>
Date 3/16/2023 10:38:20 AM
Subject [RBASE-L] - Printing spreadsheets
I've never been asked to do this before, and I have nothing in my
voluminous notes....
Can you print an Excel spreadsheet (xlsx) from within your RBase app?
Karen
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Hr%2FJ3ceFACSyDPecugdfSawTKYDDlh8hvly1NU8d2NM%3D&reserved=0>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1537336721.947201.1678988300047%40mail.yahoo.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F1537336721.947201.1678988300047%2540mail.yahoo.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DLcDIii9FIfSs%2Bd8MWCl6KBuvI1Hd1CNW6Vjq%2FD2dB8%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Hr%2FJ3ceFACSyDPecugdfSawTKYDDlh8hvly1NU8d2NM%3D&reserved=0>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emacbf23ed-229c-4899-90df-4b055721892c%40a91e6852.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Femacbf23ed-229c-4899-90df-4b055721892c%2540a91e6852.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=lQlrhoAwl8PMxx2pns7%2BiS9VgOwT%2BfOFTlBOnpB9RoI%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044548355%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Hr%2FJ3ceFACSyDPecugdfSawTKYDDlh8hvly1NU8d2NM%3D&reserved=0>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/618413864.106307.1678990311876%40mail.yahoo.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F618413864.106307.1678990311876%2540mail.yahoo.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044704551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=wlGwMAzeITrU38ErYaZ3LmZkBuXP4wsFJBr6Xx5Hv28%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044704551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=fEJwq4NHQL0s9DwGMgwPpMg5BIg1aOncDNAH4Ycva1c%3D&reserved=0>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em237796d7-7920-434d-a805-54da45a0b190%40a91e6852.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2Fem237796d7-7920-434d-a805-54da45a0b190%2540a91e6852.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044704551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=j7I1LQfPNnVxsWWpqmKTg%2FrhAHj8buzGDjs8VfAJsuA%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rbase.com%2Fsupport%2Fusersgroup_guidelines.php&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044704551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=fEJwq4NHQL0s9DwGMgwPpMg5BIg1aOncDNAH4Ycva1c%3D&reserved=0>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2002970857.945404.1678990697251%40mail.yahoo.com
<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Frbase-l%2F2002970857.945404.1678990697251%2540mail.yahoo.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cjim%40kaypark.com%7C64a5f0da25944c76363b08db264ad34b%7Cb1d6481668ef495ea1453b4a98d6a532%7C1%7C0%7C638145875044704551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=E0%2BlJCkLgOSn4Q5jRKei65y3elWkFlhQq3JsiS%2BCSaM%3D&reserved=0>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/IA1PR02MB8898A533605C11E46DFE637EA0BC9%40IA1PR02MB8898.namprd02.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/IA1PR02MB8898A533605C11E46DFE637EA0BC9%40IA1PR02MB8898.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1571449144.1014704.1678997671292%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/1571449144.1014704.1678997671292%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em345e156d-b6f5-4f7a-83cf-fbde5f372a09%408d4690e5.com.
