Geek Answers Handbook

Generate XLS Files Using PL / SQL

I would like to generate XLS files using PL / SQL. This includes entering text into cells, staining cells, settling cells, and merging cells.

This may also include:

  • different fonts, sizes, styles, alignments and text colors.
  • arrangement of various lines, styles and colors of borders.
  • different types (number, text, time, date, boolean, ..) of cells

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

+4
source share
2 answers

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

Everything that you specified in the requirements can be performed in this way.

Hope this helps.

I made a general XLS from PL / SQL reporting solutions using these methods: hardly anything difficult. Feel free to ask if you have any problems.

+7
source

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

+3
source

More articles:


All Articles