This discussion is archived
1 2 3 4 5 6 10 Previous Next 146 Replies Latest reply: Dec 2, 2009 10:18 PM by user786836 Go to original post RSS
  • 45. Re: Export Excel instead of .csv
    484053 Newbie
    Currently Being Moderated
    Hi Denes,

    Many thanks for providing this feature, I am using this in my application and it’s working pretty well without any problem.

    But I have a small problem, when user try to download data more than 65536 rows (Excel limit) then it will discard the rows, which crossed the upper limit. I am just thinking that is there is any possibility that the remaining rows will automatically move to the new worksheet?

    Thanks once again for all your help, really such a great stuff.

    Rajat
  • 46. Re: Export Excel instead of .csv
    546178 Newbie
    Currently Being Moderated
    Hi Denes..
    I installed your package on XE, APEX 3.1.
    Everything is OK, except the columns heading in xls file.
    In explanation, every second column has no heading, but has data (data are displayed correctly), so my table looks incorrectly because heading name dont match with data below it.
    I checked all installation procedure and i think i did everything correctly.

    I appreciate your feedback.

    Kreso..
  • 47. Re: Export Excel instead of .csv
    3549 Newbie
    Currently Being Moderated
    Hi Denes ...

    I installed this package in APEX 3.1 on 10gR2. Everything is OK, even columns heading.
    I have a question about then new interactive report feature in APEX 3.1. It would be very nice if i could use this package instead of Oracles CSV export.. (I don't have BI publisher). Do you have any plans for that?

    Thank's

    Göran Back
  • 48. Re: Export Excel instead of .csv
    526004 Newbie
    Currently Being Moderated
    Just downloaded and installed package. Works great, but would like some assistance with one small annoyance (probably something that I have caused). Some of my columns in the Excel file are displayed as text fields rather than numbers (which is how they are stored in the DB table).

    Any thoughts on helping me troubleshoot?

    Thanks in advance,

    David
  • 49. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    David,

    This excel package needs to be updated. However, I am too busy at the moment. Maybe
    in April-May I will modify this and get rid of some nasty side-effects.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 50. Re: Export Excel instead of .csv
    630273 Newbie
    Currently Being Moderated
    Hi Denes,

    I install excel package and when I download excel I have this error: Report Header Error: ORA-06502: PL/SQL: numerischer oder Wertefehler: character string buffer too small / -6502.
    I need help to fixe this error !

    Many thanks for your help.

    Christ
  • 51. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    Christ,

    Interesting. I think a variable within the package is not big enough to accept the value.
    Haven't seen this before. How many columns do you have in your report? Have you tried
    excluding some of them? Unfortunately, I am on the road now and have no access to all
    of the tools I need to look into the problem.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 52. Re: Export Excel instead of .csv
    630273 Newbie
    Currently Being Moderated
    Hello Denes,

    I have 21 columns in my report and only 14 are displayed.
    The report header's appear in the excel file, but data does not.
    Thank you.
  • 53. Re: Export Excel instead of .csv
    619738 Newbie
    Currently Being Moderated
    hello
    I am just starting out with this excel package, and I am finding it very useful so thanks for creating it. I am in the process of trying to customise it, and had 2 quick questions:
    1. Is there any way that I can specify a landscape page layout?
    2. What type of code is the package creating for excel to use? XML?

    Thanks for your help

    -Marc
  • 54. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    Marc,

    1. I have no idea how this could be done

    2. no xml but html

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 55. Re: Export Excel instead of .csv
    554659 Newbie
    Currently Being Moderated
    Denes,

    Your export works almost ;-) perfect. Only one thing happens which I can't explain.

    My report contains a date field, when I open the XLS file in excel, the date has been become a number (01-01-2006 becomes 38718). I've tried to put a to_char around the date, but the number stays in excel. I don't know if it is a excel option (coulden't find it) or if apex is pulling my leg.

    Do you know if this is a known issue?

    Thx!
    Frank.
  • 56. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    Frank,

    You are right. Bernhard Kahles did some changes on the package and you can download
    the newest version from my demo application. You need to enable pdf printing on the report
    and there you can also include or exclude the columns you want to show. The package is
    now also showing the dates properly. See this example:

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

    Try it out and see if that works for you.

    I still didn't document those changes.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 57. Re: Export Excel instead of .csv
    607350 Journeyer
    Currently Being Moderated
    Does this work with Excel 2007?
  • 58. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    John,

    I have no clue but would say it does - it is a plain html and if Microsoft hasn't developed
    their own html ;), it should behave the same was as for all the other versions.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://htmldb.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 59. Re: Export Excel instead of .csv
    607350 Journeyer
    Currently Being Moderated
    The reason I ask, is because it looks kind of like the Microsoft Office XML format, which is deprecated for office 2007.

    See here:
    http://en.wikipedia.org/wiki/Microsoft_Office_XML_formats
1 2 3 4 5 6 10 Previous Next