python把Excel数组转化为文本

from openpyxl import Workbookfrom openpyxl import load_workbookimport os;owb = Workbook()   #输出wbows = owb.active   #获取活动表ows.title = "sheet"    #命名表wb1 = load_workbook('附件1  相关的要素名称及位置坐标数据.xlsx') #读入1 s_name1 = wb1.get_sheet_names() #得到输入表名数组 ws1 = wb1.get_sheet_by_name(s_name1[0]) #得到读入book1的第一张表 print ('sheet_name:%s'% s_name1[0]) f=open("aera.txt","w")for i in range(1,116):    for j in range(1,7):        f.write("{0} {1}".format( ws1.cell(row=i, column=j).value,' '))    f.write('\n')f.close()