Not able to read .xlsm files

[jagannalla]

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

[Michael_Tarallo · Accepted solution]

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)

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

[jagannalla]

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.

[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