I would like to generate XLS files using PL/SQL. This includes entring text into cells, coloring cells, bordering cells and merging cells. This may include also: different fonts, sizes, styles, alignings and colors of text different line arrangement, styles and colors of borders different types (number, text, time, date, boolean, ..) of cells Can please anyone direct me, where can I find any documentation, methods, examples.. - anything about how to do this.

Reputation: 894

generate XLS files using PL/SQL

I would like to generate XLS files using PL/SQL. This includes entring text into cells, coloring cells, bordering cells and merging cells.

This may include also:

different fonts, sizes, styles, alignings and colors of text
different line arrangement, styles and colors of borders
different types (number, text, time, date, boolean, ..) of cells

Can please anyone direct me, where can I find any documentation, methods, examples.. - anything about how to do this.

Upvotes: 4

Answers (2)

Gary Myers

Reputation: 35401

Check out the work done by Jason Bennett on hist PL/SQL ExcelDocumentType

Upvotes: 3

andr

Reputation: 1646

Starting from MS Office 2003 you can create XLS files as usual XML files. The official documentation is here and some PL/SQL examples can be found here or here.

Everything you've stated in requirements can be done this way.

Hope this helps.

I've done a general XLS from PL/SQL reporting solutions using this techniques: there's hardly any difficult things. Feel free to ask if you have any problems.

Upvotes: 7

generate XLS files using PL/SQL

Answers (2)

Related Questions