Relative Content

Tag Archive for office-jsautofilterexceljs

Using OfficeJS to Filter an Excel Speadsheet

I have a large database of our employees that lists the last time they took the required trainings. We send regular reports to supervisors with the status of their employees, and I’m wanting to change this to become a “self-service” feature on our SharePoint site. I created a dashboard where the supervisor types in their email, and it populates a table with all the employees they supervise (this column uses the Filter feature in excel). There are two other columns that use xlookup to pull the date the employee completed the training or the date the employee is enrolled in the training.