Google多功能ImportXMLfails

Question

我有一个谷歌单子，我想刮几个股票价格，在给定的例子中有5个股票价格，所有5个importXML查询都工作，只是不同时工作，而那些不工作的只是一个"-“返回，但实际上没有一个没有工作的系统，在它们之间实际上都工作5。我想这是因为google工作表不能同时处理所有5个查询。

importXML看起来如下所示：

=IMPORTXML(" efGqYn排版__StyledTypography sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1 dqlo5q-2 emzYuD‘]) =IMPORTXML(" efGqYn排版__StyledTypography sc-10mju41-1 dKBtpx StatsBox_StyledPriceText-sc-1dqlo5q-2 emzYuD’]) =IMPORTXML(" efGqYn排版__StyledTypography sc-10mju41-1 dKBtpx StyledPriceText‘emzYuD])) =IMPORTXML(" efGqYn排版__StyledTypography sc-10 mju41-1 dKBtpx StatsBox_StyledPriceText-sc-1 dqlo5q-2 emzYuD‘)“)

有人有办法解决这个问题吗？

Answer 1

尝试：

=INDEX({
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16712858-goodfood-market";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16100472-studsvik";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\ 
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16874165-kahoot";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16886100-flexion-mobile";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\ 
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16290321-kambi-group";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")})

或者只是一排：

=INDEX({
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16712858-goodfood-market";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16100472-studsvik";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\ 
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16874165-kahoot";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16886100-flexion-mobile";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")\ 
 IMPORTXML("https://www.nordnet.dk/markedet/aktiekurser/16290321-kambi-group";
 "//span[@class='Typography__Span-sc-10mju41-0 efGqYn Typography__StyledTypography-sc-10mju41-1 dKBtpx StatsBox__StyledPriceText-sc-1dqlo5q-2 emzYuD']")}; 1)

​

​