Using GoExcel to read a embedded spreadsheet

Using GoExcel to read a embedded spreadsheet

harvey_craig2RCUH
Advocate Advocate
191 Views
2 Replies
Message 1 of 3

Using GoExcel to read a embedded spreadsheet

harvey_craig2RCUH
Advocate
Advocate

I can't get GoExcel to read a cell in an embedded spreadsheet.

 

The spreadsheet has one cell:

harvey_craig2RCUH_0-1756457986626.png

I've embedded it using the UI:

harvey_craig2RCUH_1-1756458015927.png

This is my local rule:

MsgBox(GoExcel.CellValue("3rd Party:Embedding 1", "Sheet1", "A1"))

 And this is my error:

harvey_craig2RCUH_2-1756458069578.png

I have tried both these options in the options:

harvey_craig2RCUH_3-1756458234323.png

Both get the same object reference error.

 

 

I have also attached the drawing.

 Why doesn't this work?

 

Thanks,

Harvey

 

0 Likes
192 Views
2 Replies
Replies (2)
Message 2 of 3

harvey_craig2RCUH
Advocate
Advocate

No one?

 

I've seen you guys solve absolute wizardry compared to this.

 

Harvey

0 Likes
Message 3 of 3

A.Acheson
Mentor
Mentor

Hi @harvey_craig2RCUH 

Embedded excel sheets can be quirky. Follow the steps shown here. 

https://help.autodesk.com/view/INVNTOR/2024/ENU/?guid=GUID-E897A20C-3859-435A-AA5F-8B6D5921FFAE

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan
0 Likes