openpyxl库 - jdcal错误

本文介绍了openpyxl库 - jdcal错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试处理一些excel文件，我决定使用openpyxl库。我已将openpyxl文件夹复制到/ Lib /并尝试对某些示例代码执行import命令，而我得到的只是一些错误列表。

I'm trying to work on some excel files, I decided to use openpyxl library. I've copied the openpyxl folder to /Lib/ and trying to do the import command on some sample code, and all I get is a list of few errors.

    Traceback (most recent call last):
  File "C:/Users/Karolina/Documents/python/test xlsx.py", line 1, in <module>
    import openpyxl
  File "C:\Python34\lib\openpyxl\__init__.py", line 9, in <module>
    from openpyxl.workbook import Workbook
  File "C:\Python34\lib\openpyxl\workbook\__init__.py", line 5, in <module>
    from .workbook import *
  File "C:\Python34\lib\openpyxl\workbook\workbook.py", line 14, in <module>
    from openpyxl.utils.datetime  import CALENDAR_WINDOWS_1900
  File "C:\Python34\lib\openpyxl\utils\datetime.py", line 11, in <module>
    from jdcal import (
ImportError: cannot import name 'gcal2jd'

首先我得到了关于jdcal的相同错误，所以我安装了名为jdcal的库。现在我不知道如何修复这个，它有什么问题？
我正在使用python 3.4

First I was getting the same error about "jdcal" so I have installed the library called jdcal. Now I have no clue how to fix this one, what is wrong with it?I'm using python 3.4

推荐答案

实际上取决于& 你首先需要下载并给予refrencing一些安装这两个包我已成功地运行openpyxl。这样的事情：

Actually openpyxl depends upon jdcal & et_xmlfile. You first require to install these two packages. I have managed to run openpyxl by downloading and giving refrencing some thing like this:

#For Writing in Excel File
import sys
#For openpyxl-2.4.0 Python Package you should need to have et_xmlfile and jdcal package
sys.path.append("D:\et_xmlfile-1.0.1")
sys.path.append("D:\jdcal-1.3")
sys.path.append('D:\openpyxl-2.4.0')

import openpyxl

这篇关于openpyxl库 - jdcal错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

Openpyxl