15,043
edits
Extract title from webpage: Difference between revisions
Jump to navigation
Jump to search
m
→Troubleshooting of IMPORTXML errors
Tags: Mobile edit Mobile web edit |
Tags: Mobile edit Mobile web edit |
||
| Line 22: | Line 22: | ||
Error {{kbd | key=<nowiki>#N/A</nowiki>}} | Error {{kbd | key=<nowiki>#N/A</nowiki>}} | ||
* Error with Details: {{kbd | key=<nowiki>"Failed to fetch URL: https://www.xxx.com" </nowiki>}} | * Error with Details: {{kbd | key=<nowiki>"Failed to fetch URL: https://www.xxx.com" </nowiki>}} (<nowiki>無法擷取網址：https://www.xxx.com</nowiki>) | ||
* Root cause: This error indicated that the webpage might be blocking the crawler from accessing its content. | * Root cause: This error indicated that the webpage might be blocking the crawler from accessing its content. | ||
Error {{kbd | key=#ERROR!}} | Error {{kbd | key=#ERROR!}} | ||
* Error with Details: {{kbd | key=<nowiki>"Formula parse error"</nowiki>}} | * Error with Details: {{kbd | key=<nowiki>"Formula parse error"</nowiki>}} (公式剖析錯誤。) | ||
* Root cause: This issue typically arises when there's an error in the second parameter of the IMPORTXML function, for example, {{kbd | key=<nowiki>=IMPORTXML(A1, "/html/body/title")</nowiki>}}. It indicates that the XPath or query provided is incorrect or not formatted properly. Correct one is {{kbd | key=<nowiki>=IMPORTXML(A1, "/html/head/title")</nowiki>}}. | * Root cause: This issue typically arises when there's an error in the second parameter of the IMPORTXML function, for example, {{kbd | key=<nowiki>=IMPORTXML(A1, "/html/body/title")</nowiki>}}. It indicates that the XPath or query provided is incorrect or not formatted properly. Correct one is {{kbd | key=<nowiki>=IMPORTXML(A1, "/html/head/title")</nowiki>}}. | ||