07-15-2022 02:59 AM
Hello,
I want to import signal previously saved by LabView as .xlsx file and also import signal generated by matab in .xlsx file. Afterwards I want to run the signal for let's say 1000Sample/s and do further calculation
I also want to get a steady spectrum of the signal directly from excel data.
I am trying different VI, but couldn't find anything yet. Can anyone guide me?
Thank you in advance
07-15-2022 04:53 AM
Hi mub,
@mub.re wrote:
I want to import signal previously saved by LabView as .xlsx file and also import signal generated by matab in .xlsx file.
To read Excel XSLX files you should use functions from ReportGeneration toolkit.
LabVIEW comes with example VIs (in the example finder) that explain how to use them…
@mub.re wrote:
Afterwards I want to run the signal for let's say 1000Sample/s and do further calculation
I also want to get a steady spectrum of the signal directly from excel data.
07-15-2022 03:59 PM
Hello,
Thank you for your help.
So Steady Spectrum was a poor choice of word. Normally the signal spectrum shows continuous value. What I want is a spectrum generated by last 1 minute’s value and update every 1 or t minutes. Is there any VI for that?
Thanks
Best regards
07-15-2022 05:01 PM
You failed to attach VIs showing what you are trying, which would give us a whole lot of useful data and allow us to make "intelligent" suggestions.
Here are some questions I have:
Bob Schor
07-15-2022 05:40 PM - edited 07-15-2022 06:06 PM
Hi,
Here is the whole VI, I have random Sine wave generated by matlab and saved as xlsx file. Now I want to see the wave graph and spectrum and run through weight filter to get rms value. Till now I wasn't able to read the file, but now I can read the file, but I want to read it 1000sample/s, otherwise weight filter doesn't support it. And it seems like the wave graph value is actually the frequency value, not in wave form
Thanks
07-16-2022 05:59 PM
In order to open and test your Top Level VI (which you attached), we need to be able to also run all of its sub-VIs. If you are developing your code using a LabVIEW Project (file and Folder), then you can compress the Project Folder (which contains the Project File, the top-level VIs, and should also contain the sub-VIs and Type Defs) and attach the resulting .zip file.
Your "data file" ("file.xlsx") is a 1 column x 229112 rows Excel file that (mostly?) contains Floating Point numbers in the range -20 .. 20. Are these sampled data taken at a fixed sampling rate (such as 1 kHz)? Note that to do any Time Series analysis of these data, the "time" component must be specified.
Just for fun, I used the Report Generation Toolkit to open this data file, read all of the data into a 2D Excel Dbl array, extracted the (1-D) data, and plotted 229 1000-poinr Graphs at a rate of 1/sec, just to see what's there. Looks pretty noisy, with no obvious pattern (except during the first few seconds).
So what is it you expect these data to represent, and what do you want to do with them?
Bob Schor