- Thu Sep 20, 2018 9:38 am
#78312
Hi
If you want to use Excel there is an easy way to do this.
Excel is able to use data from 'the web'
If you set up your sensors to create web pages with your data in a table then excel can extract this automatically at defined intervals.
As you're a newb I suggest:
1. Get your sensor to generate a web page showing the data you want to capture. Check it with a browser.
2. Encapsulate the data in a html table & repeat
3. In Excel go to the 'Data' tab & select 'From web'
4. Enter the IP address of a sensor - you should see a preview page
5. Choose the data you want to import
I've used this a lot & it works great.
Something like MQTT might be better but if you only have a few sensors this will work well.
Hope this helps
Ian
If you want to use Excel there is an easy way to do this.
Excel is able to use data from 'the web'
If you set up your sensors to create web pages with your data in a table then excel can extract this automatically at defined intervals.
As you're a newb I suggest:
1. Get your sensor to generate a web page showing the data you want to capture. Check it with a browser.
2. Encapsulate the data in a html table & repeat
3. In Excel go to the 'Data' tab & select 'From web'
4. Enter the IP address of a sensor - you should see a preview page
5. Choose the data you want to import
I've used this a lot & it works great.
Something like MQTT might be better but if you only have a few sensors this will work well.
Hope this helps
Ian
