Import Excel Table into Drawing using ilogic

[Anonymous]

Hello,

I have been trying to import my excel table in the directory;

C:\Users\tm04.smeric\Desktop\Meric\EXCEL NOZZLE LIST.xlsm

into my drawing, the excel table constantly changes since I have another rule that updates it with the iProperties of the current drawing/project.

If anyone knows how I can implement a rule to import the table that is created on "Sheet1" I'd greatly appreciate it.

Thanks in advance

[bradeneuropeArthur]

Hi,

Take a look at this:

AddExcelTable(ExcelFileName As String, PlacementPoint As Point2d, [Title As String], [StartCell As String = "A2"], [ColumnHeaderRow As Long = 1]) As CustomTable

lLike this:

Public Sub CreateDrawingExcelTable()    
    ' Set a reference to the active drawing document
    Dim oDrawDoc As DrawingDocument
    Set oDrawDoc = ThisApplication.ActiveDocument
    
    ' Set a reference to the active sheet
    Dim oActiveSheet As Sheet
    Set oActiveSheet = oDrawDoc.ActiveSheet
    
    ' Create the placement point for the table
    Dim oPoint As Point2d
    Set oPoint = ThisApplication.TransientGeometry.CreatePoint2d(25, 25)
    
    ' Create the table by specifying the source Excel file
    ' This assumes that the first row in the Excel sheet specifies the column headers
    ' You can specify a different row using the last argument of the AddExcelTable method
    Dim oExcelTable As CustomTable
    Set oExcelTable = oActiveSheet.CustomTables.AddExcelTable("C:\Temp\test.xls", oPoint, "Excel Table")
End Sub