数据分析 python安装 excel模块xlrd,最新替代excelrd

红太狼 2023-07-08 09:23 16阅读 0赞

用pip install xlrd 安装xlrd时异常

解决办法:去网站下载文件,手动安装.下载地址：[https://pypi.org/project/xlrd/\#files][https_pypi.org_project_xlrd_files]

有.tar.gz和.wheel两种格式的文件可以选择下载,选其中一种即可.解压(安装)后的文件夹里都有examples子文件夹,可以参考使用.

### 一.  tar.gz压缩文件 ###

1.解压压缩包 ： tar xvf xlrd-1.2.0.tar.gz    \#目前最近的版本了,2018年12月16号的,现xlrd以被excelrd替代.  (tar xvf是解压命令 .)  
3、进入到解压的文件夹![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70][]  
4、执行指令：(sudo) python setup.py install  (解压后的文件夹里有setup.py文件;windows不用sudo)

### 二.wheel文件格式  扩展名.whl ###

pip install \+文件路径/文件  \#.whl文件

### 三.现在同功能最新是excelrd ###

excelrd是修改后的版本[xlrd][]工作最新的Python版本。 xlrd在Python 3.9或更高版本上不起作用.

> ### [Transition from xlrd to excelrd][] ###
> 
> Just replace the** import xlrd**:
> 
>     import excelrd as xlrd

[https://pypi.org/project/excelrd/][https_pypi.org_project_excelrd]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 1][]

![20200226054419718.png][]

### 下载:[https://pypi.org/project/excelrd/\#files][https_pypi.org_project_excelrd_files] ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 2][]

### 安装:.whl文件或.tar.gz文件 ###

### 1.浏览器窗口,ctrl+j(找到下载的文件位置) ###

### 2.shift+鼠标右键---->在此处打开powershell窗口,进入命令行方式: ###

### 3.pip install excelrd-2.0.3-py3-none-any.whl ###

![20200226060525543.png][]

如果下载的是.tar.gz文件,则命令行窗口执行下面的命令解压:

![20200226073549758.png][]

### [Transition from xlrd to excelrd][] ###

Just replace the import xlrd:

import excelrd as xlrd

例:Print all of the cell values in a specific sheet:

> <table> 
>  <tbody> 
>   <tr> 
>    <th>Sample Code:</th> 
>    <td> <pre><strong>import excelrd</strong>
> 
> 
> def main():
>     book = <strong>excelrd</strong>.open_workbook("namesdemo.xls")
> 
>     print("The number of worksheets is {}".format(book.nsheets))
>     print("Worksheet name(s): {}".format(", ".join(book.sheet_names())))
> 
>     sh = book.sheet_by_index(2)
>     print("{}: rows={}, cols={}".format(sh.name, sh.nrows, sh.ncols))
> 
>     for row_idx in range(sh.nrows):
>         for col_idx in range(sh.ncols):
>             cell = sh.cell(row_idx, col_idx)
> 
>             if not cell.value:
>                 continue
> 
>             print("row={}, col={}, value={}".format(row_idx, col_idx, cell.value))</pre> </td> 
>   </tr> 
>  </tbody> 
> </table>

[https_pypi.org_project_xlrd_files]: https://pypi.org/project/xlrd/#files
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200226072716744.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA==,size_16,color_FFFFFF,t_70
[xlrd]: http://www.python-excel.org/
[Transition from xlrd to excelrd]: https://pypi.org/project/excelrd/#excelrd
[https_pypi.org_project_excelrd]: https://pypi.org/project/excelrd/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200226054352770.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA==,size_16,color_FFFFFF,t_70
[20200226054419718.png]: https://img-blog.csdnimg.cn/20200226054419718.png
[https_pypi.org_project_excelrd_files]: https://pypi.org/project/excelrd/#files
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200226055843624.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FobWN3dA==,size_16,color_FFFFFF,t_70
[20200226060525543.png]: https://img-blog.csdnimg.cn/20200226060525543.png
[20200226073549758.png]: https://img-blog.csdnimg.cn/20200226073549758.png