I have an excel workbook with 36 sheets (not my fault). The code below 'works', reads in the file but only the first sheet. I concat and send to csv and the result is only 'Sheet1". Thoughts?
import pandas as pd Data = pd.read_excel(open("P://XXDrives//Folder_1//Folder_2//XX.xlsx", "rb"), sheet_name = None) pd.concat([Data], axis=0, ignore_index=True) Data.to_csv('C://Users//MyName//Desktop//test.csv')
Have an answer?