"Could not read the selected data" when opening Excel file in TIBCO Spotfire client

Product: TIBCO Spotfire Analyst

Versions: 10.3, 10,4, 10,5, 10.6, 10.7

Summary:

This article describes how to use a different Python interpreter for TIBCO Spotfire Analyst and the Python Service

Details:

When trying to open Excel files in the TIBCO Spotfire installed or web client, you get the following error message:

Error message: Could not read the selected data.

NullReferenceException at System.Windows.Forms:
Object reference not set to an instance of an object. (HRESULT: 80004003)

Stack Trace:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Spotfire.Dxp.Forms.Application.FormsApplicationThread.InvokeOnUIThreadAndTransferTransactionStartPermission(ApplicationInvocation method)
at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.InvokeAndTransferCurrentInfo(ApplicationThread invoker, ApplicationInvocation method)
at Spotfire.Dxp.Forms.Application.FormsProgressService.PerformPrompt(Func`1 promptMethod)
at Spotfire.Dxp.Forms.WebView.FormsAddDataController.InvokePromptingOperation(String title, String description, AddDataPromptingOperation operation, Action`1 onFinished)

Resolution:

This issue has been addressed from version 10.8, as well as in hotfix HF-011 for 10.3, and hotfix HF-001 for 10.7.