Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating excel using PL/SQL

muralirachakondaJun 26 2014 — edited Jul 2 2014

Hello Friends,

I am generating EXCEL report in PL/SQL using the API provided by JASON BENNETT.

I have created style as below, P_CELL_COLOR to set background color is not working. Please let me know if i am doing something wrong here.

demoDocument.createStyle(p_style_id =>'ColumnHeader',

                               p_font     =>'Arial',

                               p_bold     =>'Y',

                               p_fsize    =>'10',

                               p_align_horizontal=>'Left',

                               p_align_vertical=>'Bottom',

                               p_cell_color => '#993300',

                               p_text_color => '#000000');

Thanks and Regards

Murali

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2014
Added on Jun 26 2014
6 comments
2,534 views