无法在Google电子表格中提取HTML数据 [英] HTML data not pulling out in google spreadsheet

问题描述

我试图从NSE网站的Google电子表格中提取HTML数据，但是脚本符号中包含&"不会退出，但是其他不包含字符&"的普通脚本可以轻松拔出.

I have tried to pull out HTML data from NSE website in my google spreadsheet, but script symbol containing "&" is not getting pulled out but other normal scripts which does not include character "&" can be easily pulled out.

我正在使用以下公式:

=importhtml("https://www.nseindia.com/marketinfo/sym_map/symbolMapping.jsp?symbol="&B1&"&instrument=OPTSTK&date=-&segmentLink=17","table",3)

其中B1 = M& M，它是印度股市脚本符号(数据未提取)试试B1 = ACC(数据将被拉出)

where B1=M&M which is Indian stock market script symbol (data not pulled out) try B1=ACC (data will be pulled out)

如果在下面的链接中输入了相同的符号(M& M)，则数据将出现在网页中.

if in below link same symbol(M&M) is entered then data will be there in web page.

https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp

任何帮助都将由thanx来表达.

Any help will be appriciated by word of thanx.

推荐答案

尝试将股票行情收录器包装在ENCODEURL函数中.它为我加载了数据.

Try wrapping the stock ticker in an ENCODEURL function. It loaded the data for me.

=importhtml("https://www.nseindia.com/marketinfo/sym_map/symbolMapping.jsp?symbol="& ENCODEURL("M&M") &"&instrument=OPTSTK&date=-&segmentLink=17","table", 3)

这篇关于无法在Google电子表格中提取HTML数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！