I’ve followed a few online tutorials that walk you through the basics, so I’ve got an idea of how Python in Excel works, but I’d really like to view the full documentation/reference for it. Like, what all is the xl() method capable of? Are there other methods?
All I can find online are beginner tutorials, or guides/tutorials to completing specific tasks, so I’m not able to find a comprehensive breakdown. Any help would be greatly apprectiated.
Hi and welcome!
There is no documentation for the xl method that I have found. However, you can use help(excel) to view the contents of the excel module and explore further from there.
With regards to the xl method, there are only two arguments that matter - the reference and the headers.
You can change the output behavior of the xl method. I’ve described it in this video:
If you have any further questions, I’ll be happy to help.
Owen
You’re amazing! Your video helped a ton, because I was not aware of the help() method.
excel package?? I didn’t even know it existed.I imagine there’s no documentation because it’s part of the integration and not open-source software, but I’m not on the MSFT Product team so that is only a guess.
help() is a standard feature of Python in any environment.
The excel package is listed in the ‘Initialization’ pane. I just explored it from there. It took a little playing around 