Civil LAB - Excel
  • What is CIVIL LAB Excel?
  • Introduction
    • How to use ? Installation
    • Introduction of the modules
    • Copy right agreement
  • Documentation
    • Ribbon Tools
      • Formatting tools
        • Color It
        • Advanced Formatting
        • Auto Units
        • Group color
      • Utilization Tools
        • Pro copy
        • Level Sum
      • EuroCode Tools
        • Eurocode 4
        • Eurocode 3
        • Eurocode 2
          • Creep Coefficient
        • Eurocode 0 & 1
      • Database tools
        • Engineer Database
        • Group to index
        • Index to group
    • Built-in functions
      • General Functions
        • CL_G_TabelInterpolation
        • CL_G_CreateListTablePicker
        • CL_G_ListTableFind
        • CL_G_Table_find
        • CL_G_VlookupTable
      • Database Function
      • Eurocode function
      • Mechanical functions
        • CL_M_Rebars_A
        • CL_M_Recdata
        • CL_M_HProfileData
        • CL_M_Zel
    • Ready made Excel
      • Parametric tool : input output
      • Composite beam stiffness
    • Excel-Python
  • Contacts and development
    • For Programmers
      • Civil LAB framework
      • Resources
      • Naming Rules
      • Guides to Function Modules
      • Guides to Data Tables
      • Guides to Ribbons
    • For Engineers
      • What is possible?
    • For Supporter
      • Donation / contribution
    • Contact infomation
  • 💾Downloads
  • Road map
    • Road Map
Powered by GitBook
On this page
  • 1) How to add tables
  • 1) Functions for table data checking
  1. Contacts and development
  2. For Programmers

Guides to Data Tables

PreviousGuides to Function ModulesNextGuides to Ribbons

Last updated 3 years ago

1) How to add tables

To add the data tables it could be simply added under the hidden spreadsheet “CL_Tables”. By the following step

· Add a new table

· Format as listTable by Home > Format as Table

· Change the Table name by Formulas -> Name Manager

1) Functions for table data checking

There are built in function “CL_G_ListTableFind” for easer to check the data from a listTable, details could see the example in module in “”CL_DATABASE”. It is also possible to do a interpolation based on the xy data provided in the table by using “CL_G_TabelInterpolation”