All Forums  Origin Forum  Origin Forum  Overwrite new books/sheets

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by esatpehlivan[/i] [br]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). [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.