This project scans two Excel files for duplicate titles based on a set of keywords. The results are written to a new Excel file.
- Node.js
- npm
- Clone the repository: git clone
- Navigate into the project directory: cd
- Install the dependencies: npm install xlsx typescript ts-node @types/node
- Place your Excel files (
login.xlsx
andlogin2.xlsx
) in the project directory. - Run the script: npx ts-node scanDuplicates.ts
- The results will be written to
duplicates_Result.xlsx
in the project directory.
- Add more keywords to the
keywords
array inscanDuplicates.ts
to scan for additional patterns. - Refine the keyword matching logic in
scanForDuplicates
function to use regex for more complex patterns.