Import RESTRICTED data from Google Sheets Part 2/2
HTML-код
- Опубликовано: 9 дек 2024
- See various methods to import data from Google Sheets here: excelmacrofun....
In the previous video we saw a method to import RESTRICTED data from Google Sheets in Excel using VBA macros. The method consists of creating our own Google script API and then sending a HTTP request from Excel to get the data. In this video we see how to read the response to write the data to a range in Excel. We can loop through the JSON response to extract the data using basic VBA functions. We can also update the code to get the response as HTML so that we can use the native Excel library to easily read the HTML table.
Find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners and Excel VBA Objects Guide for Intermediate) in the blog spot: excelmacroclas...
And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun....)
Excel Macro Business (excelmacrobusi...)
Excel Macro Sports (excelmacrospor...)
Hello and thank you for the method explanation. How to import data to a specific range on a specific worksheet? And another question: is it possible to export data in the reverse direction from excel table to a restricted google sheet via the same method?
Check this other video to see how to import specific cells from specific sheet too. The sheet of a Google spreadsheet has a unique gid parameter in the URL.
ruclips.net/video/c841qBQAhUM/видео.htmlsi=hLjtVQKfviWRsJem
To export data from Excel to Google Sheets (via Google Form) check this other video:
ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=CSYoTUl6OKjdmbFq
Sir, how can import multiple sheets data... In excel ...please
You need to target each sheet with the respective gid. The URL for the Google spreadsheet looks as follows, and the gid is specific of each sheet.
docs.google.com/spreadsheets/d/1WopmB1ExWSNul9sw9n7I9FEyquS4AyEugt_fKQrHJSI/view#gid=2009384141
How do I call the data to specific worksheet and cells?
That's explained in this other video: ruclips.net/video/c841qBQAhUM/видео.htmlsi=sRrkpMiGkibYNbEv
how to export data from excel to Google Sheets using VBA macros?
That's covered in this other video: Export Data To Google Sheets: ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=rgIT3fSjxUqJlLmO
How to import data from restricted google sheet without access
You cannot import data if you don't have access to the restricted google spreadsheet.