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:

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.


asked 26 Jun '12, 03:32

Ilia%20Sazonov's gravatar image

Ilia Sazonov
accept rate: 0%

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


answered 26 Jun '12, 03:41

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
accept rate: 20%

edited 26 Jun '12, 03:41

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.


answered 26 Jun '12, 06:25

Ilia%20Sazonov's gravatar image

Ilia Sazonov
accept rate: 0%

Hi Ilia,

Formspider invokes it in the application server context, It is not possible to use POI library within Formspider.


answered 26 Jun '12, 07:44

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
accept rate: 23%

Any ways to use Excel templates for export to Excel?


answered 03 Oct '12, 19:04

doxtur's gravatar image

accept rate: 0%

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


answered 09 Mar '16, 07:15

ibrahim's gravatar image

ibrahim ♦♦
accept rate: 0%

thanks for the confirmation anyway

(09 Mar '16, 07:18) viktorK


Maybe helps this link . I customize as_xlsx package for self


answered 21 Mar '16, 06:23

AlfAbetas's gravatar image

accept rate: 11%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 26 Jun '12, 03:32

Seen: 4,270 times

Last updated: 21 Mar '16, 06:43

© Copyright Gerger 2017