CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 2591 

CAD tip CAD tip # 12743:

Question CAD 
 %  platform  category 
Q - question

A change in iLogic processing of Excel tables since Inventor 2021.

A - answer Inventor 2021 changes the default method for processing Excel spreadsheets through iLogic rules running in Inventor. Previous versions used by default the so-called "COM" model, i.e. they used the true Excel kernel. As of version 2021, the faster internal library "LibXL" is used by default for this approach.

You can change this setting in the dialog "iLogic - detailed configuration" (Tools > Options panel > iLogic – configuration).

It should be taken into account that accessing XLS tables may behave differently in certain situations. Although the LibXL library is significantly faster in reading and writing Excel spreadsheets, it is not a full Excel. For example, it cannot recalculate formulas in table cells. Therefore, if you write a new value using an iLogic macro into Excel, the fields that depend on that value will not be recalculated. This will be performed only after you open that spreadsheet in MS Excel.

Therefore, if you need such functionality, switch the Excel module in the iLogic settings from "Internal" to "COM". You will also need the "COM" setting if you are using the iLogic GoExcel.Automation object.

Usage of LibXL can be disabled by setting the environment variable "UseLibXL" to the value of "False". This will enable Inventor to use methods based on Excel.

Inventor2021
100% *  CAD 
25.9.2020    618×  
applies to: Inventor 2021 ·

See also:


Back   All CAD Tips All CAD tips&tricks



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit Tools More info


Please use these tips at your own risk.
CAD Studio is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist