topic Re: GoExcel.Cellvalue no longer works in Inventor Programming Forum

GoExcel.Cellvalue no longer works

Anonymous — Wed, 08 Sep 2010 20:07:50 GMT

iProperties.Value("Project", "Description") = GoExcel.CellValue("Spreadsheet.xls", "Sheet1", "B11")

This simple line of iLogic code worked fine in inventor 2009, but it no longer worked in 2010, and still does not work in Inventor 2011. Is GoExcel.CellValue no longer supported? Can anyone else get this to work in the newer versions?

Thank you.

Re: GoExcel.Cellvalue no longer works

MjDeck — Wed, 08 Sep 2010 20:38:26 GMT

That should work if the Excel file in the same directory as the Inventor part or assembly, and it has a sheet named "Sheet1". Can you provide more details? Does it give you an error message, or just do nothing? Does your rule contain any other statements?

Re: GoExcel.Cellvalue no longer works

Anonymous — Wed, 08 Sep 2010 21:09:47 GMT

Hi Mike,

It did give an error message

Error in rule: Desc_Rule, in document: 6 BAGHOUSE 849.iam

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

The same code will work fine when I go back to Inventor 2009, and every computer in the office has the same error, not just the one on my desk.

The rule does not contain anything else. It just gets a cell value and places it in the description. I have played with the code and just tried to get a cell value and put it in a message box and that also does not work. I am using Excel 2000 if that makes a difference.

Thanks again

Re: GoExcel.Cellvalue no longer works

MjDeck — Wed, 08 Sep 2010 23:15:42 GMT

We improved the Excel interface in iLogic for Inventor 2010 and 2011, and unfortunately Excel 2000 is not compatible. You need Excel 2003 or later. There might be a workaround to support 2000, but it would require custom code in the rule to communicate directly with Excel, instead of using the GoExcel function.

Re: GoExcel.Cellvalue no longer works

Anonymous — Thu, 09 Sep 2010 12:26:37 GMT

Ok Mike, thanks for the help. The little company that I work for is suppose to upgrade to Office 2007 some time soon. I will not waste any more time trying to get this to work until we get the upgrade.