I have more than one Excel sheet in my single sheet. Please advise me on how to import it into the test project.and How to read data in to the all sheets and use in my testproject script

I have more than one Excel sheet in my single sheet. Please advise me on how to import it into the test project.and How to read data in to the all sheets and use in my testproject script.

Using pandas you can read your excel or csv file after that you can pass input of any column or you can compare also