Data Streamer Excel Add-ins: Read Temperature and Humidity in Ms.Excel from Arduino Uno

Поделиться
HTML-код
  • Опубликовано: 25 дек 2024

Комментарии •

  • @べんきょうします-n2w
    @べんきょうします-n2w 10 месяцев назад +1

    THANK YOU SO MUCH!!!

  • @BatmanTan
    @BatmanTan 2 месяца назад

    My datastream excel workbook closed in the middle of recording. I was able to recover the workbook but is there a way to recover the data that was being recorded using the record data function? Where is this data stored while it is recording?

  • @malakkhaled2228
    @malakkhaled2228 2 месяца назад

    is there a way to make the data continue printing in the next 4 coloumns automatically when the number of rows finish

  • @swugcdmx
    @swugcdmx Месяц назад

    excellent work, how much data are we allowed to record?

    • @YaserAliHusen
      @YaserAliHusen  Месяц назад

      I don't know, maybe maximum row in excel ☺️

    • @swugcdmx
      @swugcdmx Месяц назад

      @@YaserAliHusen thanks, also is there any way to store the data with date and time?

    • @YaserAliHusen
      @YaserAliHusen  Месяц назад

      @@swugcdmx , Yes you can, just send date and time in serial output

    • @swugcdmx
      @swugcdmx Месяц назад

      @@YaserAliHusen thank you I will try it out, by the way you mean write in the arduino ide: Serial.print(DATE,TIME);?

  • @carlos.galhano
    @carlos.galhano 3 месяца назад

    Olá. Excelente video. Tenho um problema, quando seleciono o CH340 aparece uma mensagem no Excel dizendo que se encontra a ser utilizado. Deste modo não consigo iniciar a transmissão dos dados. Creio que tem a haver com a versão dos drivers do Windows das portas COM. Alguma sugestão?

    • @YaserAliHusen
      @YaserAliHusen  3 месяца назад

      Você também está abrindo o aplicativo Arduino IDE e está se conectando ao Arduino COM?
      se sim, feche o aplicativo

    • @carlos.galhano
      @carlos.galhano 3 месяца назад

      @@YaserAliHusen Na realidade não, está tudo fechado. Há meses atrás resolvia facilmente o problema indo ao driver da porta COM e revertia o driver para a versão anterior mais antiga, pois cada vez que reiniciava o windows ele teimava em atualizar automaticamente o driver. Só que agora já não tenho essa opção no windows, não sei porquê.

    • @carlos.galhano
      @carlos.galhano 3 месяца назад

      Creio que será mesmo um problema do windows 11 e os drivers para o CH340, várias pessoas reportaram o mesmo problema, no entanto ninguém sabe como resolver.

  • @user-bj4lp3fr1o
    @user-bj4lp3fr1o 5 месяцев назад

    Interesting but the Arduino IDE built in Plotter can do all this except save the data to csv (as far as I know). Also the big chart jumps between 33.7 and 33.8 seem to exaggerate the magnitude of the change.

  • @Pectinman
    @Pectinman 8 месяцев назад

    is there any way to change the time or pace of collecting the data, for instance to collect weight data in a minute by minute basis?? thank you so much master!

    • @YaserAliHusen
      @YaserAliHusen  8 месяцев назад

      You can change the interval of sending data in minute I think

  • @tamilpayan9093
    @tamilpayan9093 9 месяцев назад

    0:29 how to add that data streamer file in excel ....plz tell that bro....i can't do that.... I'm very stressed about my project....team mates are not helping for me😢...as a single man... doing all things

    • @YaserAliHusen
      @YaserAliHusen  9 месяцев назад

      What do you mean?addin data streamer adds on?
      Foolow the video, right click on File Ribbon, then select Customize the Ribbon

    • @tamilpayan9093
      @tamilpayan9093 9 месяцев назад +1

      @@YaserAliHusen bro in 0:29 ....that " Microsoft data streamer for excel" option is not exist in my excel

    • @YaserAliHusen
      @YaserAliHusen  9 месяцев назад

      @@tamilpayan9093 If you don't see an entry for the Data Streamer add-in in the COM Add-Ins dialog box, it's because either your version of Office or Excel doesn't include it, or your organization's system administrator has made it unavailable
      Ref: answers.microsoft.com/en-us/msoffice/forum/all/msexceldont-find-microsoft-data-streamer-on-add/8747a856-ad00-48a7-b4ef-888dee07e5a3

  • @mrkrakenn
    @mrkrakenn 10 месяцев назад

    If I use 2 or more devices, can the data be displayed on the datastreamer?

    • @YaserAliHusen
      @YaserAliHusen  10 месяцев назад

      I don't have experience using multi devices connected.
      I don't know the result, but you can try it😉

  • @prashantshinde6911
    @prashantshinde6911 8 месяцев назад +1

    When I select connect a device in excel sheet it shows unable to connect the device because it is used by another application

    • @YaserAliHusen
      @YaserAliHusen  8 месяцев назад

      Maybe You still use Arduino IDE and connect serial monitor, close Arduino IDE first

    • @manjotsanghera6993
      @manjotsanghera6993 8 месяцев назад

      Don't use serial monitor or serial plotter in the Arduino IDE

    • @carlos.galhano
      @carlos.galhano 3 месяца назад

      I have the same problem. I think its can be a problem from a Windows drivers of COM ports.

  • @willylai1225
    @willylai1225 6 месяцев назад

    Sir, how can I connect on data streamer, cuz only can connect one COM each time, so if I use arduino IDE to run my code, there is no way to connect the data streamer.

    • @YaserAliHusen
      @YaserAliHusen  6 месяцев назад

      Yes, 1 Com cant used more than 1 application.

  • @SuperTheTeddy
    @SuperTheTeddy Год назад

    Great tutorial! I get no data when I press Start data. The Arduino is connected and I have changed the baud to be the same as for my sensor

    • @YaserAliHusen
      @YaserAliHusen  Год назад

      Did you follow the steps?
      and how baout Serial.Print syntax on your code?
      please follow the video about the format of serial print command

  • @andreatia21
    @andreatia21 10 месяцев назад

    hi. thank you so much!!! is there anyway i can save the data with the timestamp?

    • @YaserAliHusen
      @YaserAliHusen  10 месяцев назад +1

      You can send the timestamp from Arduino, you can use RTC module.
      If you use ESP with wifi, you can use NTP to get time

    • @andreatia21
      @andreatia21 10 месяцев назад

      @@YaserAliHusen im new to this. I will try based on advise. Thanks! Btw, can you do a tutorial on how to make esp32 accessible remotely without the same ssid?

    • @YaserAliHusen
      @YaserAliHusen  10 месяцев назад +1

      @@andreatia21 If you just want to control LED on ESP with same network, you can use webserver.
      I have a video about it, find with keyword ESP01

    • @andreatia21
      @andreatia21 10 месяцев назад

      @@YaserAliHusen thanks a lot

  • @opartsa7874
    @opartsa7874 8 месяцев назад

    Can we send HEX from excel to Arduino?

    • @YaserAliHusen
      @YaserAliHusen  8 месяцев назад

      Maybe you can convert in arduino the received serial data

  • @jamessalvador8075
    @jamessalvador8075 10 месяцев назад

    Is there a way to include dates?

    • @YaserAliHusen
      @YaserAliHusen  10 месяцев назад

      You must put date in serial data.
      For getting datetime, you can use ntp or another methods

  • @benmaceachern2243
    @benmaceachern2243 Год назад

    Everything worked perfectly for me except it’s not graphing properly

  • @xc4v866
    @xc4v866 Год назад

    i can't connect my Arduino uno to data streamer when i press on connect to my device nothing happens and no error comes out

    • @YaserAliHusen
      @YaserAliHusen  Год назад

      Did computer detect your uno?
      And dont use serial monitor in arduino ide

    • @xc4v866
      @xc4v866 Год назад

      @@YaserAliHusen yes computer can detect it and it works just fine in arduino ide, but when i close it and open data streamer it can't connect

    • @YaserAliHusen
      @YaserAliHusen  Год назад

      @@xc4v866
      There is no error notification?
      How about Start Data?

    • @xc4v866
      @xc4v866 Год назад

      @@YaserAliHusen its not available since no connection was established