XlsxWriter的简单使用：python向excel写入数据

准备练习数据

用fiddler捕获请求Twitter的返回数据，并将其复制粘贴存入txt文件。数据结构大致如下：

准备XlsxWriter包

安装XlsxWriter包

#使用pip下载并安装包（本机已安装过）
C:\Users\limj3>pip install Xlsxwriter
DEPRECATION: Python 2.7 will reach the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 won't be maintained after that date. A future version of pip will drop support for Python 2.7.
Requirement already satisfied: Xlsxwriter in d:\anaconda2\lib\site-packages (1.1.5)

#检查是否安装成功
C:\Users\limj3>python
Python 2.7.16 |Anaconda, Inc.| (default, Mar 14 2019, 15:42:17) [MSC v.1500 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>import xlsxwriter
>>>