Location:
Search - python excel
Search list
Description: EXCEL处理类,实现了对电子表格的多数操作,用户可在此基础上继续扩展-EXCEL class and the realization of electronic forms of the majority of operators, users can continue to build on this expansion
Platform: |
Size: 3072 |
Author: hero lu |
Hits:
Description: 从网页中提取股票历年分红数据,并保存到excel表中-Extracted from the web site of stock dividends over the years of data and save it to excel table
Platform: |
Size: 1024 |
Author: python |
Hits:
Description: python 读取excel文件,这是一个系列的包,巨方便-python read excel file, which is a series of packets, giant convenience
Platform: |
Size: 227328 |
Author: cxl2253 |
Hits:
Description: xlwt 是用PYTHON生成EXCEL文件的包,和xlrd是读写整套包,巨方便-xlwt is generated PYTHON package EXCEL files, and read and write the entire package is xlrd, giant convenience
Platform: |
Size: 151552 |
Author: cxl2253 |
Hits:
Description: microsoft excel writing
Platform: |
Size: 2048 |
Author: arun |
Hits:
Description: Excel文件读取
安装: python setup.py install
from pyExcelerator import *
sheets = parse_xls( d:/a.xls )
很简单,与 xlrd 不同。xlrd 需要先调用book = xlrd.open_workbook(filename)打开文档,然后再调用sh = book.sheet_by_index(i)来得到第几个sheet,然后再使用sh.cell_value(i, j)得到i行j列的单元格的值。操作多了一点。而上面的parse_xls(filename)则直接返回一个列表,每一项就是一个sheet的数据。每项是一个二元组(表名,单元格数据)。其中单元格数据为一个字典,键值就是单元格的索引(i,j)。如果某个单元格无数据,那么就不存在这个值。看似简单,但从处理上不象 xlrd 一样,可以知道每个sheet的最大行数和列数,然后进行循环。而使用 pyExcelerator 好象没有最大行数和列数,再加上空数据又不存在,因此在处理上相对麻烦一些。这样在处理上还需要注意。它与 xlrd 一样都支持 unicode ,但好象没有 xlrd 一样方便地判断单元格的类型的方法,感觉还是 xlrd 在功能上可能要强一些。当然这只是个人感觉,再加上只是看了看例子,并没有怎么使用。-Excel file read
Platform: |
Size: 174080 |
Author: kevin |
Hits:
Description: 使用 xlrd 能够很方便的读取 excel 文件内容,而且这是个跨平台的库,能够在windows,linux/unix,等平台上面使用。 -Use xlrd can easily read the contents of excel file, and this is a cross-platform libraries, can be windows, linux/unix, and other platforms used above.
Platform: |
Size: 118784 |
Author: kevin |
Hits:
Description: XML解析程序,装PUBMED数据库导出的XML解析成Excel表格-Xml parser program, the xml parser pubmed exported to excel spreadsheet
Platform: |
Size: 7168 |
Author: lzzzing |
Hits:
Description: 需要将每辆出租车载客的起点和终点的数据检索出来,一辆出租车弄成一个文件(如果一辆出租车载客起终点的数据能实现天与天之间用不同文件装更好).每辆出租车的status有”0”和”1 “ 0代表出租车无乘客。 1代表出租车有乘客。0到1表示有乘客上车,此时记录下1那行的数据(包括name,time,jd,wd,status,v,angle,),当由1到0时表示乘客下车,此时记录下0那行的数据(包括name,time,jd,wd,status,v,angle,),其他情况的数据就不要。比如一直1(表示乘客一直在车上),或者一直0(出租车一直没乘客)直到所有数据检索完。那个excel是举得粤b000h6一段时间内检索的数据。-search in excel files and then output in txt after the processing
Platform: |
Size: 345088 |
Author: sa |
Hits:
Description: python 访问 excel 好用的库说明。-python vister excel file.
Platform: |
Size: 69632 |
Author: jchen |
Hits:
Description: Python和Excel之间进行数据交换-Data exchange between Python and Excel
Platform: |
Size: 264192 |
Author: qdxtfht |
Hits:
Description: excel insert image,add format,hyper link by python openpyxl
Platform: |
Size: 1024 |
Author: zhao |
Hits:
Description: python 实现复杂写excel,主要用了xlwt库,使用方便,简单易用(Python achieve complex writing excel, mainly using the xlwt library, easy to use, easy to use)
Platform: |
Size: 25600 |
Author: yxlijun
|
Hits:
Description: 简单、易用的excel处理插件包,python工具包(excel python develop tool packet)
Platform: |
Size: 2563072 |
Author: maylcc
|
Hits:
Description: 介绍使用python处理excel文件,教程语言为英语。(working excel files in python)
Platform: |
Size: 266240 |
Author: ascent
|
Hits:
Description: python,excel实现的接口测试小框架
1.编写测试用例
2.python3 执行
3.执行记录保存到excel中(Python, excel implementation of the interface test small framework
1. writing test cases
2.python3 execution
3. the execution records are saved to excel)
Platform: |
Size: 47104 |
Author: LXSHYZHX |
Hits:
Description: python在编程过程中发现的不同寻常的异常表,包含常见项。(The unusual exception table that python finds during programming, contains common items.)
Platform: |
Size: 15360 |
Author: yangrouchuaner |
Hits:
Description: 零起点Python大数据与量化交易
本书是国内较早关于Python大数据与量化交易的原创图书, 配合
zwPython开发平台和zwQuant开源量化软件学习, 是一套完整的大数据
分析、 量化交易的学习教材, 可直接用于实盘交易。 本书有三大特色:
第一, 以实盘个案分析为主, 全程配有Python代码; 第二, 包含大量的
图文案例和Python源码, 无须专业编程基础, 懂Excel即可开始学习; 第
三, 配有专业的zwPython集成开发平台、 zwQuant量化软件和zwDat数
据包(This book is an earlier book on Python big data and quantified trading in China.
ZwPython development platform and zwQuant open source quantitative software learning is a complete set of big data.
Analyzing and quantifying the learning materials for trading can be directly used for firm trading. This book has three major features:
First, it is mainly based on case analysis, with Python code in the whole process.
Second, it contains a large number of cases. Picture and text case and Python source code, without professional programming foundation, understand Excel can start learning;
Third, equipped with professional zwPython integrated development platform, zwQuant quantization software and zwDat number.)
Platform: |
Size: 17677312 |
Author: blackkettle |
Hits:
Description: python 语言处理excel 文件,我是小白,你估计比我懂的都多(how to deal with excel files by using python)
Platform: |
Size: 33792 |
Author: Sophia001 |
Hits:
Description: 用python语言处理windows office 办公软件excel表格数据(Processing windows office software excel table data in python language)
Platform: |
Size: 1819648 |
Author: 星空下的繁华 |
Hits: