ExpLens enables you to work with financial data freely and without restrictions, privately or commercially. You can use ExpLense free of charge for your family, your organization, or as a tool in services you offer.
However, to protect our investment in building and maintaining ExpLense, we restrict using it for competitive or alternative offerings to our core mission:
» Tools for financial data analysis
» Synchronization of financial data
Interested in collaborating on a similar offering?
Reach out! We'll work out reasonable terms.
The above the intent of our licensing strategy. See LICENSE.md for complete terms.
-
Generic libraries (explicitly listed): MIT License
- ✓ use freely, including commercially.
-
Everything else: PolyForm Shield 1.0.0 License
- ✓ Personal and internal use: allowed.
- ✓ Reading, modifying, and sharing code: allowed.
- ✗ Building competing commercial products/services: not allowed.
- ✗ Selling or hosting as a service: not allowed.
Disclaimer: The authors and contributors accept no responsibility, direct or indirect, for any consequences from using this project.
(If some info was missing and you needed to figure it out, please create a pull request to add it here.)
Clone the repo. Then:
npm install or npm ci
npm run dev --qPublicBasePath=app/current/excel
(this invokes quasar dev and passes a parameter to set the URL base the way Excel expects it)
Quasar will build the app and host it under http://localhost:9000/app/current/excel/.
Note: if port 9000 is taken, Quasar might silently choose another port. However, Excel will look for ExpLens on
port 9000. If you need to use another port, make sure to modify the manifest accordingly
(ExpLens.Excel-AddIn.Manifest.xml).
quasar build or npm run build --qPublicBasePath=url/base/path
The release version of ExpLens works on Excel Web and Excel Desktop (Windows & Mac).
The instructions here are for the dev version (Windows desktop).
-
Share the root folder of your cloned repo as a local network drive.
E.g., if you cloned intoc:\Code\ExpLens\and your machine is calledDEV-PC, then your share might be called\\DEV-PC\ExpLens. -
In Excel, add the network share as a trusted Add-In Catalog:
- Go to: File > Options > Trust Center > Trust Center Settings > Trusted Add-In Catalogs.
- In Catalog Url, enter the address of your file share
(e.g.,
\\DEV-PC\ExpLens). - Click Add catalog, select Show in menu, OK all dialogs, and restart Excel (make sure to close all windows).
-
Activate the Add-In:
Home > Add-ins > More Add-ins. At the top you will have a Shared Folder option. When you select it, you will see the ExpLens add-in in the list. Install it.
The Add-In will start and attempt to load from
http://localhost:9000/app/current/excel/
(See section 'Build and start locally' above.)
Return to Trusted Add-In Catalogs, remove the shared repo directory, conform, and restart Excel (all windows).
-
Clone the repo and install packages.
(see above) -
Build and start the dev server.
(see above) -
Install the manifest using the Office AddIn tool:
npm run office-start
This will put some settings into the registry and open Excel with the Add-In loaded.
The Add-In will start and attempt to load from
http://localhost:9000/app/current/excel/
(See section 'Build and start locally' above.)
If you thought this was easier than the "Admin Style", then you have not yet tried to uninstall the
Add-In (which is a normal par of the dev process).
If you time it well, then this will do it:
npm run office-stop
But some of the time the state required for the tool to correctly know how to uninstall is lost, and you have to
go to the registry. The add-ins are listed under:
Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\WEF\Developer.
Find the one you want to remove, and delete all associated entries (there are several).