【python】 读取Excel文件并绘制图表

依赖的包：

1.xlrd

2.matplot

3.numpy

读取excel文件并绘制图表

代码如下： 

点击(此处)折叠或打开

1. import matplotlib.pyplot as plt
   
2. import numpy as np 
   
3. import xlrd
   
4. import os
   
5. from StringIO import StringIO 
   
6. 
   
7. 
   
8. if __name__ == '__main__':
   
9.     data = xlrd.open_workbook('D:\\tt.xls')
   
10.     
    
11.     plt.figure(figsize=(8,4))
    
12.     plt.xlabel(u'second')
    
13.     plt.ylabel(u'xxx') 
    
14.    
    
15.     
    
16.     x_index=1 
    
17.     
    
18.     data.sheet_names()
    
19.     table = data.sheets()[0]
    
20.     table = data.sheet_by_index(0)
    
21.     table = data.sheet_by_name(u'Sheet1') 
    
22.     print("Good")
    
23.     COLOR_INDEX=1
    
24.     INDEX_NAME=''
    
25.     
    
26.     ## init data
    
27.     
    
28.     
    
29.     nrows = table.nrows
    
30.     ncols = table.ncols
    
31.     print("nr=%d nc=%d \n"%(nrows,ncols)) 
    
32.     
    
33.     '''
    
34.     for rownum in range(table.nrows): 
    
35.             value = table.cell(rownum,2).value 
    
36.             if rownum == 0:
    
37.                 print("")
    
38.             else: 
    
39.                 try:
    
40.                     value_int = int(value)
    
41.                     x.append(x_index)
    
42.                     y.append(value_int)
    
43.                    # line = ax.plot(x_index,value_int,label="xx ",color="red",linewidth=2)
    
44.                     #plt.plot(x_index,value_int,label="xx ",color="red",linewidth=2)
    
45.                     print("index=%d"%x_index)
    
46.                     
    
47.                     #plt.plot_date(x_index,value_int)
    
48.                     x_index=x_index+1
    
49.                 except:
    
50.                     print("error") 
    
51.     plt.plot(x,y,label="xx ",color="red",linewidth=2) 
    
52.     '''
    
53.     for colnum in range(table.ncols):
    
54.         x=[]
    
55.         y=[]
    
56.         for rownum in range(table.nrows): 
    
57.             value = table.cell(rownum,colnum).value 
    
58.             #print("nr=%d nc=%d value=%d \n"%(rownum,colnum,value ))
    
59.             #print(value)
    
60.             #print("rownum=%d colnum=%d "%(rownum,colnum)) 
    
61.             if rownum == 0:
    
62.                 print("")
    
63.             else: 
    
64.                 try:
    
65.                     value_int = int(value)
    
66.                     x.append(x_index)
    
67.                     y.append(value_int)
    
68.                     #plt.plot(x_index,value_int,label=" ",color="red",linewidth=2)
    
69.                     #print("index=%d"%x_index)
    
70.                     
    
71.                     #plt.plot_date(x_index,value_int)
    
72.                     x_index=x_index+1
    
73.                 except:
    
74.                     print("error")
    
75.         if COLOR_INDEX == 1:
    
76.             COLOR_INDEX = 0
    
77.             plt.plot(x,y,color="red",linewidth=2)
    
78.         else:
    
79.             COLOR_INDEX =1
    
80.             plt.plot(x,y,color="blue",linewidth=2) 
    
81.         print("==============================>")
    
82.        
    
83.     plt.title("Test")
    
84.     #plt.ylim(10,2000)
    
85.     plt.legend()
    
86.     plt.show()
    
87.         
    
88.    
    
89.     pass