from mpl_toolkits.mplot3d import Axes3D
from matplotlib import cm
from matplotlib.ticker import LinearLocator, FormatStrFormatter
import matplotlib.pyplot as plt
import numpy as np
import xlrd
data = xlrd.open_workbook('/Users/123/58.xlsx')                             
table = data.sheet_by_name(u'58')                                               
                                  
fig = plt.figure()                                                     
ax = Axes3D(fig)
X = table.col_values(0)
Y = table.col_values(1)
Z = table.col_values(2)
surf = ax.plot_surface(X, Y, Z, cmap=cm.jet, linewidth=0.2)
fig.colorbar(surf, shrink=0.5, aspect=5)
plt.savefig('plot3d.png',dpi=800)
plt.show()