importxlrdimportxlwtimportsysMARGE_INPUT_FILE_NAME_STR=inputMARGE_OUTPUT_FILE_NAME_STR=u"结果表.xls"MARGE_SHEET1_NAME_STR=u"sheet1"MARGE_SHEET_NAME_STR=u"核算项目明细表"d...
import xlrd
import xlwt
import sys
MARGE_INPUT_FILE_NAME_STR = input
MARGE_OUTPUT_FILE_NAME_STR = u"结果表.xls"
MARGE_SHEET1_NAME_STR = u"sheet1"
MARGE_SHEET_NAME_STR = u"核算项目明细表"
def open_excel(filePath=MARGE_INPUT_FILE_NAME_STR):
"读取xls文件数据"
data = xlrd.open_workbook(filePath)
try:
data = xlrd.open_workbook(filePath)
return data
except Exception,exce:
print str(exce)
if __name__ == "__main__":
if len(sys.argv) >= 2:
for index in range(1,len(sys.argv)):
open_excel(input = raw_input(sys.argv[index]))
output(filePath=u"结果表.xls", sheetName=u"结果表", nameList=nameList, resule=result, sheetList=sheetList)
else:
print "***请输入要处理的数据文件名称和文件路径***"
def open_excel(filePath=MARGE_INPUT_FILE_NAME_STR)方法怎样能获取主函数中键盘输入的sys.argv[index]的文件名称
展开