![](https://img.haomeiwen.com/i9305082/67e79eebf4bebcf0.jpg)
因为数据是用.csv格式保存的,所以我们通常用Excel来处理。然而其工作量是非常大的,反复操作一些相同的动作,所以Python爬虫师那种动则几十万的数据量,都会利用Python脚本来给我们处理。
说到python操作Excel就不得不提两个库:读excel库xlrd,写excel的库xlwt。
Python写excel——xlwt
![](https://img.haomeiwen.com/i9305082/03d35d828098b258.jpg)
详细代码如下:
![](https://img.haomeiwen.com/i9305082/dfaea2da59a3ee57.jpg)
![](https://img.haomeiwen.com/i9305082/f0c58d54d9dc1ab2.jpg)
结果图:
![](https://img.haomeiwen.com/i9305082/0b81f393587d7742.jpg)
![](https://img.haomeiwen.com/i9305082/838ba833c233a7aa.jpg)
Python读excel——xlrd
![](https://img.haomeiwen.com/i9305082/a81e2c8109e4d40b.jpg)
下面先看看基本的操作:
![](https://img.haomeiwen.com/i9305082/11b3a00379a382a1.jpg)
整体思路为,打开文件,选定表格,读取行列内容,读取表格内数据
详细代码如下:
![](https://img.haomeiwen.com/i9305082/2d7ab9ede3618c3b.jpg)
运行结果如下:
![](https://img.haomeiwen.com/i9305082/10d66c12a7e88b32.jpg)
![](https://img.haomeiwen.com/i9305082/5a450e90965a5505.jpg)
1.python读取excel中单元格内容为日期的方式
python读取excel中单元格的内容返回的有5种类型,即上面例子中的ctype:
![](https://img.haomeiwen.com/i9305082/ff28c6264a3467eb.jpg)
详细代码如下:
![](https://img.haomeiwen.com/i9305082/d2123f4dd99eff09.jpg)
![](https://img.haomeiwen.com/i9305082/39767498897f4e99.jpg)
2.获取合并单元格的内容
![](https://img.haomeiwen.com/i9305082/87b13518010e1dbb.jpg)
详细代码如下:
![](https://img.haomeiwen.com/i9305082/4bded8017dddcab4.jpg)
![](https://img.haomeiwen.com/i9305082/8f3734550003a9df.jpg)
规律是获取merge_cells返回的row和col低位的索引即可! 于是可以这样批量获取:
详细代码如下:
![](https://img.haomeiwen.com/i9305082/cba90bb583960340.jpg)
运行结果跟上图一样:
![](https://img.haomeiwen.com/i9305082/2ea2aacc10e7eb48.jpg)
Python读写Excel表格,就是这么简单粗暴又好用!
网友评论