Open Excel Workbook

Click the Import all sheets to a Workbook button in the Opening File dialog box to display the Open Excel Workbook dialog box, which contains options for importing the worksheet to a workbook.

When an Excel file is open in Statistica, Reporting Tables are available from the Data menu.

Note: Statistica stores dates as the number of days since January 1, 1900. This number of days is often called a Julian date. By default, Excel also stores dates in this manner, but provides an additional option to use January 1, 1904 as the base date rather than January 1, 1900. When importing an Excel file that has this 1904 option set, Statistica automatically adjusts the Julian date to offset from January 1, 1900. This makes the dates display the same in both Excel and Statistica, though the underlying numbers are different.
Option Description
File name Displays the name of the Excel file.
For each imported sheet Lists the following options.
Ask me about formatting You can select this check box and click the OK button to specify the format in the Open Excel File dialog box.
Get variable names from first row You can select this check box to import the first row of the worksheets as the variable names rather than the first column.
Get case names from first column You can select this check box to import the first column of the worksheets as the case names rather than the first row.
Import cell formatting You can select this check box to specify the formatting to be imported to the new spreadsheet.
Don't create text labels for numeric variables Excel spreadsheet data can contain numbers and text. You can select this check box to place missing data in the cell in place of a text label/value pair. If the target variable is text, this option has no effect.