Forum Stats

  • 3,855,314 Users
  • 2,264,499 Discussions
  • 7,905,967 Comments

Discussions

Export Excel instead of .csv

Denes Kubicek
Denes Kubicek Member Posts: 6,163 Bronze Crown
edited Dec 3, 2009 1:18AM in APEX Discussions
I am just working on a package for extracting an excel file directly instead of .csv. I am
interested to know if there are problems for any of you to get a clean export. Please
have a look here and try it out:

http://htmldb.oracle.com/pls/otn/f?p=31517:108

I appreciate your feedback.

Denes Kubicek
Tagged:
«13456715

Comments

  • marife
    marife Member Posts: 1,312
    That is slick. It worked fine using Firefox v1.0, Excel 2003, on Windows XP. I got the normal Open or Save to disk dialog.

    I will ask the obvious, "How'd you do it?"

    Mike
  • Arie Geller
    Arie Geller Member Posts: 4,186 Gold Trophy
    Hello Denes,

    I've tried it with IE7 and Excel 2003 and it seems to work just fine.

    Well done,
    Arie.
  • 548023
    548023 Member Posts: 70
    edited Mar 5, 2007 12:08PM
    Works great Denes!

    Is it also possible to upload an .xls instead of .csv?
    (like Vikas does with .csv here http://htmldb.oracle.com/pls/otn/f?p=38131:1)
  • abe50
    abe50 Member Posts: 91 Blue Ribbon
    edited Mar 5, 2007 1:32PM
    Works great on Excel 2007, FF2 and Vista.

    great job Denes.

    Abe
  • 501638
    501638 Member Posts: 95
    Hi Denes,

    I have Excel 2000 and IE 6.0. Works super.
    Your Excel looks as if you applied VBA method Coulmn.AutoFit.
    Val
  • Denes Kubicek
    Denes Kubicek Member Posts: 6,163 Bronze Crown
    Mike,

    It is easy - I generate html.

    I made a demo package available here:

    http://htmldb.oracle.com/pls/otn/f?p=31517:108

    for testing. As soon as I'm done with it I will open it for modifications. The package is
    generic (let us say in 95% of the cases it should work). I didn't test it with PL/SQL
    reports but I doubt it will work with those. However, it should work with all normal
    reports. The how - to is also attached.

    Basically, you need to create three application items and one conditional page process.
    After that, you may create links for exporting to excel as you do it with .csv.

    Your feedback is welcome.

    Denes Kubicek
  • Ribhi
    Ribhi Member Posts: 191 Blue Ribbon
    Hi Denes;

    It seems that i don't have clean export. I got the following messages:

    Problem During download. Problem came up in the following areas during load:

    missing file: c:\i\css\core_v22.css
    missing file: c:\i\themes\theme_9\theme_V2.css

    Please note that APEX is installed on my D drive.

    Thanks
  • Denes Kubicek
    Denes Kubicek Member Posts: 6,163 Bronze Crown
    I noticed that this happens when you forget to:

    1. pass the right report title

    2. forget to pass the page parameter on which report is located or pass the wrong page
    number

    I still need some time to clean up the package so mistakes like these get handeled.

    What is your name? I think it would be fair if you would sign your postings :)

    Denes Kubicek
  • d_wilhelm
    d_wilhelm Member Posts: 405
    Hi Denes,

    i downloaded the package from your page, but i have trouble getting it to work on Oracle XE.

    When i try to install the package i get the message that the body was created with a warning.

    This is the output of show errors:

    Fehler bei PACKAGE BODY EXPORT_EXCEL_PKG:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    255/7 PL/SQL: SQL Statement ignored
    257/14 PL/SQL: ORA-00942: Tabelle oder View nicht vorhanden


    Thanks for help in advance,
    Dirk
  • Pleiadian
    Pleiadian Member Posts: 521 Silver Badge
    Hi Denes,

    It looks very nice... although I haven't got it running yet :)

    I think there is a small error in the sql file
    CREATE OR REPLACE PACKAGE BODY developer.export_excel_pkg wrapped
    The schema name should not be there... right?

    Rob
This discussion has been closed.