how to send data from excel sheet to thingspeak automatically
显示 更早的评论
Hello Frineds
I am very new to this platform and just explore some very usefull features.
I did test to send data from LabVIEW to thingspeak and also upload my csv file.
what i want is that as my csv file updated on daily basis so i want this updated data should also send to thingspeak.
Any guid or help please?
Thanks
Asif
4 个评论
Christopher Stapels
2023-7-7
To call an API from Excel, Go to the “Data” tab and click on “New Query” → “From Other Sources” → “From Web”
- Click on “Advanced”
- Paste the API URL on the prompt and click OK
- Select Into Table on the Convert tab
The URL looks like this
https://api.thingspeak.com/channels/<channel_id>/feeds.<format>
https://api.thingspeak.com/channels/<channel_id>/feeds.csv
Asif Iqbal
2023-7-10
移动：Christopher Stapels
2023-7-11
Christopher Stapels
2023-7-10
移动：Christopher Stapels
2023-7-11
you have data in a csv file that you want to automatically send from your computer to ThingSpeak when you update the data?
Asif Iqbal
2023-7-11
移动：Christopher Stapels
2023-7-11
回答（1 个）
Christopher Stapels
2023-7-11
0 个投票
Probably the best way would be to use MATLAB installed on your machine. You can use ThingSpeak write and automate a process in a few different ways,
There is also a write data API that you can send data to, but you would have to look into some way to automate that command based on your computer. If you have a Linux machine, for example, you can use a cron job. Windows has a task scheduler that might help. If you come up with a good tool to use, please post here if you can.
社区
更多回答在 ThingSpeak Community
类别
在 帮助中心 和 File Exchange 中查找有关 Downloads 的更多信息
2023-7-7
2023-7-11
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
