程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
您现在的位置: 程式師世界 >> 編程語言 >  >> 更多編程語言 >> Python

Summary of Excel document operation library by Python

編輯:Python

1、 Built-in module cvs library ,import cvs, operation cvs Suffixed documents

2、、numpy Library loadtxt Method ,loadtxt Used to read files ( Include txt,csv etc. ).gz or .bz Format compressed file , Premise Each line of file data must have the same number of values

numpy Library fromfile Method .

3、pandas library , treatable file type Yes :txt,csv,excel,json、 Shear plate 、 database 、html、hdf wait . Output datagrame Format

5、 Reading and writing excel file ,

There's a lot in the library , Mainly as follows :

xlrd library , Support xls/xlsx

xlwt library , I won't support it xlsx Format modification

openpyxl library , Mainly aimed at xlsx Format excel To read And editors

xlwings library , Support xlsx、xls、xlsm Read and write format files 、 Modification and other operations

xlsxwriter library . Generate excel form , insert data 、 Insert icon and other operations , Reading is not supported

Search for

Copy


  1. 上一篇文章:
  2. 下一篇文章:
Copyright © 程式師世界 All Rights Reserved