See more related video:Working with Excel
For many years, Origin supported an OLE instance of MS Excel within the Origin workspace, even though it severely limited access to Origin's graphing and analysis tools. Over time, users have reported an increase in problems and as a result, OriginLab decided to remove user interface controls for launching OLE instances of Excel.
We strongly recommend that you use the Excel Data Connector for importing Excel data. The Excel Connector is fast and you have full access to Origin's graphing and analysis tools. If using the Excel Connector is not an option, please see this topic.
There are two ways to work with Microsoft Excel data in Origin:
If you are periodically updating an Excel file, there are a couple of ways of passing updates to Origin:
Importing data with a Data Connector creates a live link between the Origin workbook and the source data. Thus, when source data are updated, it is easy to update the Origin workbook and any dependent plots.
It may be desirable at times to simply copy Excel data from a workbook opened in Excel and paste/paste link into Origin to access Origin's powerful graphing and analysis features. If you choose to paste Excel data as link, any change in that Excel workbook will dynamically update Origin project.
When copy data from Excel to Origin, it will copy the full precision rather than the number of digits displayed in Excel. For more complicated data that has been copied from Excel, Origin includes the ability to use its Import Wizard on Clipboard data.
When copying and pasting date or time data from Excel, consult the following FAQs:
Topics covered in this section: