Develop a Python Script to Automate Data Import from Excel to a Database

Develop a Python script that automates the process of importing data from an Excel spreadsheet into a database. The script should be able to handle multiple sheets within the spreadsheet, and it should be able to perform data cleaning and transformation before importing it into the database. The script should also include error handling and logging mechanisms to ensure that any issues are caught and resolved quickly. The target database is a MySQL database, and the script should be able to handle up to 1000 rows of data per import. Please include a detailed code snippet and explanations of the script's functionality.