book
Article ID: KB0070312
calendar_today
Updated On:
Description
Description:
When you create a .xls or .xlsx file using Google Docs or Maporama Geomanager and try to open this in Spotfire you can get this error message (or a similar one):
Error message: Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 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.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:
Input string was not in a correct format. (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:
Input string was not in a correct format. (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)
FormatException at mscorlib:
Input string was not in a correct format. (HRESULT: 80131537)
Stack Trace:
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParsePane(XmlReader reader, WorksheetImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheetView(XmlReader reader, WorksheetBaseImpl sheetBase)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheetViews(XmlReader reader, WorksheetBaseImpl sheet)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheetBeforeData(XmlReader reader, WorksheetImpl sheet, Stream streamStart, List`1 arrStyles)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseSheet(XmlReader reader, WorksheetImpl sheet, String strParentPath, MemoryStream& streamStart, MemoryStream& streamCF, List`1 arrStyles, Dictionary`2 dictItemsToRemove, Dictionary`2 dictUpdatedSSTIndexes)
at Syncfusion.XlsIO.Implementation.XmlSerialization.WorksheetDataHolder.ParseWorksheetData(WorksheetImpl sheet, Dictionary`2 dictUpdateSSTIndexes)
at Syncfusion.XlsIO.Implementation.WorksheetImpl.ParseData(Dictionary`2 dictUpdatedSSTIndexes)
at Syncfusion.XlsIO.Implementation.XmlReaders.Excel2007Parser.ParseWorksheets(Dictionary`2 dictUpdatedSSTIndexes)
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 Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<OpenWorkbook>d__13`1.MoveNext()
Issue/Introduction
When opening an Excel file created using Google Docs or Maporama Geomanager in Spotfire client (e.g. Analyst), you get an error message like
"Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 or newer".
Resolution
Open the .xls or .xlsx file in Excel and re-save it (as a general rule, use the latest available Excel version). This will in most cases enable you to open the file in Spotfire.