Please follow below steps
- Read user data from excel
- First insert roles into Roles object (CMS_Role) and get role ID and hold it for Step 6
- Insert user into User object (CMS_User)
- Insert user into User Settings object (CMS_UserSettings)
- Add user to website (CMS_UserSite)
- Add role to user (CMS_UserRole)