Linux安装Python xlrd、xlwt、xlutils模块

最新推荐文章于 2023-07-18 09:09:20 发布

传而习乎

最新推荐文章于 2023-07-18 09:09:20 发布

阅读量3.3k

点赞数 1

分类专栏： Linux

本文链接：https://blog.csdn.net/zzddada/article/details/99310066

版权

Linux 专栏收录该内容

56 篇文章 2 订阅

订阅专栏

一、安装setuptools：

可以先打开setuptools的python官网看看setuptools软件包如何安装:

1	`> wget https://bitbucket.org/pypa/setuptools/raw/bootstrap/ez_setup.py > python ez_setup.py` `--user`

也可以下载setuptools软件包后安装：

（1）下载setuptools包

https://pypi.org/project/xlrd/#modal-close

1	`# wget http://pypi.python.org/packages/source/s/setuptools/setuptools-2.0.tar.gz`

(2)解压setuptools包

1	`#tar zxvf setuptools-2.0.tar.gz`

(3)切换到当前文件夹

1	`#cd setuptools-2.0`

（4）编译setuptools （linux系统原生安装命令）

1	`#python setup.py build`

(5)开始执行setuptools安装

1	`#python setup.py install`

参考：

1	`from：http://www.jb51.net/article/101444.htm`

二、安装xlrd、xlwt、xlutils

xlrd：是python从excel读数据的第三方控件；
xlwt：是python从excel写数据的第三方控件；
xlutils：是python使用xlrd、xlwt的工具箱。若安装不成功，可能原因是需要安装setuptools。

第一种方法()：

[root@vm4 python]# pip install xlrd

[root@vm4 python]# pip install xlwt

[root@vm4 python]# pip install xlutils

第二种方法：(我用这个种方法)

1、下载文件xlrd-0.9.3.tar.gz，xlwt-0.7.5.tar.gz，xlutils-1.7.1.tar.gz并上传至python

2、解压安装xlrd

[root@vm4 python]# tar -zxvf xlrd-0.9.3.tar.gz

[root@vm4 python]# cd xlrd-0.9.3

[root@vm4 xlrd-0.9.3]# python setup.py install　

3、解压安装xlwt

[root@vm4 python]# tar -zxvf xlwt-0.7.5.tar.gz

[root@vm4 python]# cd xlwt-0.7.5

[root@vm4 xlwt-0.7.5]# python setup.py install

4、解压安装xlutils

[root@vm4 python]# tar -zxvf xlutils-1.7.1.tar.gz

[root@vm4 python]# cd xlutils-1.7.1

[root@vm4 xlutils-1.7.1]# python setup.py install　

1.1 实战例子

<span style="color:#333333"><span style="color:black"><code class="language-python"><span style="color:slategray"># -*- coding: utf-8 -*-</span>
__author__ <span style="color:#9a6e3a">=</span> <span style="color:#669900">'ShengLeQi'</span>
<span style="color:#0077aa">import</span> xlwt
<span style="color:#0077aa">import</span> pymysql
<span style="color:#0077aa">import</span>  sys<span style="color:#999999">,</span>os
<span style="color:#0077aa">import</span> datetime
<span style="color:#0077aa">def</span> <span style="color:#dd4a68">mysql_m</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">:</span>  <span style="color:slategray">#mysql数据连接部分</span>
    <span style="color:slategray"># 打开数据库连接</span>
    db <span style="color:#9a6e3a">=</span> pymysql<span style="color:#999999">.</span>connect<span style="color:#999999">(</span><span style="color:#669900">"10.0.0.101"</span><span style="color:#999999">,</span><span style="color:#669900">"sheng"</span><span style="color:#999999">,</span><span style="color:#669900">"123456"</span><span style="color:#999999">,</span><span style="color:#669900">"Sheng_DB"</span> <span style="color:#999999">,</span>charset<span style="color:#9a6e3a">=</span><span style="color:#669900">'utf8'</span><span style="color:#999999">)</span>
    <span style="color:slategray"># 使用cursor()方法获取操作游标</span>
    cursor <span style="color:#9a6e3a">=</span> db<span style="color:#999999">.</span>cursor<span style="color:#999999">(</span><span style="color:#999999">)</span>
    <span style="color:slategray"># SQL 查询语句</span>
    sql <span style="color:#9a6e3a">=</span> <span style="color:#669900">"SELECT * FROM student "</span>
    <span style="color:#0077aa">try</span><span style="color:#999999">:</span>
        <span style="color:slategray"># 执行SQL语句</span>
        cursor<span style="color:#999999">.</span>execute<span style="color:#999999">(</span>sql<span style="color:#999999">)</span>
        <span style="color:slategray"># 获取所有记录列表</span>
        results <span style="color:#9a6e3a">=</span> cursor<span style="color:#999999">.</span>fetchall<span style="color:#999999">(</span><span style="color:#999999">)</span>
        <span style="color:slategray"># print(results)</span>
        <span style="color:slategray"># print(len(results[0]))</span>
        <span style="color:#0077aa">return</span>  results
    <span style="color:#0077aa">except</span><span style="color:#999999">:</span>
        <span style="color:#0077aa">print</span><span style="color:#999999">(</span><span style="color:#669900">"Error: unable to fetch data"</span><span style="color:#999999">)</span>
