Forum Discussion
The pandas code read_excel() does not work in Python/Excel, unlike in native Python.
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.
Very helpful , thank you so much! The screenshot above is so useful.
Shouldn't Excel say in the Initialization page (with the list of libraries) that pd.read_excel/pd.read_csv is disabled?
Excel goes through the trouble of pre-installing Pandas , and then disables the most important feature without saying anything?
CoPilot was not helpful either, it didn't say that read_excel is disabled.
Thanks for your reply. It is unfortunate. Do you know the reason why ?
Python is easier (more flexible) than Power Query for ETL (from my point of view).
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.
In my case it is a big issue) Power Query doesn't see difference between hidden and unhidden rows in excel files, however pandas.read_excel can do that. And I hoped that introducing Pandas in Excel would enable this functionality.
