代码之家  ›  专栏  ›  技术社区  ›  Evan Ringler

试图在openpyxl中保存工作簿时出现语法错误

  •  0
  • Evan Ringler  · 技术社区  · 2 年前

    我正在尝试使用openpyxl将概率写入excel文件。由于某种原因,我在试图保存工作簿时遇到语法错误。请帮忙。

    import openpyxl
    from openpyxl import Workbook
    import math
    
    wb = openpyxl.Workbook()
    sheet = wb.active
    
    for m in range(1,50):
        for n in range(1,50):
            firstTo1 = m
            firstTo2 = n
            maxPoints = (2 * firstTo1 - 1) * (2 * firstTo2 - 1)
            maxPoints1 = 2 * firstTo1 - 1
            maxPoints2 = 2 * firstTo2 - 1
            probSum1 = 0.0
            tempProb1 = 0.0
            probSum2 = 0.0
            tempProb2 = 0.0
            winDec = 0.55
            r = firstTo1
            for y in range(firstTo1, maxPoints1 + 1):
                tempProb1 = (math.factorial(y-1) / (math.factorial((y-1)-(r-1)) * math.factorial(r-1))) * (winDec**r) * ((1-winDec)**(y-r))
                probSum1 += tempProb1
            r = firstTo2
            for y in range(firstTo2, maxPoints2 + 1):
                tempProb2 = (math.factorial(y-1) / (math.factorial((y-1)-(r-1)) * math.factorial(r-1))) * (probSum1**r) * ((1-probSum1)**(y-r))
                probSum2 += tempProb2           
            c = sheet.cell(row = n+2, column = m+2)
            c.value = probSum2
            
    wb.save('CapstoneData.xlsx')
    

    运行此代码块会出现以下错误:

    File "<stdin>", line 23
        wb.save('CapstoneData.xlsx')
        ^^
    SyntaxError: invalid syntax
    

    因为在保存工作簿之前没有错误,所以我不太明白错误来自何处。我已经验证了我计算的有效性,只需要将它们写入Excel。谢谢你的帮助!

    0 回复  |  直到 2 年前