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 [cid:[email protected]] 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]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[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]<mailto:[email protected]> ------ Original Message ------ >From "'Karen Tellef' via RBASE-L" ><[email protected]<mailto:[email protected]>> To "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> <[email protected]<mailto:[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]<mailto:[email protected]> ------ Original Message ------ >From "'Karen Tellef' via RBASE-L" ><[email protected]<mailto:[email protected]>> To "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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.
