Scrape Specific Site Data

I have a requirement to scrape dynamic data from the Rajasthan RERA website.

Source Link:
https://rera.rajasthan.gov.in/Home/AgentSearch

Requirement:

I need to extract details of all RERA registered agents, including:
• Agent Name
• Registration Number
• Email ID
• Mobile Number
• Address (if available)
• Any other relevant available fields

The website data is dynamic (search-based), so the solution should handle pagination and dynamic loading.

Final Output Format:
• Complete data in Excel format (.xlsx)
• Proper column-wise structured data
• No duplicate entries
• Clean and properly formatted dataset