How to filter the data.

5 ビュー (過去 30 日間)
Nguyen Trung Hieu
Nguyen Trung Hieu 2021 年 8 月 2 日
コメント済み: Nguyen Trung Hieu 2021 年 8 月 3 日
Hi guys. I'm having a hard time right now and I hope you can help!
- I have some parameters taken from the motion of the sensors and transferred this data to Google Sheet, then from GG Sheet transmitted to MATLAB and gave the results as shown. All are automatically transmitted 24/24.
- The next step I need to do is save as an excel file (including 4 sheets). Because each movement of the sensor will be filtered into a sheet that matches the pre-set conditions. And then will plot the parameters in each corresponding sheet into a waveform.
Thanks! Hope the helping.
  1 件のコメント
Rik
Rik 2021 年 8 月 2 日
You put your question in the title, instead of the question body. Please edit your question.
Have a read here and here. It will greatly improve your chances of getting an answer.

サインインしてコメントする。

回答 (1 件)

Peter Perkins
Peter Perkins 2021 年 8 月 2 日
Not sure how you are getting those data into MATLAB, but I suggest that you figure out why you have a cell array. You want a table, actually you probably want a timetable. Once you have that, it's trivial to write it out using writetable.
  1 件のコメント
Nguyen Trung Hieu
Nguyen Trung Hieu 2021 年 8 月 3 日
Hello
Those cell arrays appear, but that's because this data is pulled entirely from Google Sheets. As for why I can get those numbers, I use Google Sheet in combination with Arduino. I use Arduino to code the sensors, so that when the sensors are moved the corresponding numbers are output to a Google Sheet. And MATLAB will take the parameters from there.
Thank you!

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by