Description:The error message is received when trying to open a *.xlsx Excel file in Spotfire. If you manually convert the format of an existing Excel file from *xlsx to *.xls then, it opens without issues in the Spotfire client.
See the attached files (Filename:Error_Message.txt) and screenshot (Filename:Excel_Error.JPG) for the full error trace.
Symptoms:Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 format or newer.
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.Framework.ApplicationModel.ProgressService.ExecuteWithProgress(String title, String description, ProgressOperation operation)
at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings)
at Spotfire.Dxp.Forms.Application.FileUserActions.LoadFileCallback(LoadCallbackParameters parameters)
at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters, Form owningForm)
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)
at Spotfire.Dxp.Application.AnalysisApplication.<OpenDocumentFile>d__f.MoveNext()
at Spotfire.Dxp.Forms.Application.FormsApplicationThread.<>c__DisplayClass5.<ExecutePromptingOperation>b__4()
at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()
ImportException at Spotfire.Dxp.Data:
Font 'Calibri' does not support style 'Regular'. (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:
Font 'Calibri' does not support style 'Regular'. (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__3`1.MoveNext()
at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__0.MoveNext()
at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)
.....Full Error Trace (Filename:Error_Message.txt) is attached.
Cause:Calibri font has been corrupted.