Getting error message while opening the excel file in Spotfire

[Praba Karan]

Here is the error message:

Error message: Unable to import data. See the details for more information.

ImportException at Spotfire.Dxp.Forms:

Unable to open file \entsin-fil02AppsData-SSpotfireWEBI_ACTUAL_20.xlsx (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromFile(String filePath)

at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenFiles(IEnumerable`1 filePaths, String errorDialogTitle)

 

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.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromFile(String filePath)

 

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query for data source "WEBI_ACTUAL_20". (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.DataSourceConnection.d__2.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__DisplayClass2.b__0()

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

 

ImportException at Spotfire.Dxp.Data:

Get message from subprocess timed out. (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.b__28()

at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.c__DisplayClass30`1.b__2f()

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.d__24.MoveNext()

at Spotfire.Dxp.Data.DataSourceConnection.d__2.MoveNext()

[Kirsten Smith (she/her)]

For us to fully investigate why you are getting this error you would need to file a Support Ticket so that we can file a defect report. There are a couple of ways to get around this:

 

1. Open the file in Excel then click on File/Save As/*.csv file. This removes all of the Excel formatting and makes it simpler to open in Spotfire.

2. Open the file in Excel then highlight all of the desired data in the sheet. Then in Spotfire you can click on the plus sign (+)/Other/Paste from Clipboard.