def chooseFile(self):
self.file = QtGui.QFileDialog.getOpenFileName(self, self.trUtf8("选择.xls文件"), ".", self.trUtf8("Image Files(*.xls )"))
if self.file==(u'', u''):
return;
else:
i = 1
if self.chooseSheet.count() !=1:
self.chooseSheet.clear()
self.chooseSheet.addItem(self.trUtf8("请选择"))
self.execlnameLineEdit.setText(self.file[0])
sheets = ExportXmlByBeyondsoft2.exceloperate(self.file[0]).getSheetNames()
i =0
while i<len(sheets):
self.chooseSheet.addItem(sheets[i])
i=i+1
def getFormData(self):
execlname = self.execlnameLineEdit.text()
sheetname = self.chooseSheet.currentText()
output = self.outputLineEdit.text()
savename = self.savenameLineEdit.text()
if len(execlname) == 0:
self.errorTipLable.setText(self.trUtf8("用例文件不能为空"))
self.errorTipLable.show()
elif len(sheetname) ==0:
self.errorTipLable.setText(self.trUtf8("表格名不能为空"))
self.errorTipLable.show()
elif len(output) ==0:
self.errorTipLable.setText(self.trUtf8("输出文件夹不能为空"))
self.errorTipLable.show()
elif len(savename) ==0:
self.errorTipLable.setText(self.trUtf8("XML文件名不能为空"))
self.errorTipLable.show()
elif len(execlname) >= 100:
self.errorTipLable.setText(self.trUtf8("用例文件最大长度为100"))
self.errorTipLable.show()
elif len(sheetname) >= 100:
self.errorTipLable.setText(self.trUtf8("表格名最大长度为100"))
self.errorTipLable.show()
elif len(output) >= 100:
self.errorTipLable.setText(self.trUtf8("输入文件夹最大长度为100"))
self.errorTipLable.show()
elif len(savename) >= 100:
self.errorTipLable.setText(self.trUtf8("XML文件名最大长度为100"))
self.errorTipLable.show()
elif len(execlname) != 0 and len(sheetname) !=0 and len(output) !=0 and len(savename) !=0:
if os.path.exists(execlname):
try:
sheets = ExportXmlByBeyondsoft2.exceloperate(execlname).getSheetNames()
except:
self.errorTipLable.setText(self.trUtf8("该用例文件没有表格"))
if sheetname in sheets:
if os.path.exists(output):
xmlfile = output.replace('/',"\\")+"\\"+savename+".xml"
aa =ExportXmlByBeyondsoft2.changetoxml(execlname,sheetname,output,savename)
try:
aa.run()
ShellExecute(0,"open",xmlfile,"","",SW_SHOWNOACTIVATE)
self.errorTipLable.setText(self.trUtf8("成功转换成XML文件"))
except:
self.errorTipLable.setText(self.trUtf8("请参照用例模板设计用例"))
else:
os.mkdir(output)
xmlfile = output.replace('/',"\\")+"\\"+savename+".xml"
aa =ExportXmlByBeyondsoft2.changetoxml(execlname,sheetname,output,savename)
try:
aa.run()
ShellExecute(0,"open",xmlfile,"","",SW_SHOWNOACTIVATE)
self.errorTipLable.setText(self.trUtf8("成功转换成XML文件"))
except:
self.errorTipLable.setText(self.trUtf8("请参照用例模板设计用例"))
else:
self.errorTipLable.setText(self.trUtf8("表格名不存在"))
else:
self.errorTipLable.setText(self.trUtf8("用例文件不存在"))