CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 1316

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. For controlling Excel access in iLogic rules, use a similar environment variable, "iLogicUseLibXL".

Inventor2024Inventor2021
100% *  CAD 
25.9.2020    17208×  
Prices - CAD eShop:
applies to: Inventor 2024 · Inventor 2021 ·

See also:


Back   All CAD Tips



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:
Extend your AutoCAD LT productivity with our popular add-on
CADstudio LT Extension More info


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