Box python sdk download excel file

Learn more. Using Python to download files from Box Ask Question. Asked 5 years, 4 months ago. Active 2 years, 4 months ago. Viewed 3k times. I'm trying to use Python to download an Excel file to my local drive from Box. Using the boxsdk I was able to authenticate via OAuth2 and successfully get the file id on Box. Improve this question. Clerin Clerin 96 1 1 silver badge 4 4 bronze badges.

You are most of the way there. What's left should be easier than what you've already done. Check out Python's open built-in function. Thanks John Y, that worked! I used the open function with the arguments 'wb' for mode and 1 for buffer. As long as I had already created a blank excel file in the local drive then it wrote the downloaded data into the excel sheet including separating it into different tabs.

Excel wasn't happy when I tried to open the excel file manually, but as long as I used the close function first then it was possible to open the excel tabs as dataframes in Python using pandas. Thanks again! Add a comment. Fedalto Fedalto 1, 9 9 silver badges 13 13 bronze badges. This would save the excel file in the same folder that the script was ran from. Sergey Shubin 2, 4 4 gold badges 22 22 silver badges 29 29 bronze badges.

I used your code and got error. I solved the problem by changing to urllib. This code works for me on python 3. BKay BKay 1, 13 13 silver badges 23 23 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast what if you could invest in your favorite developer?

Let's look at the User object. In [4]:. Now let's look at some different objects, like File and Folder. In [5]:. In [6]:. The SDK makes it very easy to download and upload files.

In [7]:. Upload a file to Box! In [8]:. Box Python SDK test! In [9]:.