Print Page | Close Window

self populating spreadsheet

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=12382
Printed Date: 31.May.2026 at 21:39


Topic: self populating spreadsheet
Posted By: daverdat
Subject: self populating spreadsheet
Date Posted: 29.Jun.2017 at 19:09
Hey everyone! Here's the deal, I've been looking for a forum for some autocad applications just a little beyond the beginner stuff. What I'm trying to accomplish is the creation of a spreadsheet that fills itself out as I draw. My drawings are of PV systems (solar panels) and I would like to know how to have a cell contain the number of polylines drawn on a specific layer. Can anyone help me here?

As a follow up question, is there an authoritative place I can go to research and find the answers to  questions like this on my own?

Thanks!


Replies:
Posted By: Vladimir Michl
Date Posted: 01.Jul.2017 at 17:59
There may be no existing application for this specific task but it can be done - see e.g. the Click2XLS utility in the Download area for populating a spreadsheet with clicked coordinates or texts.

You may also use DATAEXTRACTION and an associative table with results of this extraction embedded in the drawing.

See:
http://www.cadforum.cz/cadforum_en/associative-dwg-table-of-line-length-totals-by-layer-tip8677
http://www.cadforum.cz/cadforum_en/how-to-invoke-updates-of-the-data-extraction-table-tip8679


-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner


Print Page | Close Window