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...)

Комментарии • 10

  • @SndOfMzk
    @SndOfMzk 8 месяцев назад

    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?

    • @ExcelMacroMania
      @ExcelMacroMania  8 месяцев назад

      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

  • @pinkygamit9139
    @pinkygamit9139 9 месяцев назад +1

    Sir, how can import multiple sheets data... In excel ...please

    • @ExcelMacroMania
      @ExcelMacroMania  9 месяцев назад

      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

  • @alvinxunjieang7356
    @alvinxunjieang7356 8 месяцев назад

    How do I call the data to specific worksheet and cells?

    • @ExcelMacroMania
      @ExcelMacroMania  8 месяцев назад

      That's explained in this other video: ruclips.net/video/c841qBQAhUM/видео.htmlsi=sRrkpMiGkibYNbEv

  • @rochmadgrendhasonmaratno2365
    @rochmadgrendhasonmaratno2365 10 месяцев назад

    how to export data from excel to Google Sheets using VBA macros?

    • @ExcelMacroMania
      @ExcelMacroMania  10 месяцев назад

      That's covered in this other video: Export Data To Google Sheets: ruclips.net/video/bebQ-Rws0rs/видео.htmlsi=rgIT3fSjxUqJlLmO

  • @profoundveda3584
    @profoundveda3584 3 месяца назад

    How to import data from restricted google sheet without access

    • @ExcelMacroMania
      @ExcelMacroMania  3 месяца назад

      You cannot import data if you don't have access to the restricted google spreadsheet.