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
 Overwrite new books/sheets
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

esatpehlivan

Sweden
Posts

Posted - 03/06/2009 :  09:23:09 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin v8.0951
Operating System: XP

Hello,

I have a question about automation of drawing graph.

When I do an experiment, I draw some graphs using obtained data. When I do another experiment, I draw exactly the same type of graphs using the new data. Instead of setting up the plots (axis name, scale, colors, explanations etc.) every time, I do something different. I make a copy of Origin file, then rename it as required, then delete the workbook (when I delete workbook, the graphs show nothing but scales, axis names etc. remain), create a new workbook, import my new data to this workbook, and use "Plot Setup" for associating links between graphs and data. I do not want to do this every time. What I want to do is, simply, change/overwrite the workbook. Copying new data and pasting it on old data in renamed file is a solution too, but my workbook includes more than 20 sheets, doing Copy-Paste 20 times takes more time than what I mentioned above.

Is there an easy way to overwrite the data in the workbook to update the graphs with the new data?

There is "1st File Import Mode" in the "Import & Export" session. The options are "Start New Books" and "Start New Sheets". What I need is something like "Overwrite New Books/Sheets" option (I always have the same number of columns and the same column names).

Deanna

China
Posts

Posted - 03/09/2009 :  10:18:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Are you importing data from Excel files? For ASCII import, Origin offers the option to overwrite the existing data.

Deanna
OriginLab Technical Services
Go to Top of Page

esatpehlivan

Sweden
Posts

Posted - 03/11/2009 :  10:49:04 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Yes, I import data from Excel files.
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