Defining test cases with a spreadsheet

Please help me !!,

1.All the libraries from field are kept in one single directory
2.An excel sheet is prepared which has the name of all the libraries in the folder
3.Script will read the excel and pick the library name one by one
4.Once a library is picked up, the script will go to the station and will perform the steps to import that selected library into the station. Ensure that the success message comes.

Please send me any helping documents.

eggPlant can’t read directly from an Excel file. You will need to export the contents of the Excel file to a csv text file.

The steps in part 4 are too vaguely defined to offer any specific suggestions.