This dialog provides a list of the worksheets (prefixed S:) and named ranges (prefixed R:) in the Excel spreadsheet. Step 2: Selection of Worksheet or Named Range Select the filename you wish to use and then click OK. This is the usual Genstat File | Open dialog, that prompts you to select the name of the Excel file that you want to read the data from. Opening an Excel file using the import wizard involves 5 steps: Step 1. However, if this open is not select an alternative dialog can be used when opening Excel files using the File | Open item on the menu bar. You can go back at any point to select a new Excel file, page or cell range to ensure you obtain the data you require.īy default, the option Use Import Wizard when opening an Excel file is set within the menu Tools | Spreadsheet Options | Sheets tab dialog. After you have selected the file and worksheet or named range within the file you will be shown a preview of the data. ![]() The Excel import wizard takes you step by step through reading data from Microsoft Excel into a Genstat spreadsheet. See our videos on importing data from Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |