Read excel file google

Learn more. Read excel file from google drive without downloading file Ask Question. Asked 1 year ago. Active 1 year ago. Viewed 4k times. Improve this question. Scott Craner k 9 9 gold badges 43 43 silver badges 74 74 bronze badges. And you want to do this "without downloading Python"? Or what does the title mean? Edit: Nevermind I'm brain afk - you just but the python there to say "in Python" — fahrradflucht.

Add a comment. Active Oldest Votes. I believe your goal and situation as follows. You want to achieve this without saving the downloaded XLSX data as a file.

In this case, I would like to propose the following flow. In this case, it directly requests to the endpoint for exporting Spreadsheet as XLSX format using requests library. The downloaded XLSX data is read with pd. In this case, BytesIO is used for reading the data. GetContentFile 'exported. Improve this answer. Bob Smith Bob Smith Since you're already uploading to Google Drive and converting to a Sheet then you could skip the step of uploading it again and access it from Colab simply as a Sheet as seen in this solution: stackoverflow.

Zilong Z Zilong Z 6 6 silver badges 10 10 bronze badges. BytesIO uploaded. 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 Making Agile work for data science. Stack Gives Back Featured on Meta. Libre Spreadsheet. Office Excel. Google Sheet. Zoho Sheet. Open Office Calc Sheet. Best Excel Spreadsheet Reader for Windows 10, 8, 7. Size : 1. Trial Limitations. System Specifications. Hard Disk Space 10 MB of free hard disk space required. Product Guides. Application Pre-Requisites.

If you are using Windows 8. NET framework 4. Supported Editions. Does this Excel data Reader software have any hidden cost? Is it possible to view severely corrupt Excel files with their original contents?