0

How to identify a color (green/red)in a csv file and trigger a message to mobile using python

If any time my excel sheet shows a red color of a service I wanted to be alerted on my mobile via message is that possible ?

25th Jul 2019, 7:43 PM
Pavan Kumar M
Pavan Kumar M - avatar
2 Antworten
+ 1
I think so... You might want to create 2 functions. 1 to check the cells and 1 to send the SMS. Check out "pandas", "openpyxl" or "xlsxwriter". You might want to use a while loop and check your cells. If there is a change in color, send message, else, continue. You might also benefit from using sleep() to wait in between polling periods
25th Jul 2019, 11:10 PM
Steven M
Steven M - avatar
0
Thanks for the response I will try this
26th Jul 2019, 9:44 AM
Pavan Kumar M
Pavan Kumar M - avatar