1 6 7 8 9 10 Previous Next 146 Replies Latest reply: Dec 3, 2009 12:18 AM by user786836 Go to original post RSS
      • 105. Re: Export Excel instead of .csv
        Denes Kubicek
        Does your query work if you run it in SQL Workshop ;)

        Denes Kubicek
        -------------------------------------------------------------------
        http://deneskubicek.blogspot.com/
        http://www.opal-consulting.de/training
        http://apex.oracle.com/pls/otn/f?p=31517:1
        -------------------------------------------------------------------
        • 106. Re: Export Excel instead of .csv
          704127
          yes, it works ...
          • 107. Re: Export Excel instead of .csv
            Denes Kubicek
            Have you tried with:
            SELECT *
              FROM vizit_full
             WHERE reg_date >= TO_DATE (:p1_datepicker, '<<date_format>>')
               AND reg_date <= TO_DATE (:p1_datepicker2, '<<date_format>>')
            Denes Kubicek
            -------------------------------------------------------------------
            http://deneskubicek.blogspot.com/
            http://www.opal-consulting.de/training
            http://apex.oracle.com/pls/otn/f?p=31517:1
            -------------------------------------------------------------------
            • 108. Re: Export Excel instead of .csv
              704127
              still the same problem.. : (
              • 109. Re: Export Excel instead of .csv
                Denes Kubicek
                The amount of information you provide is amazing. How does your statement look like? Does it work with the new select statement in SQL Workshop? Have you tried creating a view on that sql and do a select * from view for the export? Help yourself and the others will be more willing to help you.

                Denes Kubicek
                -------------------------------------------------------------------
                http://deneskubicek.blogspot.com/
                http://www.opal-consulting.de/training
                http://apex.oracle.com/pls/otn/f?p=31517:1
                -------------------------------------------------------------------
                • 110. Re: Export Excel instead of .csv
                  704127
                  my english is very poor .. so..
                  ok. thx for help.
                  • 111. Re: Export Excel instead of .csv
                    689465
                    Hi Dennes,

                    I follwed the PDF which you have given pagckage file. and i able execute it also, but when i open the excel file, file contains the follwoing
                    Report Values Error: ORA-06550: Zeile 1, Spalte 165: PL/SQL: ORA-00936: Ausdruck fehlt ORA-06550: Zeile 1, Spalte 157: PL/SQL: SQL Statement ignored / -6550 / select from ()


                    i have used the below query in tye report.

                    SELECT * FROM EMP WHERE DEPTNO=10
                    • 112. Re: Export Excel instead of .csv
                      Denes Kubicek
                      what if you use SELECT empno FROM emp?

                      Denes Kubicek
                      ------------------------------------------------------------------------------
                      http://deneskubicek.blogspot.com/
                      http://www.opal-consulting.de/training
                      http://apex.oracle.com/pls/otn/f?p=31517:1
                      ------------------------------------------------------------------------------
                      • 113. Re: Export Excel instead of .csv
                        689465
                        Hi,

                        I have used select empno from emp ;

                        But when i clicked Download Button The file download is comming . But open that excel file it contains the follwoing :

                        Report Values Error: ORA-06550: Zeile 1, Spalte 167: PL/SQL: ORA-00936: Ausdruck fehlt ORA-06550: Zeile 1, Spalte 159: PL/SQL: SQL Statement ignored / -6550 / select from ()

                        Edited by: N.K on Jul 15, 2009 2:11 AM
                        • 114. Re: Export Excel instead of .csv
                          Marco1975
                          Denes,

                          is it possible to use your package for multiple worksheets.

                          For example when i have a query which retrieves data for the first 10 years, i want each year on a new worksheet.
                          Is this possible with your package , or do i need to modify it ?

                          thanks in advance,
                          Marco Schlicher
                          • 115. Re: Export Excel instead of .csv
                            Denes Kubicek
                            Create an example on apex.oracle.com and I will debug it.

                            Denes Kubicek
                            ------------------------------------------------------------------------------
                            http://deneskubicek.blogspot.com/
                            http://www.opal-consulting.de/training
                            http://apex.oracle.com/pls/otn/f?p=31517:1
                            ------------------------------------------------------------------------------
                            • 116. Re: Export Excel instead of .csv
                              Denes Kubicek
                              You would need to modify it. It is not a part of it right now.

                              Denes Kubicek
                              ------------------------------------------------------------------------------
                              http://deneskubicek.blogspot.com/
                              http://www.opal-consulting.de/training
                              http://apex.oracle.com/pls/otn/f?p=31517:1
                              ------------------------------------------------------------------------------
                              • 117. Re: Export Excel instead of .csv
                                689465
                                hI DENNES,

                                I Hvae created the sample application :

                                http://apex.oracle.com/pls/otn/f?p=31153:1:5269186368291181:::::

                                username:user1
                                password:saroj123

                                plz chk it .
                                • 118. Re: Export Excel instead of .csv
                                  Denes Kubicek
                                  In order to debug it I will need the access to the workspace.

                                  Denes Kubicek
                                  ------------------------------------------------------------------------------
                                  http://deneskubicek.blogspot.com/
                                  http://www.opal-consulting.de/training
                                  http://apex.oracle.com/pls/otn/f?p=31517:1
                                  ------------------------------------------------------------------------------
                                  • 119. Re: Export Excel instead of .csv
                                    689465
                                    WORKSPACE NAME:
                                    USER:USER1
                                    PASSWORD:aaa

                                    Edited by: N.K on Jul 18, 2009 5:01 AM
                                    1 6 7 8 9 10 Previous Next