import matplotlib.pyplot as plt
import xlrd
from xlrd import open_workbook
x_data=[]
y_data=[]
wb = open_workbook('G:/test/工况.xlsx')
for s in wb.sheets():
print('Sheet:', s.name)
for row in range(0,1275):
print('the row is:', row)
values = []
for col in range(0,2):
values.append(s.cell(row, col).value)
print(values)
x_data.append(values[0])
y_data.append(values[1])
plt.plot(x_data, y_data, '', label=u"speed", linewidth=1)
plt.xlim(0,1200)
plt.ylim(0,100)
plt.title(u"run")
#plt.legend()
plt.xlabel(u"time")
plt.ylabel(u"GPS-speed")
plt.savefig('G:/test/run.jpg')
plt.show()
print("ok!")