The script is designed to validate data in an Excel worksheet for housing dashboard from BC housing dataset. It ensures data integrity before the data is used for further processing into a database.
- Open your workbook in Excel on the web.
- Click on the Automate tab in the ribbon.
- Click on All Scripts to open the Code Editor.
- Click New Script to create a new Office Script.
- Copy the entire script from the
script.tsfile in this repository. - Paste the script into the Code Editor, replacing any existing code.
- Make sure the tab name is
Sheet1or you may need to change"Sheet1"(const sheet = workbook.getWorksheet("Sheet1")) to your Excel tab name.
- Click Run.
- If errors are found: The console will display detailed error messages.
- If no errors are found: The console will display "Great! Data validated. Ready to use."