1 #!/usr/bin/env python 2 # -*- coding:utf-8 -*- 3 # __author__ = "blzhu" 4 """ 5 python study 6 Date:2017 7 """ 8 # coding=utf-8 9 ####################################################### 10 # filename:xlrd_draw.py 11 # author: 12 # date:xxxx-xx-xx 13 # function:读excel文件中的数据 14 ####################################################### 15 import numpy as np 16 import matplotlib.pyplot as plt 17 import xlrd 18 19 # 打开一个workbook 20 workbook = xlrd.open_workbook(r'E:\python\pycharmwork\test\matplotlibzbl\Barometer.xlsx') 21 22 # 抓取所有sheet页的名称 23 worksheets = workbook.sheet_names() 24 print('worksheets is %s' % worksheets) 25 26 # 定位到mySheet 27 mySheet = workbook.sheet_by_name(u'Pressure') 28 29 # get datas 30 pressure = mySheet.col_values(0) 31 print(pressure) 32 time = mySheet.col(1) 33 print('time1',time) 34 time = [x.value for x in time] 35 print('time2',time) 36 37 38 # drop the 1st line of the data, which is the name of the data. 39 pressure.pop(0) 40 time.pop(0) 41 42 # declare a figure object to plot 43 fig = plt.figure(1) 44 45 # plot pressure 46 plt.plot(time,pressure) 47 48 plt.title('Barometer') 49 plt.ylabel('Pa') 50 plt.xticks(range(len(time)),time) 51 plt.show()
参考:http://blog.csdn.net/huhuang/article/details/53809891
学习python好去处:http://i.youku.com/pythontutorial