Using Excel Gen Utility

[guruswamyd]

First and foremost many thanks for helping the developer community to use your stuff. Its a great contribution, appreciate it.

By the way when we use it, we are unable to see the excel file with data and always the files gets downloaded as file is corrupted and cant be viewed/saved.

May we know why is this please. We are using ORACLE 19c DB on Linux with Enterprise edition.

THanks and eagerly awaiting your response.

[mbleron]

Hi,

I can't possibly know what's wrong with that few details.
Could you please post the code you're using to create the file, and the resulting file too?

Thanks.

[guruswamyd]

Hi, PFA the file which got generated. Thank you, Pls do let me know what are the other details you need. We just downloaded the code from the Github, run the installer.sql and then started using it. No changes Thanks

…

On Sat, 1 Mar 2025 at 21:02, Marc Bleron ***@***.***> wrote: Hi, I can't possibly know what's wrong with that few details. Could you please post the code you're using to create the file, and the resulting file too? Thanks. — Reply to this email directly, view it on GitHub <#73 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BQAJSDJPWQOEKEXBCB7YWM32SHHH5AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGI4DIOBQGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***> [image: mbleron]*mbleron* left a comment (mbleron/ExcelGen#73) <#73 (comment)> Hi, I can't possibly know what's wrong with that few details. Could you please post the code you're using to create the file, and the resulting file too? Thanks. — Reply to this email directly, view it on GitHub <#73 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BQAJSDJPWQOEKEXBCB7YWM32SHHH5AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGI4DIOBQGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Thanks Guru

[mbleron]

The attachment is lost when you reply my email (for security reason probably).
You have to attach it directly in the issue through Github.

What piece of PL/SQL code did you run to generate the file?

[guruswamyd]

I will get you on that once i connect back to the servers tomorrow. Thanks for your intention shown in helping. Appreciate it.

…

On Sat, 1 Mar 2025 at 23:11, Marc Bleron ***@***.***> wrote: The attachment is lost when you reply my email (for security reason probably). You have to attach it directly in the issue through Github. What piece of PL/SQL code did you run to generate the file? — Reply to this email directly, view it on GitHub <#73 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BQAJSDM2E7DAXRCH2K6W5L32SHWL7AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGMZTIMJUGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***> [image: mbleron]*mbleron* left a comment (mbleron/ExcelGen#73) <#73 (comment)> The attachment is lost when you reply my email (for security reason probably). You have to attach it directly in the issue through Github. What piece of PL/SQL code did you run to generate the file? — Reply to this email directly, view it on GitHub <#73 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BQAJSDM2E7DAXRCH2K6W5L32SHWL7AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGMZTIMJUGQ> . You are receiving this because you authored the thread.Message ID: ***@***.***>

-- Thanks Guru

[guruswamyd]

Hi, Here is the code the same available in the link declare sqlQuery varchar2(32767) := 'select * from hr.employees'; sheetName varchar2(31 char) := 'Sheet1'; ctxId ExcelGen.ctxHandle; begin ctxId := ExcelGen.createContext(); ExcelGen.addSheetFromQuery(ctxId, sheetName, sqlQuery); ExcelGen.setHeader( ctxId , sheetName , p_style => ExcelGen.makeCellStyle( p_ctxId => ctxId , p_font => ExcelGen.makeFont('Calibri',11,true) , p_fill => ExcelGen.makePatternFill('solid','LightGray') ) , p_frozen => true , p_autoFilter => true ); ExcelGen.setDateFormat(ctxId, 'dd/mm/yyyy'); ExcelGen.createFile(ctxId, 'TEST_DIR', 'employees.xlsx'); ExcelGen.closeContext(ctxId); end; / On Sat, 1 Mar 2025 at 23:19, Guruswamy Dhandapani - Gmail < ***@***.***> wrote:

…

I will get you on that once i connect back to the servers tomorrow. Thanks for your intention shown in helping. Appreciate it. On Sat, 1 Mar 2025 at 23:11, Marc Bleron ***@***.***> wrote: > The attachment is lost when you reply my email (for security reason > probably). > You have to attach it directly in the issue through Github. > > What piece of PL/SQL code did you run to generate the file? > > — > Reply to this email directly, view it on GitHub > <#73 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/BQAJSDM2E7DAXRCH2K6W5L32SHWL7AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGMZTIMJUGQ> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> > [image: mbleron]*mbleron* left a comment (mbleron/ExcelGen#73) > <#73 (comment)> > > The attachment is lost when you reply my email (for security reason > probably). > You have to attach it directly in the issue through Github. > > What piece of PL/SQL code did you run to generate the file? > > — > Reply to this email directly, view it on GitHub > <#73 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/BQAJSDM2E7DAXRCH2K6W5L32SHWL7AVCNFSM6AAAAABYEFXGWOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOJSGMZTIMJUGQ> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> > -- Thanks Guru

-- Thanks Guru

[mbleron]

Still waiting for a sample file, unless you've got the issue sorted?