1 2 3 4 5 6 Previous Next 146 Replies Latest reply: Dec 3, 2009 12:18 AM by user786836 Go to original post RSS
      • 45. Re: Export Excel instead of .csv
        484053
        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
          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
            ovs10073
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                Does this work with Excel 2007?
                                • 58. Re: Export Excel instead of .csv
                                  Denes Kubicek
                                  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
                                    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 Previous Next