Invantive Control for Excel provides formulas that extend Excel to access data from databases and applications.
The following formula sets are always available:
- [[Invantive Control for Excel/Formulas/Generic/Generic|Generic]]
- [[Invantive Control for Excel/Formulas/Repository/Repository]]
The following sets of formulas are only available when connected to the related application via an Invantive database:
- [[Company.info]]
- [[Invantive Control for Excel/Formulas/Exact Online/Exact Online|Exact Online]]
- [[Invantive Control for Excel/Formulas/Generic/Generic|Generic]]
- [[Invantive Control for Excel/Formulas/Invantive Estate/Invantive Estate|Invantive Estate]]
- [[Invantive Producer]]
- [[Nmbrs]]
- [[Odoo]]
- [[Invantive Control for Excel/Formulas/Repository/Repository|Repository]]
- [[Teamleader Focus]]
- [[Visma.net Financials]]
Data from all applications and database platforms are accessible through the SQL formulas:
- [[I_SQL_SELECT_SCALAR]]
- [[I_SQL_SELECT_TABLE]]