-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathQC4_HV_Data.py
96 lines (92 loc) · 3.54 KB
/
QC4_HV_Data.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
#!/usr/bin/env python
from datetime import datetime,date,time
from time import sleep
from xml.etree.ElementTree import Element, SubElement, Comment, tostring
#import serial
import time
import xlrd
from xlrd import xldate
import re
import sys
#import statistics
from xmlConversion import generateXMLHeader, generateDataSet, writeToFile,writeToFile1
from xmlConversion import generateXMLDatafastamb,generateXMLDatafast,generateXMLDatalongamb,generateXMLDatalong, generateXMLData3,generateXMLData3a,generateXMLData4,generateXMLData4a,generateXMLData5a,generateXMLData5,generateXMLData4s
#from flask import Flask, render_template
#from flask_sqlalchemy import SQLAlchemy
#from sqlalchemy import create_engine, MetaData, Table, and_
#from sqlalchemy.sql import select
#import cx_Oracle
#import json
def xml_from_excel4(excel_file):
wb = xlrd.open_workbook(excel_file)
sh = wb.sheet_by_index(0)
req = sh.cell(1,16).value
pre = sh.cell(5,16).value
amp = sh.cell(8,16).value
coa = sh.cell(9,16).value
fine = sh.cell(10,16).value
itime = sh.cell(12,16).value
dtime = sh.cell(13,16).value
disc = sh.cell(16,16).value
thrs = sh.cell(17,16).value
scal = sh.cell(20,16).value
daq = sh.cell(21,16).value
Start=sys.argv[7]
Stop=sys.argv[8]
chamber=sys.argv[2]
Date=str(Start[0:10])
location=sys.argv[4]
#user=sh.cell(1,7).value
user=sys.argv[5]
comment=sys.argv[6]
Comment=sys.argv[11]
Run=sys.argv[3]
root = generateXMLHeader("QC4_HVTEST_CONFIG","GEM Chamber QC4 HVTEST Configuration",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user)
dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber)
generateXMLData4a(dataSet,str(req), str(pre),str(amp),str(coa), str(fine), str(itime),str(dtime),str(disc),str(thrs),str(scal),str(daq))
writeToFile(fileName, tostring(root))
root = generateXMLHeader("QC4_HVTEST_DATA","GEM Chamber QC4 HVTEST Data",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user)
dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber)
for row in range(3, sh.nrows):
if sh.row_values(row)[0]=='':
break
vset = sh.row_values(row)[0]
vmon= sh.row_values(row)[1]
iset =sh.row_values(row)[2]
imon= sh.row_values(row)[3]
rcal =sh.row_values(row)[4]
rnorm=sh.row_values(row)[5]
count=sh.row_values(row)[6]
rate= sh.row_values(row)[7]
error=sh.row_values(row)[8]
generateXMLData4(dataSet,str(vset), str(vmon),str(iset),str(imon), str(rcal), str(rnorm),str(count),str(rate),str(error))
writeToFile(datafile, tostring(root))
v_max = sh.cell(25,16).value
test_date=Start
v_drift = sh.cell(26,16).value
i_max = sh.cell(27,16).value
r_euq = sh.cell(28,16).value
r_err= sh.cell(29,16).value
r_diff = sh.cell(30,16).value
spr_signal = sh.cell(31,16).value
spr_error = sh.cell(32,16).value
Filename= sys.argv[10]
Elog=sys.argv[9]
#Comment=sys.argv[11]
root = generateXMLHeader("QC4_HVTEST_SUMRY","GEM Chamber QC4 HVTEST Summary",str(location) + " GEM QC4 HV Test",Run,Start,Stop,comment,location,user)
dataSet = generateDataSet(root,Comment,"1","GEM Chamber",chamber)
generateXMLData4s(dataSet,test_date,str(v_max),str(i_max),str(v_drift),str(r_euq), str(r_err), str(r_diff),str(spr_signal),str(Filename),str(Elog),str(Comment),str(spr_error))
writeToFile(testfile, tostring(root))
#_result = {}
#_result['XLS_FILE'] = fileName
#_result['var'] = testfile
#print json.dumps(_result)
if __name__ =="__main__":
#fname=raw_input("Enter excel data file name:")
fname = sys.argv[1]
fileName=fname+".xml"
datafile=fname+"_Data.xml"
testfile=fname+"_summry.xml"
xml_from_excel4(fname)
print 1
print 2