Error in Spotfire client when opening Excel file created using Google Docs or Maporama Geomanager: "Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 or newer"

Error in Spotfire client when opening Excel file created using Google Docs or Maporama Geomanager: "Unsupported Excel workbook version. Make sure that the file is saved in Excel 97 or newer"

book

Article ID: KB0070312

calendar_today

Updated On:

Products

Spotfire Analyst

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.