Solution of : =IMPORTHTML() Errors : Could not fetch url

By Adel Chemi
While I'm Importing table from HTML with =Importhtml() built-in function (Formula) an web page I had error : Could not fetch url.







Here's a sample custom function to import any table from web page HTML.
Copy the code into the Tools > Script Editor.

The Code :


Sample :


Comments

  1. Jmorgie5/23/2019

    worked like a champ! thanks for sharing 5/2019

    ReplyDelete
  2. lucky9/02/2019

    not working showing
    DNS error: http://undefined (line 4, file "Code")Dismiss

    ReplyDelete
    Replies
    1. Adel Chemi9/02/2019

      Hi, Can you send me your code

      Delete
    2. Inder Patel1/17/2020

      Same problem plz help code is same which you peast

      Delete
  3. Inder Patel1/20/2020

    i want table from https://www1.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10006&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17
    please help me

    ReplyDelete

Post a Comment

Popular posts from this blog

Email a Custom Sheets as PDF in Attachment

By Adel Chemi
Image
Script export and send email of custom sheet on PDF in Attachment for Google Sheets with GAS (Google Apps Script) & Javascript Language, don't forget to change the variables according to your goal, read tips and watch video to understand more about how to run it even you are not a programmer
Read more

Export and Email Specific Range in Google Sheets in CSV,PDF or XLSX

By Adel Chemi
Image
Script for Exporting a specific Range from spreadsheet and save it in drive or email it in attachment in CSV, PDF or XLSX . If you want to export just specific sheets in the spreadsheet just check this  Tutorial  . How to use it : In Spreadsheet Menu Click Tools and select Script Editor from spinner to go put your script, in Excel "Visual Basic" on developer mode. 1- Open Google Apps Script file or create new one : File > New > Script File and name it with whatever you want . 2- Past the script in the bottom of Article and Save the Script . What necessary to change : Line 5 : Range you want to export it. Line 6: Sheet who has that range . LINE 59 : Email Receiver, if you want to email a multiple emails just make comma between each email address e.g : 'pace3man@gmail.com ,spider-max@live.fr,......'  . LINE 60 : replace Title word with whatever. LINE 61 : The body of Email. LINE 64 : The Attachment file name.
Read more