google spreadsheet - How Can I Use ImportHTML to Fetch My Modem's Stats Webpage? -

problem

I try to use Google Sheets function to draw statistics from the hints of my modem The page shows something like this:

  = IMPORTHTML ("http://192.168.100.1/cmSignal.htm", "table", 4)  < / Pre> 
 is simple enough, but the function returns only the  error: the URL "http://192.168.100.1/cmSignal.htm"  can not return, something like that SE has seen degrees to different degrees SE 
 
 Doubt 
 
 Although I have explicitly said that the documentation has not been enabled, it seems that the function in Google Sheets is "remotely", as the sheet Is stored or processed at the end of Google, it effectively means that I can not use the function to drag data from a local website, such as the modem address, because an external machine for my LAN Do not know that Where is "192.168.100.1" 
 
 I think it is possible to install some sort of forwarding, but I am definitely unsure if the import supports HTML custom ports. 
 
 Questions and Needs 
 
  Question:  Is it possible  without resorting to some external scripting method 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  Note:  I think maybe I have more than a million other ways to get the data, but I am particularly interested in this route. / P> 

You can do this in Powerhale.

I am using:

$ url = 'http://192.168.100.1/cmSignalData.htm' $ r = invitation-webRevenue $ url. Get-WebRequestTable.ps1 $ r -TableNumber 3

Returns:

  Signal stats (Cowdwarts) bonding channel value ------- ------------------ -------------------- Channel ID 54 Total Unauthorized CodeWords 5117105038 Total Processed Codewords 26 Total Uncorrectable Codewords 1643  

And try to use different table numbers to scrape the data that you want.

Just call the call - grab the Webrequest script. / P>