var current_user

current_user astypetp_alignmentisrecord(verticalvarchar2(11),horizontalvarchar2(16),wraptextboolean)

procedure clear_workbook

procedure clear_workbook

procedure new_sheet

procedure new_sheet(
    p_sheetname varchar2:=null
)

function orafmt2excel

function orafmt2excel(
    p_format varchar2:=null
) return varchar2

function get_numfmt

function get_numfmt(
    p_format varchar2:=null
) return pls_integer

function get_font

function get_font(
    p_name varchar2,
    p_family pls_integer:=2,
    p_fontsize number:=11,
    p_theme pls_integer:=1,
    p_underline boolean:=false,
    p_italic boolean:=false,
    p_bold boolean:=false,
    p_rgb varchar2:=null
) return pls_integer

function get_fill

function get_fill(
    p_patterntype varchar2,
    p_fgrgb varchar2:=null
) return pls_integer

function get_border

function get_border(
    p_top varchar2:=thin,
    p_bottom varchar2:=thin,
    p_left varchar2:=thin,
    p_right varchar2:=thin
) return pls_integer

function get_alignment

function get_alignment(
    p_vertical varchar2:=null,
    p_horizontal varchar2:=null,
    p_wraptext boolean:=null
) return tp_alignment

procedure cell

procedure cell(
    p_col pls_integer,
    p_row pls_integer,
    p_value number,
    p_numfmtid pls_integer:=null,
    p_fontid pls_integer:=null,
    p_fillid pls_integer:=null,
    p_borderid pls_integer:=null,
    p_alignment tp_alignment:=null,
    p_sheet pls_integer:=null
)

procedure cell

procedure cell(
    p_col pls_integer,
    p_row pls_integer,
    p_value varchar2,
    p_numfmtid pls_integer:=null,
    p_fontid pls_integer:=null,
    p_fillid pls_integer:=null,
    p_borderid pls_integer:=null,
    p_alignment tp_alignment:=null,
    p_sheet pls_integer:=null
)

procedure cell

procedure cell(
    p_col pls_integer,
    p_row pls_integer,
    p_value date,
    p_numfmtid pls_integer:=null,
    p_fontid pls_integer:=null,
    p_fillid pls_integer:=null,
    p_borderid pls_integer:=null,
    p_alignment tp_alignment:=null,
    p_sheet pls_integer:=null
)

procedure hyperlink

procedure hyperlink(
    p_col pls_integer,
    p_row pls_integer,
    p_url varchar2,
    p_value varchar2:=null,
    p_sheet pls_integer:=null
)

procedure comment

procedure comment(
    p_col pls_integer,
    p_row pls_integer,
    p_text varchar2,
    p_author varchar2:=null,
    p_width pls_integer:=150,
    p_height pls_integer:=100,
    p_sheet pls_integer:=null
)

procedure mergecells

procedure mergecells(
    p_tl_col pls_integer,
    p_tl_row pls_integer,
    p_br_col pls_integer,
    p_br_row pls_integer,
    p_sheet pls_integer:=null
)

procedure list_validation

procedure list_validation(
    p_sqref_col pls_integer,
    p_sqref_row pls_integer,
    p_tl_col pls_integer,
    p_tl_row pls_integer,
    p_br_col pls_integer,
    p_br_row pls_integer,
    p_style varchar2:=stop,
    p_title varchar2:=null,
    p_prompt varchar:=null,
    p_show_error boolean:=false,
    p_error_title varchar2:=null,
    p_error_txt varchar2:=null,
    p_sheet pls_integer:=null
)

procedure list_validation

procedure list_validation(
    p_sqref_col pls_integer,
    p_sqref_row pls_integer,
    p_defined_name varchar2,
    p_style varchar2:=stop,
    p_title varchar2:=null,
    p_prompt varchar:=null,
    p_show_error boolean:=false,
    p_error_title varchar2:=null,
    p_error_txt varchar2:=null,
    p_sheet pls_integer:=null
)

procedure defined_name

procedure defined_name(
    p_tl_col pls_integer,
    p_tl_row pls_integer,
    p_br_col pls_integer,
    p_br_row pls_integer,
    p_name varchar2,
    p_sheet pls_integer:=null,
    p_localsheet pls_integer:=null
)

procedure set_column_width

procedure set_column_width(
    p_col pls_integer,
    p_width number,
    p_sheet pls_integer:=null
)

procedure set_column

procedure set_column(
    p_col pls_integer,
    p_numfmtid pls_integer:=null,
    p_fontid pls_integer:=null,
    p_fillid pls_integer:=null,
    p_borderid pls_integer:=null,
    p_alignment tp_alignment:=null,
    p_sheet pls_integer:=null
)

procedure set_row

procedure set_row(
    p_row pls_integer,
    p_numfmtid pls_integer:=null,
    p_fontid pls_integer:=null,
    p_fillid pls_integer:=null,
    p_borderid pls_integer:=null,
    p_alignment tp_alignment:=null,
    p_sheet pls_integer:=null
)

procedure freeze_rows

procedure freeze_rows(
    p_nr_rows pls_integer:=1,
    p_sheet pls_integer:=null
)

procedure freeze_cols

procedure freeze_cols(
    p_nr_cols pls_integer:=1,
    p_sheet pls_integer:=null
)

procedure freeze_pane

procedure freeze_pane(
    p_col pls_integer,
    p_row pls_integer,
    p_sheet pls_integer:=null
)

procedure set_autofilter

procedure set_autofilter(
    p_column_start pls_integer:=null,
    p_column_end pls_integer:=null,
    p_row_start pls_integer:=null,
    p_row_end pls_integer:=null,
    p_sheet pls_integer:=null
)

function finish

function finish return blob

procedure save

procedure save(
    p_directory varchar2,
    p_filename varchar2
)

procedure query2sheet

procedure query2sheet(
    p_sql varchar2,
    p_column_headers boolean:=true,
    p_directory varchar2:=null,
    p_filename varchar2:=null,
    p_sheet pls_integer:=null
)