This discussion is archived
1 Reply Latest reply: Apr 29, 2011 7:51 AM by riedelme RSS

excel is not generating on correct format

579953 Newbie
Currently Being Moderated
Hi Friends.

i tryed to create one excel by spooling. when excel is created its not generating on correct format, i think html is not taking , here below is my code. Please check it.
set termout off;
set feedback off;
rem set markup html on;
rem set feed off markup html on spool on ;
SET MARKUP HTML ON PREFORMAT OFF;
set pagesize 9999;
COLUMN IDENTITY FORMAT A19 HEADING '';
COLUMN PERIOD FORMAT A23 WRAP HEADING 'SHIPMENT PERIOD /|DELIVERY PERIOD';
COLUMN CP_NAME FORMAT A12 HEADING 'CP NAME';
COLUMN CONTRACT FORMAT A15 HEADING 'CONTRACT';
COLUMN CONTRACT_REF FORMAT A15 HEADING 'CONTRACT REFS';
COLUMN PAYMENT_TERMS FORMAT A13 HEADING 'PAYMENT| TERMS';
COLUMN BL_DATE FORMAT A13 HEADING 'BL DATE';
COLUMN EXPECTED_DATE FORMAT A24 WRAP HEADING 'EXPECTED| PAYMENT| DATE*| /EXPECTED| RECEIPTS| DATE**';
COLUMN EXPECTED_AMOUNT FORMAT '9,99,99,999.00' WRAP HEADING 'EXPECTED| PAYMENT| AMOUNT| /EXPECTED| RECEIPTS| AMOUNT';
COLUMN BANK FORMAT A13 HEADING 'BANK';
COLUMN DOC_REF FORMAT '9999999999' WRAP HEADING 'DOC| REF';
COLUMN AMOUNT FORMAT '9,99,99,999.00' HEADING 'AMOUNT';
COLUMN DUE_DATE FORMAT A13 HEADING 'ACTUAL| DUE| DATE';
COLUMN PAYMENT_MADE_RECEIVED FORMAT A24 WRAP HEADING 'PAYMENT| MADE /|FUNDS| RECEIVED';
COLUMN AMOUNT_PAID_RECEIVED FORMAT '9,99,99,999.00' WRAP HEADING 'AMOUNT PAID /|RECEIVED';
BREAK ON IDENTITY;
Exec pkg_View_Context.View_PRC ('1',1,'01-MAR-11','25-APR-11');
SPOOL C:\cash_flow_89.xls
SELECT "IDENTITY","POSITION","PERIOD","CP_NAME","CONTRACT","CONTRACT_REF","PAYMENT_TERMS","BL_DATE","EXPECTED_DATE","EXPECTED_AMOUNT","BANK","DOC_REF","AMOUNT","DUE_DATE","PAYMENT_MADE_RECEIVED","AMOUNT_PAID_RECEIVED" FROM VIEW_CASH_FLOW;
SPOOL OFF
rem set markup html off;
rem set markup html off spool off;
SET MARKUP HTML off ;
  • 1. Re: excel is not generating on correct format
    riedelme Expert
    Currently Being Moderated
    AneeshKC wrote:
    Hi Friends.

    i tryed to create one excel by spooling. when excel is created its not generating on correct format, i think html is not taking , here below is my code. Please check it.
    What is it producing? What are you expecting?

    Would it be easier for you to produce a csv to load into Excel manually, something like
    select column1||','||
             column2||','||
      from my_table

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points