The Student Enquiry Team uses data from their rosters which is used in statistics that measure staff performance. This tool extracts the data from the roster and puts it into a table format which makes it easier to generate statistical information.
This tool is an Excel Add-in written using the Office JavaScript API.
localhost certificates are required for development and testing the add-in on your local machine. These certificates expire after 30 days, after which you will need to reinstall new certificates.
Use the following command to troubleshoot your certificate:
npx office-addin-dev-certs verifyUse the following command to uninstall the certificate:
npx office-addin-dev-certs uninstall --machineUse the following command to install a new certificate:
npx office-addin-dev-certs install --machineTo test the tool, you will need a copy of the SET Roster stored on OneDrive or SharePoint.
Start the test server:
npm run dev-serverOpen the file:
npm run start: web -- --document "documentUrl"This repo is set to public and the files are hosted on GitHub Pages using the deploy branch as the source.
-
Run
git checkout deploy && git merge main --no-editto change branch and sync your changes from main so you are read to redeploy. -
Now let's bundle our application into
distwith your build command. For now, that'snpm run build. -
Run the following in order:
git add dist -f && git commit -m "Deployment commit"
git subtree push --prefix dist origin deploy
git checkout main