Reading excel data

[ssw9UZNL]

Hello I have a series of excel sheets that I want to read data from.

I have previously used pandas but I assume that is more graphical and used in Jupiter notebook etc.

is there a good way to read excels so I can. Manipulate them in the console?

at the moment I am just using grasshopper plug ins to read it with rhino inside- but I would prefer to keep my code on python only.

Thankyou 

[jeremy_tammik]

Since this has nothing whatsoever to do with the Revit API per see, I would suggest searching for a solution in a Python-oriented forum instead. Please also always searching for existing answers before raising a new question. I am certain this one has been answered already very often in the past. Actually, I can prove it; just perform a quick search on StackOverflow and GitHub:

• https://stackoverflow.com/search?q=%5Bpython%5D+%5Bexcel%5D+import
• https://github.com/search?q=python+excel+import

[ssw9UZNL]

Hello,

I have read that pandas does not work IronPython (I am working with python to get into the API) so this is why I wanted to ask here as it was API specific.

I would love to know what libaries people here use that work with the API.

Thankyou

[Yien_Chao]

just here :  https://dynamobim.org/why-has-dynamo-switched-to-python-3-should-i-update-too/

"In addition, this means it is now possible for Dynamo graphs to benefit from Python libraries that include native extensions that were not accessible in IronPython, such as NumPy, SciPy, and Pandas."