Closed Joe-Barry closed 10 months ago
No, that is not possible. And I will never change this plugin. You do realize that this plugin is created for APEX 4.0.2? APEX has improved since then. If you need the data from a report region I would advise to use either the "download as Excel"-functionality or apex_region.data_export function.
Anton - thanks for the reply.
We highly value the plug-in for its multi-sheet capability into a single true workbook .xlsx despite it being 5 years old. It is still remarkably close to the base requirement for us, indeed.
We will see if we can loop or otherwise accommodate a single true xlsx workbook from many regions-of-a-page. I seem to have learned too that the .xml templates(?) that go into a true .xlsx workbook may be subject to flux as well.
Thank You,
Joseph Barry
From: Anton Scheffer @.> Sent: Monday, December 4, 2023 3:57 PM To: antonscheffer/APEX2XLSX @.> Cc: Barry, Joseph @.>; Author @.> Subject: Re: [antonscheffer/APEX2XLSX] Is it possible to set worksheet name(s) in the resulting workbook to be IR region name(s) ? (Issue #6)
CAUTION: This message came from an external source. DO NOT click on links or open attachments unless you trust the sender.
No, that is not possible. And I will never change this plugin. You do realize that this plugin is created for APEX 4.0.2? APEX has improved since then. If you need the data from a report region I would advise to use either the "download as Excel"-functionality or apex_region.data_export function.
- Reply to this email directly, view it on GitHubhttps://github.com/antonscheffer/APEX2XLSX/issues/6#issuecomment-1839462939, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BEOVZ62ODGM2ZCH4FESVDGLYHY2IZAVCNFSM6AAAAABAGQS6EGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZZGQ3DEOJTHE. You are receiving this because you authored the thread.Message ID: @.**@.>>
savantagesolutions
TRANSFORMING CLIENTS' VISION INTO RESULTS
CMMI-DEV Level 3http://www.savantage.net/press_releases?pr_item=66| ISO 9001:2015http://www.savantage.net/press_releases?pr_item=72
The information in this email may be confidential. Regardless of whether the email contains confidential information, the email is a private communication intended solely for the addressee(s). Access to this email by anyone else is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Please notify the sender of the delivery error by replying to this message, and then delete it from your system.
I would suggest using as_xlsx to create a xlsx with multiple sheets in combination with some APEX packages: looping report regions, use apex_region.open_query_context looping the data of that context with apex_exec.next__row to_get all rows looping the row with apexexec.get... to get all the data cell values
Anton - ok.
Risk-free : does as_xlsx operate without creating directories ? Can we maintain a blob in the APEX session somwhow without writing that out? We're anti-directory at this point if we can avoid that additional complexity.
Thank You,
Joseph Barry
From: Anton Scheffer @.> Sent: Monday, December 4, 2023 4:50 PM To: antonscheffer/APEX2XLSX @.> Cc: Barry, Joseph @.>; Author @.> Subject: Re: [antonscheffer/APEX2XLSX] Is it possible to set worksheet name(s) in the resulting workbook to be IR region name(s) ? (Issue #6)
CAUTION: This message came from an external source. DO NOT click on links or open attachments unless you trust the sender.
I would suggest using as_xlsx to create a xlsx with multiple sheets in combination with some APEX packages: looping report regions, use apex_region.open_query_context looping the data of that context with apex_exec.next__row to_get all rows looping the row with apexexec.get... to get all the data cell values
- Reply to this email directly, view it on GitHubhttps://github.com/antonscheffer/APEX2XLSX/issues/6#issuecomment-1839541107, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BEOVZ66F55CXZJHOZYS3QZ3YHZASJAVCNFSM6AAAAABAGQS6EGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZZGU2DCMJQG4. You are receiving this because you authored the thread.Message ID: @.**@.>>
savantagesolutions
TRANSFORMING CLIENTS' VISION INTO RESULTS
CMMI-DEV Level 3http://www.savantage.net/press_releases?pr_item=66| ISO 9001:2015http://www.savantage.net/press_releases?pr_item=72
The information in this email may be confidential. Regardless of whether the email contains confidential information, the email is a private communication intended solely for the addressee(s). Access to this email by anyone else is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Please notify the sender of the delivery error by replying to this message, and then delete it from your system.
PS we are aiming for pure session until a download of an xlsx ( or zip) ; no worries. It's an honor to get a reply from you. All the best.
Thank You,
Joseph Barry
From: Barry, Joseph Sent: Monday, December 4, 2023 5:50 PM To: antonscheffer/APEX2XLSX @.>; antonscheffer/APEX2XLSX @.> Cc: Author @.>; Surya, Lydia CTR @.> Subject: RE: [antonscheffer/APEX2XLSX] Is it possible to set worksheet name(s) in the resulting workbook to be IR region name(s) ? (Issue #6)
Anton - ok.
Risk-free : does as_xlsx operate without creating directories ? Can we maintain a blob in the APEX session somwhow without writing that out? We're anti-directory at this point if we can avoid that additional complexity.
Thank You,
Joseph Barry
From: Anton Scheffer @.**@.>> Sent: Monday, December 4, 2023 4:50 PM To: antonscheffer/APEX2XLSX @.**@.>> Cc: Barry, Joseph @.**@.>>; Author @.**@.>> Subject: Re: [antonscheffer/APEX2XLSX] Is it possible to set worksheet name(s) in the resulting workbook to be IR region name(s) ? (Issue #6)
CAUTION: This message came from an external source. DO NOT click on links or open attachments unless you trust the sender.
I would suggest using as_xlsx to create a xlsx with multiple sheets in combination with some APEX packages: looping report regions, use apex_region.open_query_context looping the data of that context with apex_exec.next__row to_get all rows looping the row with apexexec.get... to get all the data cell values
- Reply to this email directly, view it on GitHubhttps://github.com/antonscheffer/APEX2XLSX/issues/6#issuecomment-1839541107, or unsubscribehttps://github.com/notifications/unsubscribe-auth/BEOVZ66F55CXZJHOZYS3QZ3YHZASJAVCNFSM6AAAAABAGQS6EGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZZGU2DCMJQG4. You are receiving this because you authored the thread.Message ID: @.**@.>>
savantagesolutions
TRANSFORMING CLIENTS' VISION INTO RESULTS
CMMI-DEV Level 3http://www.savantage.net/press_releases?pr_item=66| ISO 9001:2015http://www.savantage.net/press_releases?pr_item=72
The information in this email may be confidential. Regardless of whether the email contains confidential information, the email is a private communication intended solely for the addressee(s). Access to this email by anyone else is unauthorized. If you are not an intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Please notify the sender of the delivery error by replying to this message, and then delete it from your system.
Hi,
Evaluated this plug-in ; great stuff.
https://github.com/antonscheffer/APEX2XLSX/blob/master/plugin/process_type_plugin_scheffer_apex_xlsx.sql
I am wondering now a hopefully simple question: how do we include the worksheet name(s) in the resulting workbook so that it could be the respective region name(s) for the worksheet tab names ? Maybe there is not a way yet but it would be fantastic.
@anton-scheffer
https://forums.oracle.com/ords/apexds/user/anton-scheffer