4

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.

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
Ales Kancilija
  • 894
  • 2
  • 10
  • 20

2 Answers2

7

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.

andr
  • 1,626
  • 8
  • 10
3

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

Gary Myers
  • 34,963
  • 3
  • 49
  • 74