Read excel file with Python notebooks

[rafatomillero]

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!

[Felipe_Ribeir0 · Accepted solution]

Hi @rafatomillero 

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")

[rafatomillero]

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

[Devansh_Srivastava]

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