<span style="color:#0077aa">def</span> <span style="color:#dd4a68">set_style</span><span style="color:#999999">(</span>name<span style="color:#999999">,</span>height<span style="color:#999999">,</span>bold<span style="color:#9a6e3a">=</span><span style="color:#990055">False</span><span style="color:#999999">)</span><span style="color:#999999">:</span>  <span style="color:slategray">#字体设置</span>
    <span style="color:#669900">"""
    设置单元格样式
    :param name: 字体名字
    :param height: 字体大小
    :param bold: 是否加粗
    :return: 返回样式
    """</span>
    style <span style="color:#9a6e3a">=</span> xlwt<span style="color:#999999">.</span>XFStyle<span style="color:#999999">(</span><span style="color:#999999">)</span>
    font <span style="color:#9a6e3a">=</span> xlwt<span style="color:#999999">.</span>Font<span style="color:#999999">(</span><span style="color:#999999">)</span>
    font<span style="color:#999999">.</span>name <span style="color:#9a6e3a">=</span> name
    font<span style="color:#999999">.</span>bold <span style="color:#9a6e3a">=</span> bold
    font<span style="color:#999999">.</span>color_index <span style="color:#9a6e3a">=</span> <span style="color:#990055">4</span>
    font<span style="color:#999999">.</span>height <span style="color:#9a6e3a">=</span> height
    style<span style="color:#999999">.</span>font <span style="color:#9a6e3a">=</span> font
    <span style="color:#0077aa">return</span> style
