Google Sheets undoubtedly is one the most popular spreadsheet software in the industry today. Almost everyone who use Google have used Google Sheets at some point. In Microsoft Excel, there are VBA and Office for JavaScript API, but honestly, VBA is lacked the functionality of working with outside software, and Office for JavaScript… well it is JavaScript that’s all I can say.
Google Sheets API however, in my opinion, is one of the most versatile and powerful (stabled to since it is already on build v4) APIs when it comes to Google Suites Applications (Google Doc, Slides, GMAIL, etc). In this tutorial, I will show you a very powerful tip – how to import a Pandas DataFrame into a Google Spreadsheet using Google Sheets API.
Google.py
DF_To_GSheet.py
Hello Jie Jenn,
may you help me? The code works fine for me as long as I’m not in the corporate network. As soon as I’m in the corporate network, I have to get through the proxy. Unfortunately I don’t know how. Do you have any idea how I could do that? I tried the rebuild_proxies function, but I have no clue how to get it work.
Would be great if you could help me out on this topic. pleease =)
best regards
benni