/
RunTests.py
73 lines (53 loc) · 1.69 KB
/
RunTests.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
__author__ = 'rvoorheis'
# -*- encoding: UTF-8 -*-
import PrintParameters
import PrintLabel
import ExcelControl
import RowContents
import ProgressBar
import socket
import MakeBMP
import sys
def main(argv):
global debug #debug flag
debug = False
try:
parms = PrintParameters.PrintParameters(argv)
parms.Display_parameters()
w = ExcelControl.ExcelControl()
wb = w.openworkbook(parms.wbInputFileName)
ws = wb.get_sheet_by_name("Sheet1")
pl = PrintLabel.PrintLabel(ws, parms)
pb = ProgressBar.ProgressBar(25, "Progress:")
ToDo = 0
RowCounter = 0
LastRow = ws.max_row + 1
for row in range(2, LastRow):
rc = RowContents.RowContents(ws, row)
if rc.ProcessRow:
ToDo = ToDo + 1
print("reading rows")
for row in range(2, LastRow):
assert row <= LastRow
rc = RowContents.RowContents(ws, row)
if rc.ProcessRow:
# print (str(row-1) + " of " + str(counter))
pl.printlabel(rc, ws)
RowCounter = RowCounter + 1
pb.update_progress(float(RowCounter), float(ToDo), str(rc.Label))
wb.save(parms.wbInputFileName)
except LookupError as e:
print("Lookup Error " + str(e))
quit(-2)
except NameError as e:
print("Error! - Invalid Filename = " + str(e))
quit(-3)
except StandardError as e:
print("Error! - Standard Error = " + str(e))
quit(-3)
except Warning as e:
print("Warning " + str(e))
quit(-1)
return True
if __name__ == '__main__':
main(sys.argv[1:])