import pandas as pd
import xlwt
import os
import matplotlib.pyplot as plt
import numpy as np
workbook = xlwt.Workbook()
#name_list = ['V_YDJT_MHXT_DB_01_USED .xls', 'V_YDJT_HRXT_DB_01_USED.xls', 'V_YDJT_DS_DB_01_USED.xls']
name_list = ['V_YDJT_MHXT_DB_01_USED']
files = os.listdir(r'.')
for txt_file in files:
for name in name_list:
if name in txt_file:
# print(txt_file)
df = pd.DataFrame(pd.read_excel(txt_file))
istackList = df[['istack']].values.T.tolist()[:][0]
computeList = df[['compute01']].values.T.tolist()[:][0]
ipList = df[['ip']].values.T.tolist()[:][0]
instanceList = df[['instance-name']].values.T.tolist()[:][0]
# print (instanceList [0] )
# print("all istack")
# print(istackList)
istackList =