IDesignTable Interface

Solidworks学习笔记-链接Solidworks

Name	Description	备注
AutoAddNewConfigs	Gets or sets whether to automatically add rows or columns to the design table when new configurations are added to the model.	获取或设置在将新配置添加到模型时是否自动向系列零件设计表添加行或列。
AutoAddNewParams	Gets or sets whether or not to automatically add rows or columns to the design table when new parameters are added to the model.	获取或设置在将新参数添加到模型时是否自动向系列零件设计表添加行或列。
ColumnHidden	Gets the visibility state of the specified column.	获取指定列的可见性状态。
EnableCellDropdownLists	Gets or sets whether to enable cell drop-down lists in the design table.	获取或设置是否启用系列零件设计表中的单元格下拉列表。
FileName	Gets or sets the Microsoft Excel file for this design table.	获取或设置此系列零件设计表的 Microsoft Excel 文件。
LastError	Gets or sets the last error that occurred in this design table.	获取或设置此设计表中发生的最后一个错误。
LinkToFile	Gets or sets whether to link the design table to the model.	获取或设置是否将系列零件设计表链接到模型。
RowHidden	Gets the visibility state of the specified row.	获取指定行的可见性状态。
SourceType	Gets or sets the type of source file for this design table.	获取或设置此系列零件设计表的源文件类型。
Updatable	Gets or sets whether edits to the model update the design table.	获取或设置对模型的编辑是否更新系列零件设计表。
Warn	Gets or sets whether to display a warning when invalid information is encountered in the design table when updating the design table.	获取或设置更新设计表时，在设计表中遇到无效信息时是否显示警告。
Worksheet	Gets the Microsoft Excel worksheet for this design table.	获取此系列零件设计表的 Microsoft Excel 工作表。

This example shows how to disable drop-down lists for cells in a design table.

//----------------------------------------------------------
// Preconditions:
// 1. Open a part that has a design table.
// 2. In the SolidWorks Visual Studio for Applications Tools 
//    IDE, click Project > Add Reference > .NET > 
//    Microsoft.Office.Interop.Excel > OK.
// 3. Open the Immediate window.
//
// Postconditions:
// 1. Gets and edits the design table.
// 2. Disables drop-down lists for cells in the design table.
// 3. Updates and closes the design table.
// 4. Examine the Immediate window.
//
// NOTE: You can also expand Tables on the ConfigurationManager
// tab, right-click Design Table, and click Edit Feature to
// verify that Enable cell drop-down lists (may be slower)
// is not selected.
//------------------------------------------------------------
using SolidWorks.Interop.sldworks;
using SolidWorks.Interop.swconst;
using System.Runtime.InteropServices;
using System;
using System.Diagnostics;
 
namespace Macro1CSharp.csproj
{
    public partial class SolidWorksMacro
    {
  
        public void Main()
        {
            ModelDoc2 swModel = default(ModelDoc2);
            DesignTable swDesignTable = default(DesignTable);
            bool status = false;
            Microsoft.Office.Interop.Excel.Worksheet myWorksheet = default(Microsoft.Office.Interop.Excel.Worksheet);
 
            swModel = (ModelDoc2)swApp.ActiveDoc;
 
            //Get and edit design table
            swDesignTable = (DesignTable)swModel.GetDesignTable();
            myWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)swDesignTable.EditTable2(false); 
            //Allow changes to characteristics of design table
            swDesignTable.EditFeature();

            //Disable cell drop-down lists
            status = swDesignTable.EnableCellDropdownLists;
            Debug.Print("Current \"Enable cell drop-down lists (may be slower)\" setting: " + status);
            swDesignTable.EnableCellDropdownLists = false;
            status = swDesignTable.EnableCellDropdownLists;
            Debug.Print("Modified \"Enable cell drop-down lists (may be slower)\" setting: " + status);
 
            status = swDesignTable.UpdateFeature();
            Debug.Print("Design table feature updated? " + status);
 
            //Update and close design table
            swDesignTable.UpdateTable((int)swDesignTableUpdateOptions_e.swUpdateDesignTableAll, true);
 
        }
 
        /// <summary>
        ///  The SldWorks swApp variable is pre-assigned for you.
        /// </summary>
        public SldWorks swApp;
    }
}

