pandas support for multiple sheets excel code example
Example 1: how to read multiple worksheet from a single workbook in column in python
stops = read_excel_sheets("data/PIALog_through-20171231.xlsx")
Example 2: how to read multiple worksheet from a single workbook in column in python
stops2 = read_excel_sheets("data/PIANorthCarolina_02152019.xlsx")
stops2.to_csv("data/stops.01end.csv", mode="a", header=False, index=False)