topic Re: Insert custom table from excel of multiple worksheets. in Inventor Programming Forum

Insert custom table from excel of multiple worksheets.

Anonymous — Tue, 24 Mar 2020 13:43:47 GMT

Dim oDrawDoc As DrawingDocument = ThisApplication.ActiveDocument
Dim oSheet As Sheet = oDrawDoc.ActiveSheet

oPlacementPoint = ThisApplication.TransientGeometry.CreatePoint2d(3, 40)

oCustomTable = oSheet.CustomTables.AddExcelTable("Excel.xlsx", oPlacementPoint, "Title")

Is there any way to specify which worksheet within the excel to use as the reference for the custom table? Or is it always the first sheet?

Thanks

Re: Insert custom table from excel of multiple worksheets.

ThomasB44 — Tue, 24 Mar 2020 14:09:29 GMT

Hi @Anonymous

Unfortunatelly with this kind of code, you're right. AFAIK you can only imort the first sheet.

Re: Insert custom table from excel of multiple worksheets.

Anonymous — Tue, 24 Mar 2020 14:12:13 GMT

Is there anyway of doing it so that it can reference different sheets??

Re: Insert custom table from excel of multiple worksheets.

ThomasB44 — Tue, 24 Mar 2020 14:17:11 GMT

Separate your sheets in several Excel files...😫

Re: Insert custom table from excel of multiple worksheets.

lena.talkhina — Fri, 24 Apr 2020 09:12:57 GMT

Hello @Anonymous !

Great to see you here on Inventor Customization Forum.

Did you find a solution?
If yes, please click on the "Accept as Solution" button as then also other community users can easily find and benefit from the information.
If not please don't hesitate to give an update here in your topic so all members know what ́s the progression on your question is and what might be helpful to achieve what you ́re looking for. 🙂