STATISTICA Blogs

STATISTICA supports analyses from Excel workbooks that are embedded in a STATISTICA Workbook, Excel spreadsheets in STATISTICA stand alone windows, or as Excel workbooks.

To open an Excel file in STATISTICA, select Open from the File menu (classic menus) or click Open in the File group on the Home tab (ribbon bar) to display the Open dialog.

Browse to the Excel file, select it, and click the Open button. The Opening file dialog is displayed.

Click the Import all sheets to a Workbook button to display the Open Excel Workbook dialog,

which contains additional options for importing the entire Excel workbook to a STATISTICA Workbook.

In the Opening file dialog, click the Import selected sheet to a Spreadsheet button to display the Select Sheet to Import dialog,

where you can select the specific sheet you want to import into a STATISTICA stand-alone window.

In the Opening file dialog, click the Open as an Excel workbook button to open the selected Excel file in STATISTICA using ActiveX technology. The Excel and STATISTICA menus and toolbars will merge, providing access to Excel functionality.

In the Opening file dialog, select the Set as default check box to specify that your selection in this dialog will be the default handling of Excel files on import in the future.

sb