iLogic to create Custom table from excel file containing different worksheets

[dutt.thakar]

Hello,

I am trying to create a custom table in Inventor drawing using iLogic. I have got one code by which I am able to copy the first worksheet data from excel file. The code is shown below.

Dim oDrawDoc As DrawingDocument
  oDrawDoc = ThisApplication.ActiveDocument
    
    
     Dim oActiveSheet As Sheet
      oActiveSheet = oDrawDoc.ActiveSheet
    
    
      Dim oPoint As Point2d
      oPoint = ThisApplication.TransientGeometry.CreatePoint2d(25, 20)
    

     Dim oExcelTable As CustomTable
oExcelTable = oActiveSheet.CustomTables.AddExcelTable("Trial.xlsx",oPoint,"Trial")

Is there any way I can copy data from different worksheets and create tables using iLogic from  one excel file

[chandra.shekar.g]

@dutt.thakar,

Custom tables can also be created using cell values of excel sheet. For more details, refer below blog link to create custom table.

https://adndevblog.typepad.com/manufacturing/2014/03/save-revisiontable-content-to-customtable.html

Can you please provide sample excel (multiple worksheet) and expected custom table (snapshot)? please make sure that files are non confidential.

Thanks and regards,