forked from soldat172/Automatic-AP-Color-Audit-Script
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Auto Script 0.1.0.py
109 lines (93 loc) · 3.3 KB
/
Auto Script 0.1.0.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
import openpyxl, pyautogui
from tkinter import filedialog, Tk
from openpyxl import Workbook, load_workbook
redAPs=[]
greenAPs=[]
orangeAPs=[]
blueAPs=[]
count1 = 0
greenAPsCount = int('0')
redAPsCount = int('0')
orangeAPsCount = int('0')
blueAPsCount = int('0')
excelNameColumnLetter = 'A'
excelFailColumnLetter = 'K'
excelNameRow = int('3')
excelFailRow = int('3')
excelNameColumnNumber = str(excelNameColumnLetter) + str(excelNameRow)
excelFailColumnNumber = str(excelFailColumnLetter) + str(excelFailRow)
Tk().withdraw() # We don't want a full GUI, so keep the root window from appearing
excelName = filedialog.askopenfilename() # Show an "Open" dialog box and return the path to the selected file
book = load_workbook(excelName)#Opens Excel
sheet = book.active #Makes the current sheet active
for x in range (0,100):
excelFailColumnNumber = str(excelFailColumnLetter) + str(excelFailRow)
excelNameColumnNumber = str(excelNameColumnLetter) + str(excelNameRow)
specificCellValue = sheet[excelFailColumnNumber]
specificCellValue2 = sheet[excelNameColumnNumber]
apFail = specificCellValue.value
apName = specificCellValue2.value
if apFail == 1:
print ('green')
greenAPs.append(apName)
print(greenAPs[greenAPsCount])
greenAPsCount += 1
elif apFail == 2:
print ('red')
redAPs.append(apName)
print(redAPs[redAPsCount])
redAPsCount += 1
elif apFail == 3:
print ('orange')
orangeAPs.append(apName)
print(orangeAPs[redAPsCount])
orangeAPsCount += 1
elif apFail == 4:
print ('blue')
blieAPs.append(apName)
print(blueAPs[redAPsCount])
blueAPsCount += 1
else:
print(apFail)
print('Outside 1-4 value')
excelFailRow += 1
excelNameRow += 1
pyautogui.hotkey('ctrl', 'f')
pyautogui.press(['tab','tab'],interval=.05)
pyautogui.press('down')
pyautogui.press('esc')
for x in greenAPs:
temporaryValue = greenAPs[count1]
parentSiteName,idfNumber,apNumberNaked = temporaryValue.split('-') # Splits the ap name into 3 parts
print(apNumberNaked)
pyautogui.hotkey('ctrl', 'f')
pyautogui.typewrite(apNumberNaked)
pyautogui.press('enter')
pyautogui.press('esc')
pyautogui.hotkey('alt', 'h')
pyautogui.press('l')
pyautogui.press(['down','down','down','down','down','down','down'])
pyautogui.press('left')
pyautogui.press('enter')
pyautogui.hotkey('alt', 'h')
pyautogui.press('i')
pyautogui.press(['down','down','down','down','down','down','down'])
pyautogui.press('left')
pyautogui.press('enter')
pyautogui.press('esc')
pyautogui.press('tab')
pyautogui.press('enter')
pyautogui.hotkey('alt', 'h')
pyautogui.press('l')
pyautogui.press(['down','down','down','down','down','down','down'])
pyautogui.press('left')
pyautogui.press('enter')
pyautogui.hotkey('shift', 'tab')
pyautogui.hotkey('shift', 'tab')
pyautogui.press('enter')
pyautogui.hotkey('alt', 'h')
pyautogui.press('l')
pyautogui.press(['down','down','down','down','down','down','down'])
pyautogui.press('left')
pyautogui.press('enter')
count1 += 1