During Excel re-importing, a link is maintained so that Origin is able to use up-to-date data.
To re-import one or multiple Excel sheets:įrom Origin 2015, you are allowed to re-import multiple sheets from Excel to Origin. Origin opens a secondary dialog box - the impMSExcel dialog box - when you click the OK button.Click the buttons (see the picture below) over the import file list to sort the files by File Name, Size or Modified date.Use the Remove File(s) button to remove selected files from the import file list.Make necessary adjustments in the impMSExcel dialog box, then click the OK button to import the files into Origin.For more information about this setting, please see below. After choosing all the files, click the OK button. Add your files one at a time or press CTRL or SHIFT to select multiple files, and click Add File(s).Select Data: Import from File: Excel (XLS, XLSX, XLSM)., or click the Import Excel button located in the Standard toolbar.To change the value of a system variable, see this FAQ. To revert to previous behavior where this button opened the impMSExcel dialog box, set LabTalk system variable = 2. Importing Excel Data using the impMSExcel X-Function Dialogīeginning with Origin 2021b, clicking the Import Excel button will open the Excel Import Options Data Connector dialog box. Once you have imported your file, you can Add and Connect Sheet(s) to add other sheets in your Excel file using the the Data Navigator panel.To disable sparklines on import, set = 0. To add sparklines on import, click the Other Options button (to the left of OK) and select a radio button.For partial import, check Partial Import and enter ranges for Column and Row following the in-dialog examples or by referring to the Custom syntax outlined in this table.To manually specify the location of Column Labels, including Comments From and Comments To, edit the accompanying combo boxes. When sub-header lines are detected, the Column Labels box is checked and Long Name and Units rows are automatically specified.Use this to specify saving header info to the Worksheet label area or the Book organizer. If you clear Auto and enter the number of Main header lines, an additional Save file header to drop-down is added to the dialog.
Header lines will be added to a File Header label row.