Title:
CFSPREADSHEET Fails to read .XLSX created by SQL Server Reporting Services 2016
| View in TrackerStatus/Resolution/Reason: Closed/Withdrawn/CustomerSupport
Reporter/Name(from Bugbase): Grant Magar / ()
Created: 10/24/2018
Components: Document Management, Office Integration
Versions: 10.0
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.
Attachments:
Comments: