import openpyxl
from pyautocad import Autocad,APoint
import sys
reload(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[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 b
zb=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"