【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

90. 
    

本文转自 chengxuyonghu 51CTO博客，原文链接：http://blog.51cto.com/6226001001/1576059，如需转载请自行联系原作者