2 Replies Latest reply: Feb 27, 2013 9:57 AM by 993271 RSS

    enable .xlsx output format for psquery

    993271
      Hello
      I was wondering if we could make psquery run default to generate .xlsx (2007 format) excel file instead of .xls

      any ideas.

      Subhash
        • 1. Re: enable .xlsx output format for psquery
          HakanBiroglu
          I think this doc explains it ...
          E-QR: How to generate Files as Xlsx Output When Using MS Office 2007 using the PSQuery Tool [ID 1159055.1]
          https://support.oracle.com/epmos/faces/DocContentDisplay?id=1159055.1

          Bottom line open xls and save as xlsx.
          • 2. Re: enable .xlsx output format for psquery
            993271
            I saw that posting and wondering if we could hack run to excel iscript to generate xlsx.

            especially this function below.
            WEBLIB_QUERY.ISCRIPT1.FieldFormula.IScript_ToExcel
            %Response.WriteBinary(&QryObj.FormatBinaryResultString(&gQueryRowset, %Query_XLS, 0, 0));

            I dont see much information about %query_xls above and if we could do some java method to generate an xlsx downloadable file.

            thanks for the inputs.