AJAX Employee Data Scraper (Selenium-based)

A Python script that uses Selenium to extract employee data from the dynamically loaded AJAX table at DataTables.net.

Features

• Automates Chrome in headless mode to access data
• Waits for dynamic AJAX content to load
• Extracts:
  • Name
  • Position
  • Office
  • Extension
  • Start Date
  • Salary
• Saves data into Excel (.xlsx) format

Tech Stack

• Python
• Selenium
• WebDriver Manager
• Pandas
• OpenPyXL (for Excel export)

Installation

Install the required packages:

pip install selenium webdriver-manager pandas openpyxl

Usage

python datatable_export_all_pages.py

Output

An Excel file (datatable_export_all_pages.xlsx) saved to your specified folder.

Screenshot