In simpler terms, Alteryx is not able to read generated Excel sheets which has the prefix "x:" (e.g. from a bot). See below for some more investigation on this. The second file which has been opened and saved in Excel manually can be ...
full_path = os.path.join(directory_path, filename) # Load the Excel workbook workbook = load_workbook(full_path) # Loop over all sheets in the workbook for sheet_name in workbook.sheetnames: # Handle sheet names with spaces or special characters using quotes if sheet_name in [...