Convert table to Excel Worksheet
gravityhomer
I have been running an experiment at work and have been logging and analyzing all the data with Igor, because it is just easier for me, but most people here can't handle anything other than Excel, so I need to convert most of the tabulated data into an excel workbook for others.
I can set up all the data on about 14 tables (that I generate with a function I've written). I'm wondering if there is any way to export a table as a worksheet in excel, and ideally pack a bunch of tables together as different worksheets all in the same workbook. But do this in an automated way.
I'm thinking this is too much to ask and I would probably need to do something with VBA tapping Igor occasionally (groan) which would probably take me forever to figure out.
Any ideas?
Thanks,
gh
It must have been you that I talked to on the telephone today. I pointed you at the Save command and the SaveTableCopy command. I think it should do what you need, but I would be interested in any updates on the project.
John Weeks
WaveMetrics, Inc.
support@wavemetrics.com
May 27, 2009 at 04:37 pm - Permalink
You are right, you could use VBA in Excel to pull the data from a running copy of Igor. You are also right that there is a learning curve involved. See "Igor Pro Folder\Miscellaneous\Windows Automation". Among other things, it includes some Visual Basic examples.
May 27, 2009 at 07:57 pm - Permalink