How to compare excel? | Playwright Tutorial - Part 91

• 00:39 Installing exceljs library
• 01:40 Downloading and comparing Excel files
• 04:05 Modifying original Excel file and running the test
• 06:00 Comparing JSON objects

In this video tutorial, the presenter demonstrates how to download, extract, and compare Excel files using Playwright and TypeScript. To achieve this, they are using a library called exceljs. First, the presenter installs the package using the terminal and then explains the process of extraction and comparison.

The presenter navigates to a website, downloads an Excel file from the site, and compares the contents of the downloaded Excel file with the contents of an original Excel file stored on their system.

To demonstrate how the comparison works, the presenter modifies the original Excel file, changing some values to create discrepancies between the two files, and re-runs the test. The console shows the difference in values between the two files, indicating that the comparison has been successful.

Using Playwright and TypeScript, the presenter demonstrates how to read an Excel file, convert its contents to JSON, and compare the resulting JSON objects. The code for this process is provided and explained in detail, making it easy to understand and implement in your own projects.

In summary, the video offers a helpful tutorial on how to download, extract, and compare Excel files using Playwright and TypeScript, highlighting useful features and providing clear explanations on how to achieve your desired results.