From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Reading data from spreadsheet
DiPS
Member
04-12-2007 11:34 PM - edited 04-12-2007 11:34 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
Hey!
I’m a mech. Engg student doing my project on remote monitoring of vibration.
The hardware I’m using is compatible with software called RT Pro.
Using RT Pro I’m able to export a Acceleration VS Time graph values into excel.
I’d like to use this excel sprdsheet to generate a signal in
However the RT Pro s/f plots only 1024 points at a time, which means that there will be 1024 time data and corresponding Accl data (y values) in excel at a time(sample sprdsheet attached http://forums.ni.com/attachments/ni/170/241423/1/Spreadsheet.txt) The s/f continuously changes these values(y values) in excel as new values are plotted in the graph. I have attached screenshots below of the excel sprdsheet before and after a small interval.
BEFORE:
http://imgfreehost.com/out.php?i7550_2.JPG
AFTER:
http://imgfreehost.com/out.php?i7547_3.JPG
I’m able to access the excel file in
To make it more clear, I want to get these continuously changing excel data in
I hope the question doesn’t sound very vague. I believe it might be possible to do this with ActiveX, but I’m a novice to
ThanX,
DiPS
Message Edited by DiPS on 04-12-2007 11:37 PM
Message Edited by DiPS on 04-12-2007 11:39 PM
Message Edited by DiPS on 04-12-2007 11:42 PM
Download All
Virus scan in progress. Please wait to download attachments.
gwd
Active Participant
04-13-2007 07:31 AM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
A couple of thoughts:
- is the data continuous? That is, does each new record follow the preceding one with no gap in data? If not there is no point in trying to append the data sets.
- is that really a 0.05 sec record? Getting Labview to read a new set of data from disk without gaps every 50 msec is probably not realistic.
Now if you just want to replace and update the data in Labview, and you don't care about missing data sets, it should be no problem.
- is the data continuous? That is, does each new record follow the preceding one with no gap in data? If not there is no point in trying to append the data sets.
- is that really a 0.05 sec record? Getting Labview to read a new set of data from disk without gaps every 50 msec is probably not realistic.
Now if you just want to replace and update the data in Labview, and you don't care about missing data sets, it should be no problem.
04-15-2007 11:55 PM
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report to a Moderator
hey thanx for the reply...
ya, i know getting new data every 50usec from the HD can't probably work......
i'm indeed more concerned about changing and updating the data available to labview... basically i want a dynamic XY-chart as opposed to the static one i have now... that's the problem i'm having as LV shows only the values at the time of saving the spreadsheet in excel
