CFSPREADSHEET Fails to read .XLSX created by SQL Server Reporting Services 2016| View in Tracker
Reporter/Name(from Bugbase): Grant Magar / ()
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: ColdFusion 10,285437 /
Priority/Frequency: Normal / All users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 1
Problem Description: Created basic report in SQL Server Reporting Services 2016. Download results to Excel file (.xlsx). Try to use cfspreadsheet to upload the file and get error: OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! Steps to Reproduce: Create SQL Server Reporting Services report, run, and download results to Excel file (.xlsx). Use <cfspreadsheet action="read" src="#customfile#" query="qry_currStudentImportData" sheet="1" headerrow="1" columns="1,2,3,4,5"/> in attempt to read. Actual Result: OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! Expected Result: Results in Query qry_currStudentImportData Any Workarounds: Download results to Excel file (.xlsx). Create a new empty spreadsheet. Copy data from SQL Server Reporting Services .xlsx to the new empty spreadsheet. cfspreadsheet then works.