Create excel file from existing excel file (template)

[jgebal]

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" - hidden sheet to be filled with data
• "Report" - visible sheet that is built on the data from "Sheet 1" with all the blows and whistled (formatting, pagination, print range, headers, footers, images etc.)

I would like to be able to:

• Open an existing workbook from a file or a blob variable in PL/SQL
• Populate data in an empty "Sheet 1" including column headers using an SQL query
• Save the workbook to a file or to a blob variable (column)

I would be really interesed if this is possible or if you have ever considered such use-case.

[mbleron]

Hi,

That's out of the scope of ExcelGen at the moment, as it's mainly designed to build Excel files from scratch. It's not an impossible task though, provided we only have to edit individual cells or a cell range with no interaction with other parts of the file. Otherwise, there are better 3rd-party tools for this job.

I may consider it in the future. Thanks.

[jgebal]

Thank you