python的代码保存到文档中打不开怎么办_为什么我不能从Python代码中“另存为”Excel文件？...

最新推荐文章于 2022-03-31 14:33:39 发布

weixin_39845347

最新推荐文章于 2022-03-31 14:33:39 发布

阅读量320

点赞数

文章标签： python的代码保存到文档中打不开怎么办

作者在使用自定义的Python ExcelDocument类时，遇到在调用saveAs方法保存Excel文件时出现错误，错误信息提示文件无法访问。文章将探讨问题原因并可能的解决方案，涉及Windows文件路径和Excel资源冲突问题。

摘要由CSDN通过智能技术生成

我有一个PythonExcelDocument类，它为读取/写入/格式化Excel文件提供了基本的方便方法，而且我在看似简单的Python代码中遇到了一个奇怪的错误。我有一个save andsaveAs方法：def save(self):

''' Save the file '''

self.workbook.Save()

def saveAs(self, newFileName):

''' Save the file as a new file with a different name '''

self.workbook.SaveAs(newFileName)

save方法工作得很好，但是当我试图调用saveAs方法-myExcelObject.saveAs("C:/test.xlsx")时，会得到以下错误：Traceback (most recent call last):

File "C:\workspace\Utilities\src\util\excel.py", line 201, in

excel.saveAs("C:/test.xlx")

File "C:\workspace\Utilities\src\util\excel.py", line 185, in saveAs

self.workbook.SaveAs(newFileName)

File "", line 7, in SaveAs

pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, u'Microsoft Office Excel', u"Microsoft Office Excel cannot access the file 'C:\\//8CBD2000'. There are several possible reasons:\n\n\u2022 The file name or path does not exist.\n\u2022 The file is being used by another program.\n\u2022 The workbook you are trying to save has the same name as a currently open workbook.", u'C:\\Program Files\\Microsoft Office\\Office12\\1033\\XLMAIN11.CHM', 0, -2146827284), None)

有人能解释发生了什么事吗？