Skip to content
Add-in for Excel that finds formula errors
TypeScript JavaScript Python HTML CSS
Branch: master
Clone or download

Latest commit

Latest commit b432c56 Apr 14, 2020

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github/ISSUE_TEMPLATE Update issue templates Jun 5, 2019
assets Restored. Jun 1, 2019
certs Attempt with locally generated certs. Mar 28, 2020
config Attempt with locally generated certs. Mar 28, 2020
dist Trying non beta. May 27, 2019
docs Added paper. Jul 30, 2019
examples First example. Jul 26, 2019
experimental Updated. Jan 2, 2020
function-file Try with non-debug version. Jun 13, 2019
logos/ExceLint More color fixing; removed logging messages; improved display. Mar 20, 2019
node_modules/@types/office-js Updated node modules. Apr 5, 2020
old Moved old manifest files. Jan 2, 2020
src Removed some cruft. Apr 14, 2020
COPYING Added license. Aug 21, 2019
LICENSE Added license. Aug 21, 2019
NOTES Added programmatic color stuff. Mar 28, 2019
README.md Added git link. Mar 29, 2020
_config.yml Set theme jekyll-theme-cayman Jun 4, 2019
app.css Added. Mar 12, 2019
index.html Added a line break. Jun 6, 2019
manifest-localhost.xml Updated support link. Jul 27, 2019
manifest.xml Updated support link. Jul 27, 2019
package-lock.json Updated node modules. Apr 5, 2020
package.json Updated node modules. Apr 5, 2020
privacy.html Removed third-party discussion. Jun 5, 2019
resource.html Added. Mar 12, 2019
tsconfig.json Removed advanced target to support IE11. Jul 26, 2019
tslint.json Current work; not quite there. Jun 16, 2019
webpack.config.js Removed windows cert thing (outdated). Jul 29, 2019

README.md

[ExceLint logo]

ExceLint is an Excel add-in that automatically finds formula errors in spreadsheets. It is a product of research from the PLASMA lab @ UMass Amherst and Microsoft Research.

by Dan Barowy (Williams College), Emery Berger (UMass Amherst / Microsoft Research), and Ben Zorn (Microsoft Research).

Installation

ExceLint works as an add-in for all modern versions of Excel, including Mac, Windows, and online. You need to install the file manifest.xml following the appropriate instructions for each platform:

Source code

Source code for the add-in may be found at its GitHub repository.

Privacy

The ExceLint add-in does not collect personally identifiable information. See the privacy statement for more details.

Support

ExceLint is provided without any guarantee of support. However, we welcome bug reports and enhancement/feature requests.

Technical Details

The following technical paper describes how ExceLint works and includes an extensive empirical evaluation: ExceLint: Automatically Finding Spreadsheet Formula Errors, Daniel W. Barowy (Williams College), Emery D. Berger (University of Massachusetts Amherst), Benjamin Zorn (Microsoft Research). In Proceedings of the ACM on Programming Languages, Volume 2, Number OOPSLA.

Development

The ExceLint addin is written entirely in TypeScript. It is already set up to be hostable locally.

Requirements

To run ExceLint locally, you will first need to install Node and Git.

Running the ExceLint service locally

First, run the following commands to build and start the local ExceLint service (which just hosts the assets).

git clone https://github.com/plasma-umass/ExceLint-addin
cd ExceLint-addin
npm install
npm run start-local

Testing

The easiest way to test the local service is to use Excel 365 (https://www.office.com/launch/excel?auth=2). Open a workbook, click the Insert menu, then click "Office Add-ins" on the ribbon. Click "Upload My Add-in" (in the upper-right hand corner), and select the file manifest-localhost.xml. If everything works as planned, you should see an icon for ExceLint on the Home ribbon. Click on it and it should open the task pane on the right-hand side of the window.

Acknowledgements

This material is based upon work supported by the National Science Foundation under Grant No. CCF-1617892. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

You can’t perform that action at this time.