Name	Description	备注
AddRow	Adds a row to the design table.	在系列零件设计表中添加一行。
Attach	Activates the design table within the part or assembly document.	激活零件或装配体文档中的系列零件设计表。
Detach	Detaches the design table from the Microsoft Excel sheet.	从 Microsoft Excel 工作表中分离系列零件设计表。
EditFeature	Lets you change the characteristics of the design table.	允许您更改系列零件设计表的特征。
EditTable2	Lets you edit the design table.	允许您编辑系列零件设计表。
GetColumnCount	Gets the number of columns in the design table that are currently visible in the model view.	获取设计表中当前在模型视图中可见的列数。
GetEntryText	Gets the contents of the specified cell as a string regardless of the cell's data type.	无论单元格的数据类型如何，都以字符串形式获取指定单元格的内容。
GetEntryValue	Gets the contents of the specified cell.	获取指定单元格的内容。
GetHeaderText	Gets the header text for the specified column.	获取指定列的标题文本。
GetRowCount	Gets the number of rows in the design table that are currently visible in the model view.	获取设计表中当前在模型视图中可见的行数。
GetStartColumnNumber	Gets the number of the first column in which a dimension is displayed.	获取显示维度的第一列的编号。
GetStartRowNumber	Gets the number of the first row in which dimensions are displayed.	获取显示维度的第一行的编号。
GetTitle	Gets the design table title.	获取系列零件设计表标题。
GetTotalColumnCount	Gets the number of columns in the design table.	获取系列零件设计表中的列数。
GetTotalRowCount	Gets the number of rows in the design table.	获取系列零件设计表中的行数。
GetVisibleColumnCount	Gets the number of columns visible in this design table.	获取此系列零件设计表中可见的列数。
GetVisibleLeftColumnNumber	Gets the number of the leftmost visible column.	获取最左侧可见列的编号。
GetVisibleRowCount	Gets the number of rows visible in the design table.	获取系列零件设计表中可见的行数。
GetVisibleTopRowNumber	Gets the number of the topmost visible row.	获取最顶部可见行的编号。
IsActive	Gets whether the design table is currently being edited.	获取当前是否正在编辑系列零件设计表。
SaveAsExcelFile	Saves the design table to a Microsoft Excel file.	将系列零件设计表保存到 Microsoft Excel 文件。
SetEntryText	Sets the text value of the specified entry.	设置指定条目的文本值。
SetEntryValue	Sets the data type and value in the specified cell.	设置指定单元格中的数据类型和值。
SetRowChanged	Sets the number of the row that was changed.	设置更改的行号。
UpdateFeature	Updates the characteristics of the design table.	更新系列零件设计表的特征。
UpdateModel	Applies the edits to the design table to the model.	将设计表的编辑应用到模型。
UpdateTable	Applies the changes made to the design table to the model.	将对系列零件设计表所做的更改应用于模型。

This example shows how to get a design table and its contents.

//---------------------------------------
// Preconditions:
// 1. Open a part or assembly document that
//    contains a design table.
// 2. Verify that a design table exists by 
//    expanding Tables in the ConfigurationManager.
// 3. Open the Immediate window.
//
// Postconditions:
// 1. Prints the design table contents to the 
//    Immediate window.
// 2. Examine the Immediate window.
//----------------------------------------
using SolidWorks.Interop.sldworks;
using SolidWorks.Interop.swconst;
using System.Runtime.InteropServices;
using System;
using System.Diagnostics;
 
namespace GetTitleDesignTableCSharp.csproj
{
 
    partial class SolidWorksMacro
    {
 
        public void Main()
        {
            ModelDoc2 swModel = default(ModelDoc2);
            DesignTable swDesTable = default(DesignTable);
            int nTotRow = 0;
            int nTotCol = 0;
            string sRowStr = null;
            int i = 0;
            int j = 0;
            bool bRet = false;
 
            swModel = (ModelDoc2)swApp.ActiveDoc;
 
            swDesTable = (DesignTable)swModel.GetDesignTable();
            bRet = swDesTable.Attach();
 
            nTotRow = swDesTable.GetTotalRowCount();
            nTotCol = swDesTable.GetTotalColumnCount();
            Debug.Print("File = " + swModel.GetPathName());
            Debug.Print("  Title        = " + swDesTable.GetTitle());
            Debug.Print("  Row          = " + swDesTable.GetRowCount());
            Debug.Print("  Col          = " + swDesTable.GetColumnCount());
            Debug.Print("  TotRow       = " + nTotRow);
            Debug.Print("  TotCol       = " + nTotCol);
            Debug.Print("  VisRow       = " + swDesTable.GetVisibleRowCount());
            Debug.Print("  VisCol       = " + swDesTable.GetVisibleColumnCount());
            Debug.Print("");
 
            for (i = 0; i <= nTotRow; i++)
            {
                sRowStr = "  |";
                for (j = 0; j <= nTotCol; j++)
                {
                    sRowStr = sRowStr + swDesTable.GetEntryText(i, j) + "|";
                }
                Debug.Print(sRowStr);
            }
            swDesTable.Detach();
        }
 
        /// <summary>
        /// The SldWorks swApp variable is pre-assigned for you.
        /// </summary>
 
        public SldWorks swApp;
 
    }
}