Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Chennai, India
    Posts
    18

    Unanswered: Save to Excel - Urgent

    Hi,

    We have a fuctionality in the Forms application which we have developed, which allows the user to save the search results as an excel. It will ask for the path to save, default being C:\Filename.xls. It is working fine.

    Now, we have web enabled the application. Now when the user tries to save it as an excel, it gets saved only in the server where the application resides and not in the client.

    Pls give us some suggestions on how we can save it in the clients system.

    Sample code that we are using:

    outfile Text_io.file_type;
    DESTINATION := :FILENAME.EB_FILE ;
    outfile := Text_io.fopen(DESTINATION,'w');
    text_io.put_line(outfile, 'SL NO'||' '||'PARAMETER TYPE');
    for i in cur loop
    CNT := CNT + 1;
    text_io.Put_line(outfile, CNT ||' '||i.PARAM_TYPE);
    end loop;
    text_io.fclose( outfile);
    Palaniappan.S
    Chennai.

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    22
    As Web Application runs on the server, it stores the file on the server. For VB, there is one INet control, through which you can receive the response at client end and save the response in the format which you want. I am not sure about Forms, if there is any controls available which recieves the response, use that control in the client application and save the response into excel file by code.
    Hope, it will satisfy your question
    Regards,
    Jigar Bhavsar

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    Let you application server handle this requirement, not the database.

    If its a web appliaction, client will be a browser.

    You will have a .asp or a .jsp file with html tags. This jsp/asp will display all the data. It will also have a link 'save as excel'

    On click of this, you load the same asp/jsp. The only difference you need is let the response output be text/excel. (by default it is text/html)
    Oracle can do wonders !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •