python操作excel

標籤：save   exce   type   active   values   open   .sh   div   app   

from openpyxl import Workbook

from openpyxl import load_workbook

import xlrd

from xlrd import open_workbook,cellname

儲存到excel檔案

wb = Workbook()
ws = wb.active

ws.append(“表頭”)
wb.save(‘filename.xlsx‘)

讀取excel檔案

data = xlrd.open_workbook(‘filename.xlsx‘)

table = data.sheets()[0]    //通過索引得到表
nrows = table.nrows    //獲得表的行數

ncols = table.ncols  //獲得表的列數

迴圈行列表資料 for i in range(nrows ):      print table.row_values(i)  儲存格cell_A1 = table.cell(0,0).value cell_C4 = table.cell(2,3).value  使用行列索引cell_A1 = table.row(0)[0].value cell_A2 = table.col(1)[0].value  簡單的寫入row = 0 col = 0 # 類型 0 empty,1 string, 2 number, 3 date, 4 boolean, 5 errorctype = 1 value = ‘儲存格的值‘ xf = 0 # 擴充的格式化 table.put_cell(row, col, ctype, value, xf) table.cell(0,0)  #儲存格的值 table.cell(0,0).value #儲存格的值 

python操作excel