Spotfire 7.6.1.15 unable to read xlsx

Hello,

I'm trying to add an xlsx data file and get an error message of, "Unsupported Excel workbook version.  make sure that the file is saved in Excel 97 or newer."  I'm using Office 2013.  If I open the file and without doing any edits and just save the file, I am able to add as Data Table.  I've attached the file and the details of the error message are below.

Thanks for any help,

Rick

Error message: Unable to import data. See the details for more information.

ImportException at Spotfire.Dxp.Forms:
Unable to open file J:\Develop\RVH\Develop\SDK Cert Review\SDK_Cert_Review_SOURCE.xlsx (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromFile(String filePath)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenFiles(IEnumerable`1 filePaths, String errorDialogTitle)

TargetInvocationException at Spotfire.Dxp.Framework:
Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:
   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromFile(String filePath)

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()
   at Spotfire.Dxp.Data.DataSource.Connect(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState, DataLoadSettings loadSettings)
   at Spotfire.Dxp.Data.DataSource.Connect(IServiceProvider serviceProvider, DataSourcePromptMode promptMode)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.<>c__DisplayClass2.<CreateConfiguredDataSourceFromFile>b__0()
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

ImportException at Spotfire.Dxp.Data:
Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute(Action f)
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute[T](Func`1 f)
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetPromptModelsCore>d__24.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()

ImportException at Spotfire.Dxp.Data:
Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<OpenWorkbook>d__13`1.MoveNext()
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<ApplyHeuristics>d__0`1.MoveNext()
   at Spotfire.Dxp.Data.Import.Excel2FileDataSource.<GetPromptModels>d__4`1.MoveNext()
   at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__0.MoveNext()
   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)

ArgumentException at mscorlib:
Offset and length were out of bounds for the array or count is greater than the number of elements from index to the end of the source collection. (HRESULT: 80070057)

Stack Trace:
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.List`1.Reverse(Int32 index, Int32 count)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseThemeColors(XmlReader reader, Dictionary`2& dicThemeColors)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseThemeElements(XmlReader reader)
   at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseThemes(XmlReader reader)
   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook(List`1& themeColors)
   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument(List`1& themeColors)
   at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)
   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)
   at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType)
   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<OpenWorkbook>d__13`1.MoveNext()
 

Attachments

AttachmentSize
File sdk_cert_review_source.xlsx24.35 KB

(1) Answer

Login