Forum Discussion
Solved
The pandas code read_excel() does not work in Python/Excel, unlike in native Python.
I have an issue when I try to read a specific workbook in Excel using pandas read_excel() The following code was tested natively and it worked: import pandas as pd pth = "C:/Users/XXXX/Python 1...
That's data security, more details in related post.
I don't think that's a big issue. You may Power Query external file (or any other source) and do nothing with it, just save as connection only. Next on Python
df=xl("MyConnectionName")
and do all transformations with Python.
That's à nice advice, thanks. I haven't thought about it from that angle. Let me try it.
It works. Some initial transformation in Power Query could be useful, e.g. "Use first row as header" if you load from csv or unstructured sheet.
- I tried it and it works, indeed.
Sometimes, the behaviour of the dataframe in an Excel sheet is quite unstable, showing the full data where the Python object is expected but I assume it is due to the beta environment.
Thank you very much for your help and support.Jeanbar99 , you are welcome