python 操作excel表格

標籤：column   hello   decode   excel表格   while   資料   並且   insert   format   

                       Python 操作excel 表格

#coding=utf-8

import xlsxwriter

#1.建立excel 對象

work = xlsxwriter.Workbook(‘hello.xlsk‘)#在目前的目錄下建立一個Excel檔案

#2. 建立表格

worksheet = work.add_worksheet(‘int‘)

#3.寫入內容

title_index = ["A","B","C","D","E","F"]

title = ["int","for","while","range","mk","二狗".decode("utf-8")]

data = [18,19,20,21,17,26]

 

#建立一個格式

b = work.add_format({"blod":True})

for i,j in enumerate(title_index)

     point = "%s%s"%(j,1)

     content = title[i]

     worksheet.write(point,content,b)

for i,j in enumerate(title_index):

      point = "%s%s"%(j,2)

      content = data[i]

      worksheet.write(point,content) 

 #資料統計

worksheet.write("G2","=SUM(A2:F2)")

#把資料在Excel表中組建圖表

chart = work.add_chart({"type":"column"})#建立一個柱狀圖

    #column 柱狀圖

    #area 面積圖

     #bar 橫條圖

     # line 折線圖

     # radar 雷達圖

chart.add_series(

       {

          "categories":"=int!$A$1:$F$1",#類別標籤的範圍

            "values":"=int!$A$2:$F$2",#表徵圖資料的範圍

            "line":{"color":"red"}#表徵圖線條的屬性

          })

worksheet.insert_chart("A4",chart)

#關閉並且儲存操作

work.close()

 

python 操作excel表格