Posts

Showing posts with the label Oracle Report in Excel Format

To Generate Oracle Report Output in Excel

Oracle Reports in csv and tsv . For the output to be displayed in Excel format. I had to do a report to display the output with Japan Characters. declare      demoDocument     xoxo_ExcelDocumentType;      documentArray    xoxo_ExcelDocumentLine := xoxo_ExcelDocumentLine();      clobDocument     CLOB;        v_file        UTL_FILE.FILE_TYPE;        lc_desc       table.column%TYPE;        lc_subject        xoxo_email.subject%TYPE;        ln_batch_id       xoxo_email.batch_id%TYPE;        lc_email_address  xoxo_email.to_address%TYPE;        lc_message        xoxo_email.text_body%TYPE;        lc_appl_name      applsys.fnd_application.application_sho...