CAD Forum discussion (EN) : self populating spreadsheet https://www.cadforum.cz/forum_en/ Sun, 31 May 2026 22:31:02 +0000 Sat, 01 Jul 2017 17:59:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://www.cadforum.cz/forum_en/RSS_post_feed.asp?TID=12382 <![CDATA[CAD Forum discussion (EN)]]> https://www.cadforum.cz/forum_en/forum_images/web_wiz_forums.png https://www.cadforum.cz/forum_en/ <![CDATA[self populating spreadsheet : There may be no existing application...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=12382&PID=34900&title=self-populating-spreadsheet#34900 Author: Vladimir Michl
Subject: 12382
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
]]> Sat, 01 Jul 2017 17:59:30 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=12382&PID=34900&title=self-populating-spreadsheet#34900 <![CDATA[self populating spreadsheet : Hey everyone! Here&#039;s the...]]> https://www.cadforum.cz/forum_en/forum_posts.asp?TID=12382&PID=34893&title=self-populating-spreadsheet#34893 Author: daverdat
Subject: 12382
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!
]]> Thu, 29 Jun 2017 19:09:23 +0000 https://www.cadforum.cz/forum_en/forum_posts.asp?TID=12382&PID=34893&title=self-populating-spreadsheet#34893