<span style="color:#0077aa">def</span> <span style="color:#dd4a68">write_excel</span><span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">:</span>  <span style="color:slategray">#写入xls部分</span>
    <span style="color:#669900">"""
    写表格
    :return:
    """</span>
    f <span style="color:#9a6e3a">=</span> xlwt<span style="color:#999999">.</span>Workbook<span style="color:#999999">(</span><span style="color:#999999">)</span>  <span style="color:slategray"># 创建工作簿</span>
    sheet1 <span style="color:#9a6e3a">=</span> f<span style="color:#999999">.</span>add_sheet<span style="color:#999999">(</span><span style="color:#669900">'students'</span><span style="color:#999999">,</span>cell_overwrite_ok<span style="color:#9a6e3a">=</span><span style="color:#990055">True</span><span style="color:#999999">)</span> <span style="color:slategray">##第二参数用于确认同一个cell单元是否可以重设值。</span>
    row0 <span style="color:#9a6e3a">=</span> <span style="color:#999999">[</span><span style="color:#669900">'id'</span><span style="color:#999999">,</span><span style="color:#669900">'性别'</span><span style="color:#999999">,</span><span style="color:#669900">'班级编号'</span><span style="color:#999999">,</span><span style="color:#669900">'姓名'</span><span style="color:#999999">]</span>
    <span style="color:slategray"># 生成第一行</span>
    <span style="color:#0077aa">for</span> i <span style="color:#0077aa">in</span> <span style="color:#669900">range</span><span style="color:#999999">(</span><span style="color:#669900">len</span><span style="color:#999999">(</span>row0<span style="color:#999999">)</span><span style="color:#999999">)</span><span style="color:#999999">:</span>
        sheet1<span style="color:#999999">.</span>write<span style="color:#999999">(</span><span style="color:#990055">0</span><span style="color:#999999">,</span>i<span style="color:#999999">,</span>row0<span style="color:#999999">[</span>i<span style="color:#999999">]</span><span style="color:#999999">,</span>set_style<span style="color:#999999">(</span><span style="color:#669900">'宋体'</span><span style="color:#999999">,</span><span style="color:#990055">200</span><span style="color:#999999">,</span><span style="color:#990055">True</span><span style="color:#999999">)</span><span style="color:#999999">)</span> <span style="color:slategray"># 200对应的是10号字体,如果设置太小,可能看上去像空Excel,实际上是有内容的</span>
    results<span style="color:#9a6e3a">=</span>mysql_m<span style="color:#999999">(</span><span style="color:#999999">)</span>
    <span style="color:#0077aa">for</span> count<span style="color:#999999">,</span>row <span style="color:#0077aa">in</span>  <span style="color:#669900">enumerate</span><span style="color:#999999">(</span>results<span style="color:#999999">)</span><span style="color:#999999">:</span>
        <span style="color:#0077aa">for</span> i <span style="color:#0077aa">in</span> <span style="color:#669900">range</span><span style="color:#999999">(</span><span style="color:#669900">len</span><span style="color:#999999">(</span>row<span style="color:#999999">)</span><span style="color:#999999">)</span><span style="color:#999999">:</span>
            sheet1<span style="color:#999999">.</span>write<span style="color:#999999">(</span>count<span style="color:#9a6e3a">+</span><span style="color:#990055">1</span><span style="color:#999999">,</span>i<span style="color:#999999">,</span>row<span style="color:#999999">[</span>i<span style="color:#999999">]</span><span style="color:#999999">,</span>set_style<span style="color:#999999">(</span><span style="color:#669900">'宋体'</span><span style="color:#999999">,</span><span style="color:#990055">200</span><span style="color:#999999">,</span><span style="color:#990055">True</span><span style="color:#999999">)</span><span style="color:#999999">)</span>
    f<span style="color:#999999">.</span>save<span style="color:#999999">(</span><span style="color:#669900">'test1.xls'</span><span style="color:#999999">)</span>
    now_time <span style="color:#9a6e3a">=</span> datetime<span style="color:#999999">.</span>datetime<span style="color:#999999">.</span>now<span style="color:#999999">(</span><span style="color:#999999">)</span>
    yes_time <span style="color:#9a6e3a">=</span> now_time <span style="color:#9a6e3a">+</span> datetime<span style="color:#999999">.</span>timedelta<span style="color:#999999">(</span>days<span style="color:#9a6e3a">=</span><span style="color:#9a6e3a">-</span><span style="color:#990055">1</span><span style="color:#999999">)</span>
    yes_time <span style="color:#9a6e3a">=</span> <span style="color:#999999">(</span>yes_time<span style="color:#999999">.</span>strftime<span style="color:#999999">(</span><span style="color:#669900">'%Y%m%d'</span><span style="color:#999999">)</span><span style="color:#999999">)</span>
    <span style="color:#0077aa">if</span> os<span style="color:#999999">.</span>path<span style="color:#999999">.</span>exists<span style="color:#999999">(</span>yes_time<span style="color:#999999">)</span> <span style="color:#0077aa">is</span> <span style="color:#9a6e3a">not</span> <span style="color:#990055">True</span><span style="color:#999999">:</span>
        os<span style="color:#999999">.</span>makedirs<span style="color:#999999">(</span>yes_time<span style="color:#999999">)</span>
    path<span style="color:#9a6e3a">=</span>os<span style="color:#999999">.</span>path<span style="color:#999999">.</span>join<span style="color:#999999">(</span>os<span style="color:#999999">.</span>getcwd<span style="color:#999999">(</span><span style="color:#999999">)</span><span style="color:#999999">,</span>yes_time<span style="color:#999999">,</span><span style="color:#669900">'test_time.xls'</span><span style="color:#999999">)</span>
    f<span style="color:#999999">.</span>save<span style="color:#999999">(</span>path<span style="color:#999999">)</span>
<span style="color:#0077aa">if</span> __name__ <span style="color:#9a6e3a">==</span> <span style="color:#669900">'__main__'</span><span style="color:#999999">:</span>
    write_excel<span style="color:#999999">(</span><span style="color:#999999">)</span></code></span></span>

转载自：http://www.cnblogs.com/sheng-247/p/7536299.html

================================================================================