Read excel file with Python notebooks

Hi, can someone please let me know how to read an excel file using Python notebooks in Alteryx? I tried:

import pandas as pd

fileName = pd.read_excel('Name of the file.xlsx')

It didn't work.

Thanks!

Workflow

Datasets

Connectors

Accepted answers

1)Use the input tool to connect with your excel file normally

2)Connect the input tool with the python tool

3)Import the data from Alteryx to Python with Alteryx.read("#1")

1)Use the input tool to connect with your excel file normally

2)Connect the input tool with the python tool

3)Import the data from Alteryx to Python with Alteryx.read("#1")

@Felipe_Ribeir0 amazing, thank you!!!! :-)

i did the same but i am getting empty record, however there are content present in the excel