Build Data Interrelation between Excel and Drawing Objects

-In this tutorial, let’s see how to create and interrelate an Excel table from drawing objects.

-Did you know that you can perform area/length and block quantity calculation with Autoxlstable?

-From Express tab > Autoxlstable panel, select the Selection Management command.

-Under User Define Selection, the Area option is selected by default.

-You can assign a proper name for Area calculation.

-Then click New Group button and select the object within the drawing.

-You can quickly repeat the process to define more areas or even a length as object to be calculated.

-Now it’s time to create the table.

-From Express tab > Autoxlstable panel, select the Create Table command.

-The Microsoft Excel will be open automatically.

-If you already created an Excel table, just copy (CTRL+C) and paste (CTRL+V) it to the new excel spreadsheet.

-You might have to position the mouse under the Qty. cell

-Go to Add-ins tab on the ribbon and press the Insert Function button.

-Under Block Calculate, you can find the correspondent block name from the list.

-From the layer drop-down list, select *ALL option and press Ok button.

-You’ll see the current block quantity regarding to the drawing.

-You can quickly repeat the same Insert Function process for each block on the table.

-Now let’s position the cursor under the Area cell.

-Go to Add-ins tab on the ribbon and press the Insert Function button.

-Under Area Calculate, you can find the correspondent Area name from the list.

-From the layer drop-down list, select *ALL option and press Ok button.

-You can repeat the same Insert Function process for area and length calculation.

-To finish the table, go to Add-ins tab on the ribbon and press the Finish button.

-You can save the current spreadsheet with a proper name.

-Back in the software, specify an insertion point within drawing area.

-Now if you add or delete some blocks and alter the geometry of a defined area or length from the drawing, the table will be updated automatically.

-Statistics like quantity of blocks, length or area of certain kind of entity in the table is possible to be interrelated to current drawing.


Discover more from Gstarsoft's Blog

Subscribe to get the latest posts sent to your email.

  • GstarCAD Blog

    www.gstarcad.net

    Related Posts

    Parametric Constraints in Dynamic Blocks: What’s New in GstarCAD 2027

    In the field of architecture, construction, and mechanical design, changes are a constant. Whether driven by updated safety guidelines, client revisions, or evolving project requirements, designers are regularly asked to…

    Top 5 Essential GstarCAD Shortcuts for Designers

    In the process of drawing and editing with GstarCAD, mastering basic functions and shortcuts can significantly reduce redundant operations while improving drawing precision and efficiency. The five features—Ctrl+3 (Tool Palettes),…

    Leave a Reply

    Don't Miss out

    Gstarsoft and AppliCAD Launch GstarSolutions Thailand, Deepening Their Partnership in the Thai Market

    • September 21, 2026
    Gstarsoft and AppliCAD Launch GstarSolutions Thailand, Deepening Their Partnership in the Thai Market

    Modernizing Without Disruption: What European SMEs Can Learn from SNIE’s Experience

    • September 18, 2026
    Modernizing Without Disruption: What European SMEs Can Learn from SNIE’s Experience

    GstarCAD Mechanical 2027: Smarter Workflows, Better Compatibility

    • September 15, 2026
    GstarCAD Mechanical 2027: Smarter Workflows, Better Compatibility

    AI Rendering Workflow: How GstarRender Improves Design Visualization

    • September 8, 2026
    AI Rendering Workflow: How GstarRender Improves Design Visualization

    What Is CAD? A Beginner’s Guide to Learning CAD

    • September 1, 2026
    What Is CAD? A Beginner’s Guide to Learning CAD

    Interior Design Software: From Floor Plans to AI-Powered Visualization

    • August 25, 2026
    Interior Design Software: From Floor Plans to AI-Powered Visualization

    Discover more from Gstarsoft's Blog

    Subscribe now to keep reading and get access to the full archive.

    Continue reading

    Discover more from Gstarsoft's Blog

    Subscribe now to keep reading and get access to the full archive.

    Continue reading