What is ORA_EXCEL?
ORA_EXCEL (Oracle Excel) is PL/SQL package for Oracle® database that produces Excel XLSX documents. ORA_ EXCEL 讓開發人員能夠去建立Excel報表或利用簡單的PL / SQL API方式從oracal數據庫導出excel文件。
- new_document
- add_sheet
- add_row
- query_to_sheet
- set_row_height
- set_cell_value
- set_cell_font
- set_default_font
- set_cell_bold
- set_cell_italic
- set_cell_underline
- set_cell_color
- set_cell_bg_color
- set_cell_align_left
- set_cell_align_right
- set_cell_align_center
- set_cell_vert_align_top
- set_cell_vert_align_middle
- set_cell_vert_align_bottom
- set_column_width
- set_cell_border_top
- set_cell_border_bottom
- set_cell_border_left
- set_cell_border_right
- set_cell_border
- set_cell_wrap_text
- merge_cells
- merge_rows
- set_cell_format
- set_cell_formula
- set_cell_rotate_text
- set_sheet_margins
- set_sheet_landscape
- set_sheet_paper_size
- set_sheet_header_text
- set_sheet_footer_text
- set_cell_hyperlink
- set_cell_internal_hyperlink
- set_cell_indent_left
- set_cell_indent_right
- set_cell_comment
- hide_column
- hide_row
- set_cells_filter
- save_to_file
- save_to_blob
- set_1904_date_system
- set_1900_date_system
- set_document_author
- add_style
- set_cell_style
- freeze_panes_horizontal
- freeze_panes_vertical
- blob_to_file
- group_columns
- set_cell_validation_list
- set_cell_validation_integer
- set_cell_validation_decimal
- set_cell_validation_date
- set_cell_validation_time
- set_cell_validation_text_len
Included features
| Professional | Unlimited | Source | |
| Database instances |
1~5 | Unlimited | Unlimited |
| Years (license duration) | 1~5 | 1~4 / Unlimited | Unlimited |
| Source Code | Encrypted | Encrypted | Provided |
Set column formulas
| Example | Output |
 |
 |
Set cell as hyperlink
| Example | Output |
 |
 |