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!

asked 26 Jun '12, 03:32

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120310
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

link

answered 26 Jun '12, 03:41

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

Yalim K. Gerger ♦♦
1914
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.

link

answered 26 Jun '12, 06:25

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120310
accept rate: 0%

Hi Ilia,

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

link

answered 26 Jun '12, 07:44

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

Any ways to use Excel templates for export to Excel?

link

answered 03 Oct '12, 19:04

doxtur's gravatar image

doxtur
113
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) anatoly4u

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

link

answered 09 Mar '16, 07:15

ibrahim's gravatar image

ibrahim
111
accept rate: 0%

thanks for the confirmation anyway

(09 Mar '16, 07:18) anatoly4u

Hi,

Maybe helps this link .
https://technology.amis.nl/2011/02/19/create-an-excel-file-with-plsql/ I customize as_xlsx package for self

link

answered 21 Mar '16, 06:23

AlfAbetas's gravatar image

AlfAbetas
611311
accept rate: 9%

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

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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

Tags:

×9

Asked: 26 Jun '12, 03:32

Seen: 2,479 times

Last updated: 21 Mar '16, 06:43


© Copyright Gerger 2017