CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 7572
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

 

HelpCAD discussion

 
CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic Closedself populating spreadsheet

 Post Reply Post Reply
Author
daverdat View Drop Down
Newbie
Newbie


Joined: 29.Jun.2017
Location: United States
Using: Autocad2017
Status: Offline
Points: 2
Direct Link To This Post Topic: self populating spreadsheet
    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!
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2018
Direct Link To This Post 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 Systems - arkance-systems.cz - Autodesk reseller
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,527 seconds.