The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Working with Excel_Setting column values		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Sarath_2010

22 Posts
Posted - 07/13/2013 :  05:15:20 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8.0
Operating System: Win Vista Business (32-bit)

Is there a way to set column values in a book using columns from an excel book in the same folder? Essentially, I need to call values from the excel worksheet within the origin folder and populate my origin column for further analysis. Also, is there a way to set column values in one book using values in a column in another book?
Thanks.

JacquelineHe

287 Posts
Posted - 07/15/2013 :  03:36:52 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sarath,

You can declare range variable for a column from Workbook or Excel window.

I assume the Excel window is "Book2" in the Origin project. You can open the Set Column Value dialog in another workbook and enter this script to the Before Formula Script panel to call the column. 

range aa=[book2]sheet1!1;
//Book2(excel book) sheet1 column1



Thanks
Jacqueline
OriginLab
Go to Top of Page

Sarath_2010

22 Posts
Posted - 07/15/2013 :  08:18:59 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Jacqueline,
I am unable to make it work by following your steps. I even tried changing the excel workbook properties from external to internal (to align with what I see you have done) and also tried unchecking the "Do not save, read only option". Still no change! My 'set column values' always returns empty cells.



Please let me know where am I going wrong with this.
Thanks.

Best,
Sarath.
Go to Top of Page

JacquelineHe

287 Posts
Posted - 07/16/2013 :  02:30:43 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sarath,

You can try to right-click on the Excel window, and select Update Origin in the context menu.



If you set the Recalculate: Auto in the Set Column Value dialog, the column value will be updated.

Thanks
Jacqueline
OriginLab
Go to Top of Page

Sarath_2010

22 Posts
Posted - 07/16/2013 :  03:39:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks, Jaqueline! That saved my day.
But I wonder why even after the recalculate is set as auto, as shown in my previous post, I have to update origin to update the workbook. Interestingly, a graph using values from excel gets automatically updated once the excel sheet is changed, without clicking 'update origin'.
Go to Top of Page

JacquelineHe

287 Posts
Posted - 07/16/2013 :  10:02:43 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sarath,

When you using Excel in Origin, there are some problems occasionally.

Please refer to the second section of this help page:
http://www.originlab.com/www/helponline/Origin/en/UserGuide/Troubleshooting_Problems_Using_Excel_in_Origin.html

Additional, if you require full access to all of Origin's graphing and analysis features, I suggest you would import your Excel data files into Origin.
(Select File: Import: Excel(XLS, XlSX...) in the menu. )

Thanks
Jacqueline
OriginLab
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000