python处理计算机辅助设计软件文字信息并实现排序输出

来源：互联网发布：多玩魔兽世界数据库编辑：程序博客网时间：2024/05/20 20:48

import openpyxlfrom pyautocad import Autocad,APointimport sysreload(sys)sys.setdefaultencoding("utf-8")wb=openpyxl.load_workbook("a.xlsx")sheet=wb.get_sheet_by_name("Sheet1")data=[]pxy=[]acad=Autocad(create_if_not_exists=True)acad.prompt("hello this is mt")for text in acad.iter_objects('Text'):    pxy.append((APoint(text.InsertionPoint).x,APoint(text.InsertionPoint).y))def zuobiaopaixu(a):    b=[]    l=len(a)    for i in range(l):        j=i        for j in range(l):            if (a[i][0]<a[j][0]):                a[i],a[j]=a[j],a[i]            if (a[i][1]>a[j][1]):                a[i],a[j]=a[j],a[i]    for k in range(len(a)):        b.append(a[k])    return bzb=zuobiaopaixu(pxy)for i in range(len(zb)):    for text in acad.iter_objects('Text'):        if(APoint(text.InsertionPoint).x==zb[i][0] and APoint(text.InsertionPoint).y==zb[i][1]):            data.append(text.TextString)#创建分割符###for d in range(0,len(data)):    if(str(data[d])[0:3]=="tex" or str(data[d])[0:3]=="###"):        sheet["A"+str(d+1)]=data[d]wb.save("aabb.xlsx")print "success"

0 0