3 Replies Latest reply: Sep 13, 2012 8:00 AM by Michael Tarallo RSS

    Not able to read .xlsm files

    Jagan Nalla

      Hello,

       

      I'm trying to read .xlsm files(Microsoft excel macro-enabled worksheet) into expressor but, It shows me error. Can we read this type of files into expressor. Please let me know how can we access this type of files.

       

      Cheers!!

      Jagan

        • Re: Not able to read .xlsm files
          Michael Tarallo

          Hello Jagan,

           

          That type of file is not supported by the Excel Schema Wizard or the Read Excel Operator. Only .xls and .xlsx files are supported as data files.

           

          According to the documentation: (click to enlarge)

           

          help1.PNG

           

          So, I would suspect that you need to save it as a proper Excel document extension (XLS or XLSX) that we support and try that.

           

          Please let us know how you do.

           

          Regards,

           

          Mike T

            • Re: Not able to read .xlsm files
              Jagan Nalla

              Thanks Michael. I Can able to read excel files with extension *.xls or xlsx. But i'm trying to read xlsm files and generate it into flat files. I thought that expressor supports this kind of thinks.

                • Re: Not able to read .xlsm files
                  Michael Tarallo

                  Your Welcome - no problem - I can log a feature request, but it is not a common request so I am not sure how it will be prioritized.

                   

                  The only possible alternative would be to find a command line batch driven conversion utility. For example this one at the link provided - I am not sure if it has command line - but gives you an idea that they do exist: http://download.cnet.com/Xlsx-Xlsm-To-Xls-Converter-3000/3000-2077_4-10920740.html 

                   

                  You would be able to create a multi-step QVE dataflow - with the first step using Datascript to call the external program to convert the file to the needed format.

                   

                  The the next step would read in the file as usual.

                   

                  However - this would take some more research on the 3rd party program as well as the Datascript needed to execute the program.

                   

                  Regards,

                   

                  Mike T