Import a Excel file in Spotfire doesn't work

I want to import a Excel file which is used as a dashboard but had a datapage which i need. But when i want to impoty the file i get this:



 

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query for data source "weeklydashboard 18-19". (HRESULT: 80131500)

Stack Trace:

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.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__DisplayClass13_0.<CreateConfiguredDataSourceFromFile>b__0()

   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()



ImportException at Spotfire.Dxp.Data:

Object reference not set to an instance of an object. (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__13.MoveNext()

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()



NullReferenceException at Syncfusion.XlsIO.Base:

Object reference not set to an instance of an object. (HRESULT: 80004003)

Stack Trace:

   at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParseCalculatedItems(XmlReader reader, PivotCacheFieldsCollection cacheFields)

   at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParsePivotCacheDefinition(XmlReader reader, PivotCacheImpl cache, IWorkbook book, String path, RelationCollection relations, String& cacheRecordRelationID)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCache(String strWorkbookPath, String relationID, String& strItemName)

   at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCaches(String strWorkbookPath)

   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__56`1.MoveNext()

   at Spotfire.Dxp.Data.Import.Excel2DataSourceSettings.<ApplyHeuristics>d__53`1.MoveNext()

   at Spotfire.Dxp.Data.Import.Excel2FileDataSource.<GetPromptModels>d__18`1.MoveNext()

   at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__4.MoveNext()

   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)

 

(1) Answer

Login