Our needs are to automate the graphing of excel work-books containg anything from one to 20 work-sheets. Currently we use our own Visual_Basic modules but find we still need to graph manually, which takes a long time. Can someone advise that Origin 7 is the best way to solve these problems?
If you open your Excel Workbooks as Origin Worksheets then you should be able to write a script that does it all.
Here's a simple script that prompts for a workbook file, then proceeds to plot all columns of all sheets in the workbook.
// Warning! This script closes the current Origin document doc -s; doc -n; win -c Data1; getfile *.xls; system.excel.openasexcel=0; system.excel.openasprompt=0; doc -A %B%A; doc -e W { wo -s 0 0 0 0; wo -p 200 line; }
If you open your workbooks as Excel workbooks and if you can put some constraints to your request - such as knowing what sheets are called in each workbook, how many sheets per workbook and your column data is typically XYY.. then the task could also be done, but in this case, a better approach would be to use Origin Pro and use the COM interface to Excel. COM gives you better communication between Origin and Excel so your code can be much more sophisticated.
Prospective Buyer
Posted - 06/20/2003 : 05:02:42 AM
