ADICON Support Forum Applied Digital, Inc.
Page 1 of 1 1
Topic Options
#21327 - 09/07/09 02:42 PM Data Exraction in Excel?
Dirtbag Offline
newbie


Registered: 06/29/08
Posts: 16
I would like to extract variables and timer information from my ocelot and insert this into a spreadsheet for graphing. I would prefer to have a macro within excel initiate the data collection and not do real time. Is there an easy way to do this? I am not familiar with writing code but if i could automate this it would save the time of manually viewing and inputting the values, and it would be cool.
Top
#21328 - 09/07/09 06:42 PM Re: Data Exraction in Excel? [Re: Dirtbag]
Guy Lavoie Administrator Offline
Beyond All Hope
*****

Registered: 12/21/02
Posts: 6401
Loc: Montreal, QC, Canada
Can an Excel macro send serial data to a Com port and read data coming back? To do that it would need to be able to run an external executable program or something. The following FAQ entry contains the commands needed to get variable and timer data from the controller:

http://www.appdigusers.com/forums/ubbthreads.php/ubb/showflat/Number/15465#Post15465
_________________________
"If you don't know what you're doing, do it neatly..."

Top
Page 1 of 1 1


Moderator:  Dan Smith, Monte G, ADI Tech Support, Guy Lavoie 
Hop to:
Who's Online
3 registered (pbir, Bent, Martin in Texas) and 31 anonymous users online.
Recent Posts
SECU16IR Output Connecting To A Xantech Connecting Block
by Jean-Marie
Today at 08:36 AM
SECU16IR Output Connecting To A Xantech Connecting Block
by Jean-Marie
Today at 08:34 AM
how to post an icon
by manu
02/03/12 03:40 AM
Command Pair
by kuro
02/01/12 12:49 AM
Does anyone have a copy of the latest TSE?
by sevenzenith1
01/30/12 05:17 AM
Shout Box

Newest Members
feshh, manu, kuro, chuck214, Funkhauser
2747 Registered Users
Forum Stats
2747 Members
19 Forums
3837 Topics
22713 Posts

Max Online: 67 @ 08/16/11 03:08 PM
February
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29