pyautocad+openpyxl简单的处理一下cad文件

from pyautocad import Autocad

import openpyxl


wb=openpyxl.load_workbook('./cads.xlsx')
sheet=wb.get_sheet_by_name('Sheet1')
data=[]
pset=[]

acad=Autocad(create_if_not_exists=True)

acad.prompt('hello this is python in')

for text in acad.iter_objects('Text'):
    data.append(text.TextString)

from pyautocad import APoint
    
for text in acad.iter_objects('Text'):
    pset.append(APoint(text.InsertionPoint))
    
    


print len(data)


for d in range(1,len(data)):
    sheet['A'+str(d)].value=data[d]
    sheet['B'+str(d)].value=str(pset[d].x)
    sheet['C'+str(d)].value=str(pset[d].y)

wb.save('aabb1.xlsx')
print 'success aabb1.xlsx'

其实pyautocad中有关于table的api。后期再看看。