LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Data published to the Output Excel Node can't be read by Spotfire

  • 1.  Data published to the Output Excel Node can't be read by Spotfire

    Employee
    Posted 05-23-2017 05:17

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Rhalim

    Hi All

    I am publishing data to the Output Excel node as an*.xlsx file. I am creating a Spotfire dashboard to consume this file. The Spotfire dashboard cannot read the *.xlsx file created by Lavastorm.
    I receive and error message saying Unsupported Excel Workbook version. Make sure the file is saved in Excel 97 or newer.
    Other details in the error message are:


    Error message: Failed to execute data source query.

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

    Stack Trace:
    at Spotfire.Dxp.Data.DataTable.<>c__DisplayClass9a.<> c__DisplayClass9e.<BeginRefresh>b__95(Exception exception, Boolean changed, ViewHandle primaryKeys)
    at Spotfire.Dxp.Data.Producers.SourceColumnProducer.< Refresh>d__0.MoveNext()
    at Spotfire.Dxp.Data.DataTable.<>c__DisplayClass9a.<> c__DisplayClass9e.<BeginRefresh>b__94()
    at Spotfire.Dxp.Framework.DocumentModel.Node.Spotfire .Dxp.Framework.DocumentModel.INode.InternalTransac tion(Executor executor)
    at Spotfire.Dxp.Data.DataTable.<>c__DisplayClass9a.<B eginRefresh>b__90()
    at Spotfire.Dxp.Framework.Commands.CommandHistory.Tra nsaction(Executor executor, Boolean visible, Boolean sticky, Guid stickyGuid)
    at Spotfire.Dxp.Framework.DocumentModel.DocumentNode. StickyTransaction(Guid guid, Executor executor)
    at Spotfire.Dxp.Framework.DocumentModel.DocumentNode. Spotfire.Dxp.Framework.DocumentModel.ITransactions .ExecuteStickyTransaction(Guid guid, Executor executor)
    at Spotfire.Dxp.Data.DataTable.BeginRefresh(Boolean showDataLoadReport, Boolean async, Action`1 continuation, DisposableCollection disposableCollection, Predicate`1 isLeafAffected)


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

    Stack Trace:
    at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptM odels>d__2.MoveNext()
    at Spotfire.Dxp.Data.DataFlow.<ConnectAndGetPromptMod els>d__0.MoveNext()
    at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.<Get PromptModelsCore>d__9.MoveNext()
    at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptM odels>d__2.MoveNext()


    ImportException at Spotfire.Dxp.Data:
    Specified argument was out of the range of valid values.
    Parameter name: index (HRESULT: 80131500)

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


    ImportException at Spotfire.Dxp.Data:
    Specified argument was out of the range of valid values.
    Parameter name: index (HRESULT: 80131500)

    Stack Trace:
    at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings. <OpenWorkbook>d__13`1.MoveNext()
    at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings. <UpdateExcelReferences>d__7`1.MoveNext()
    at Spotfire.Dxp.Data.Import.Excel2FileDataSource.<Get PromptModels>d__4`1.MoveNext()
    at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessCon nection.CallbackConnection.<GetPromptModelsCore>d_ _0.MoveNext()
    at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceCon nection.SubprocessImpl..ctor(String[] args)


    ArgumentOutOfRangeException at Syncfusion.XlsIO.Base:
    Specified argument was out of the range of valid values.
    Parameter name: index (HRESULT: 80131502)

    Stack Trace:
    at Syncfusion.XlsIO.Implementation.Collections.Extend edFormatsCollection.get_Item(Int32 index)
    at Syncfusion.XlsIO.Implementation.XmlReaders.Excel20 07Parser.ParseRow(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag, Int32 generatedRowIndex)
    at Syncfusion.XlsIO.Implementation.XmlReaders.Excel20 07Parser.ParseSheetData(XmlReader reader, IInternalWorksheet sheet, List`1 arrStyles, String cellTag)
    at Syncfusion.XlsIO.Implementation.XmlReaders.Excel20 07Parser.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.W orksheetDataHolder.ParseWorksheetData(WorksheetImp l sheet, Dictionary`2 dictUpdateSSTIndexes)
    at Syncfusion.XlsIO.Implementation.WorksheetImpl.Pars eData(Dictionary`2 dictUpdatedSSTIndexes)
    at Syncfusion.XlsIO.Implementation.XmlReaders.Excel20 07Parser.ParseWorksheets(Dictionary`2 dictUpdatedSSTIndexes)
    at Syncfusion.XlsIO.Implementation.XmlSerialization.F ileDataHolder.ParseWorkbook(List`1& themeColors)
    at Syncfusion.XlsIO.Implementation.XmlSerialization.F ileDataHolder.ParseDocument(List`1& themeColors)
    at Syncfusion.XlsIO.Implementation.ApplicationImpl.Cr eateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)
    at Syncfusion.XlsIO.Implementation.Collections.Workbo oksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)
    at Syncfusion.XlsIO.Implementation.Collections.Workbo oksCollection.Open(Stream stream, ExcelOpenType openType)
    at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings. <OpenWorkbook>d__13`1.MoveNext()
    Attachments:
    Lavastorm_Output_Spotfire.png