a simple python script that read the Microsoft Excel file.
一个读取Excel文件的简单python脚本
parsing a single sheet *.xlsx file into a python list. An abstract usage:
把一个单表格的*.xlsx文件读取为一个python的列表。 下面是一个抽象一点的用法实例：
from ThisScript import TheReaderFunction
target_file = "path/to/file.xlsx"
table = TheReaderFunction(target_file)
C6 = table[5][2]
print C6 # type(C6) == str
For detailed sample, see the last part of the script.
具体的看python脚本的最后，会有实际情况下的用法，其实就是调用个函数的事
- only supports single sheet file without any graph, excel programs. And the sheet should have default name
sheet1(Yes, the simplest type you could imagine) - 只支持单表格的文件，并且不能有任何图表、Excel编程。就是最简单的那种。并且那个表格的名字必须是默认的
sheet1 - not fully tested, may have some issues among different version of Excels. Good luck.
- 未经过完整测试，可能在不同版本的Excel上有问题
If you are just looking for a handy tool, skip this part.
这部分简单叙述一下xlsx的文件格式，没兴趣就跳过吧。
xlsx is actually a zip file. The details could be found by using :
xlsx文件实际上是一个zip压缩包。用unzip或者随便什么就可以把它打开：
$ unzip sample.xlsx
The inner content contain some data. And we only need two of them. xl/sharedStrings.xml and xl/worksheets/*.xml. Well, maybe more than two.
压缩包里的内容，我们只需要两个：xl/sharedStrings.xml 和 xl/worksheets/*.xml
Each *.xml under folder xl/worksheets/ stands for a sheet. By default, the sheet has name sheet1. Thus the xml file has name sheet1.xml.
xl/worksheets/下的每个xml文件都对应一个表格，例如名为sheet1的表格就对应sheet1.xml
All data in xlsx are regarded as strings, and stored in the sharedString.xml. Duplicated strings are dereplicated. Maybe that is just why it's called sharedString.xml.
xlsx文件中所有数据都被认为是字符串，存储在sharedString.xml中。重复的字符串会被消除，难怪文件叫做共享字符串。
The sheet1.xml specified the width and height of a sheet, and link every grid to a string in sharedString.xml. A sheet then could be retrieved.
sheet1.xml中指定了表格的大小，并且将每一个格子链接到sharedString.xml的一个字符串中。有了这些知识，就可以读取一个简单的xlsx文件了。
I mean, improvement by YOUR hand. For me, this script is just enough for application.
这里我说的是你对这个脚本做出的改进。对我而言这个脚本已经够用了。
This is simple. Find all the *.xml under xl/worksheets/, and return multiple list. Done.
很简单，把xl/worksheets/下的所有xml文件都挨个处理一遍，返回多个列表就完了。