Does Statistica support opening password protected excel files?

Does Statistica support opening password protected excel files?

book

Article ID: KB0074222

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.2 and higher

Description

This article reports that Statistica is not able to open password encrypted excel files. 

When trying to open a password encrypted/protected excel file from Statistica File | Open menu, Statistica gives error message either "File format not supported" or "Could not find data stream in specified file.".

This problem also occurs to "Import Excel" node in workspace.

Issue/Introduction

Statistica does not support to open password protected excel files.

Environment

Windows

Resolution

The function of popping up a dialog for user to enter password is an Excel functionality. Statistica does not have control over it. Therefore, Statistica only support no password encrypted excel files.