影刀商城的影刀魔方的下载分日汇总报表里面日期藏了个python代码,把我搞昏了,调用模块,跟openpyxl冲突
评论
收藏

影刀商城的影刀魔方的下载分日汇总报表里面日期藏了个python代码,把我搞昏了,调用模块,跟openpyxl冲突

经验分享
w
wbwtest
2025-02-03 23:19·浏览量:310
w
wbwtest
发布于 2025-02-03 23:19310浏览

pywintypes.datetime(2022, 11, 1, 0, 0, tzinfo=TimeZoneInfo('GMT Standard Time', True)) 石化

把下载表格里面的这个代码清空了就跑通了

Traceback (most recent call last): File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\xbot_interpreter.py", line 58, in main args = params.inputs() File "C:\Users\Administrator\AppData\Local\ShadowBot\users\776434804049735682\apps\e61181a5-d72d-42d0-ae1d-fc4c51612455\xbot_robot\main.pybx", line 84, in main }, _block=("main", 30, "调用模块")) File "<string>", line 104, in wrapper File "<string>", line 96, in wrapper File "<string>", line 37, in invoke_module File "C:\Users\Administrator\AppData\Local\ShadowBot\users\776434804049735682\apps\e61181a5-d72d-42d0-ae1d-fc4c51612455\xbot_robot\Excelwriting.py", line 30, in writeContent workbook.save(filepath) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save save_workbook(self, filename) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\writer\excel.py", line 293, in save_workbook writer.save() File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\writer\excel.py", line 275, in save self.write_data() File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\writer\excel.py", line 75, in write_data self._write_worksheets() File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\writer\excel.py", line 215, in _write_worksheets self.write_worksheet(ws) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\writer\excel.py", line 200, in write_worksheet writer.write() File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 359, in write self.write_rows() File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 125, in write_rows self.write_row(xf, row, row_idx) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 147, in write_row write_cell(xf, self.ws, cell, cell.has_style) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\cell\_writer.py", line 41, in etree_write_cell value, attributes = _set_attributes(cell, styled) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\cell\_writer.py", line 31, in _set_attributes value = to_excel(value, cell.parent.parent.epoch) File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\utils\datetime.py", line 97, in to_excel days = (dt - epoch).days TypeError: can't subtract offset-naive and offset-aware datetimes Error in atexit._run_exitfuncs: Traceback (most recent call last): File "D:\tool\ShadowBot\shadowbot-5.24.20\python\lib\site-packages\openpyxl\worksheet\_writer.py", line 32, in _openpyxl_shutdown os.remove(path) PermissionError: [WinError 32] 另一个程序正在使用此文件,进程无法访问。: 'C:\\Users\\Administrator\\AppData\\Local\\Temp\\openpyxl.ko5dxkje'

收藏
全部评论1
最新
发布评论
评论