有没有办法importhtml表并跳过重复的列标题?

我正在尝试从ESPN导入表格式的数据,但是该表在整个表中重复标题,如果可能的话,我想跳过它们。

http://www.espn.com/nhl/statistics/team/_/stat/scoring/year/2019/seasontype/2

我希望它仅在最顶部一次导入该行,而不再重复!这可能吗?

RK  TEAM    GP  G   GA  GF/G    GA/G    DIFF    SF/G    SA/G    DIFF    SVPCT   PIM PIMA    DIFF
zzp0706034135 回答:有没有办法importhtml表并跳过重复的列标题?

尝试:

=UNIQUE(IMPORTHTML("http://www.espn.com/nhl/statistics/team/_/stat/scoring/year/2019/seasontype/2","table",1))

0

本文链接:https://www.f2er.com/3164401.html

大家都在问