| Author |
 Topic  |
|
|
freddie_mclair
United Kingdom
7 Posts |
 Posted - 11/30/2016 : 02:54:20 AM
|
Hi!
Is there some way that every time I open Origin, it reads some cells from an Excel file, and automatically updates cells on an Origin worksheet? Check the scheme below.
Of course I can do a copy-paste every time, but I would like to have it automatically.
Thanks in advance!
Freddie
Origin Ver. and Service Release: OriginPro 2016 (64bit) b9.3.1.273, Sr1
Operating System: Windows 7 |
Edited by - freddie_mclair on 11/30/2016 04:00:55 AM |
|
|
AmandaLu
439 Posts |
Posted - 11/30/2016 : 04:45:22 AM
|
Hi,
You can try the following:
1. Open the excel file inside Origin, by File: Open Excel.
2. Copy the desired columns and go to the target worksheet, right click on a cell and select Paste link.
3. Save the whole OPJ.
4. Then you can update excel file. When you open the OPJ next time, the data in worksheet will be updated automatically.
To keep the link between the excel file and OPJ, I suggest to save the excel file in the same folder with the OPJ, and check the “Relateive to current project (OPJ) path” in the Workbook Properties dialog (right click on the excel workbook window title and select Properties).
Thanks,
Amanda
OriginLab Technical Service
|
 |
|
|
freddie_mclair
United Kingdom
7 Posts |
Posted - 11/30/2016 : 06:01:47 AM
|
Hi, this worked! Thanks Amanda!
I have to keep the Excel workbook always inside Origin, right?
Another thing, how do I avoid to press "Yes" on the "Start DDE Link" query every time Origin starts? I mean, I would like it to select "Yes" automatically, and avoid several clicks.
Thanks again! |
Edited by - freddie_mclair on 11/30/2016 06:02:47 AM |
|
|
|
snowli
USA
1395 Posts |
|
| |
Topic |
|
|
|
Auto-import cells from Excel file when open Origin