1 Reply Latest reply: Apr 29, 2011 9:51 AM by riedelme RSS

    excel is not generating on correct format

    579953
      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
          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