First of all, I want to thank the Formspider team for introducing a neat feature that allows us to export data from a grid to an Excel document, and also for putting together a nice tutorial on how this can be done: http://theformspider.com/learningcenter/tutorial-28-how-to-export-data-to-excel-from-formspider-datasources-and-grids/ Several years ago I was desperately looking for a tool to allow for creating Excel spreadsheets in Oracle database, and there was none at that time. There are some solutions now, all XML based. Does Formspider use any of the tools, libraries available on the market of open source? Or is this your own solution? If yes, can you provide more API functions to developers so we can access individual cells, rows and columns to put data and apply formatting? I have an application that (among other things) produces printed reports. And the repot layout is fairly complex. Besides, It changes every few months (oh, government!). It's such a pain to implement them with Oracle Reports or HTML! And it'd be much easier to use an existing Excel layout as a template or create one in PL/SQL. Thanks! |
Hi Ilia, Thank you for your kind words. We use Apache POI which is an open source library. If you are looking for a PL/SQL solution, I think PL/PDF is exactly what you are looking for. Even the the name of the prodcut is PL/PDF, it also supports Excel sheet generation. Hope this helps. Kind Regards, Yalim |
Thanks for the links, Yalim! Do you invoke POI in the application server context, or is it installed and executed in the database? I'm trying to understand whether a PL/SQL developer can use this feature within Formspider framework, or one needs to write PL/SQL-2-Java API for POI. |
Hi Ilia, Formspider invokes it in the application server context, It is not possible to use POI library within Formspider. |
Any ways to use Excel templates for export to Excel? Hi Doxtur, Currently, it's not possible to use Excel templates for export to Excel. Regards, Ibrahim
(03 Oct '12, 23:54)
Ibrahim Sand... ♦♦
This question seems to be a long time ago and probably something has changed from that time. The question is if there is a possibility to format the rows or columns by the condition in the print excel export options? What we need is for example to fill the row or column by some specific color according to the condition. Thanks, Anatoly
(02 Mar '16, 04:24)
viktorK
|
Hi Anatoly, Unfortunately, it's not possible to format the rows or columns by a specific condition in the print excel API. Best Regards, Ibrahim thanks for the confirmation anyway
(09 Mar '16, 07:18)
viktorK
|
Hi, Maybe helps this link . thanks for sharing. Yes, we use this package and it is very helpful for small amount of data though it is a separate not builtin solution
(21 Mar '16, 06:43)
viktorK
|