ExcelGen
ExcelGen copied to clipboard
mbleron
ExcelGen is an Oracle PL/SQL utility to create MS Excel files (.xlsx, .xlsb)
Would it be possible to use your library to populate an existing excel file with data? For example. I have an excel file with two sheets: - "Sheet 1" -...
Sometimes it is necessary to add a sheet to excel to store basic data, but it is not necessary to display it. Can this feature be supported?
The documentation lacks the description of a parameter `p_excludeCols` in procedures `addSheetFromQuery`, `addSheetFromCursor` and `addTable`. Was this intentional (maybe left only for testing purpose)? I tried it today and found...
Hi, First of all, this is a very neat PL/SQL package. Would it be possible to format a cell conditionally, based on its content ? Example: if SQL column contains...
Hi Marc Bleron! I have not found how to set a special format for a particular column (or cell) to make the content link. Is there a way to set...
Hi mbleron: First of all, thank you for the great work, ExcelGen really helps a lot ! I am wondering if ExcelGen has a way to fill formula into specific...
When I use the putCell procedure to generate xlsx, If there are too many rows(half a million e.g), this error will occur
can we create multi line dynamic headers with filters for different columns in sheet or table in a sheet? if we can please share example otherwise I'll request for enhancement....
I'm having a blast with version 3. My business users have been clamoring for multi-row headers and merged cell banners among other things and now it is possible. I see...
