I am not aware of a way to directly read an excel file in AO. You will have to convert this excel file into a CSV which can be read using the CSV Actor adapter. You can then loop through every row and create remedy tickets for each one.
Thankyou for the suggestion , my question is can we create a csv file using BMC AO.
yes, you can use the file adapter to create CSV or XML files. If you perform a search in this section, there are multiple discussions on how to achieve this.