Display part of information loaded with importxml function in Google SpreadSheet -

how display part of information loaded importxml function in google spreadsheet.

hello

here forumula inserted in a1 : =importxml("http://www.goldforex.be/servlet/javaparser?pgm=lst_or_new&lg=fr","//tr[@valign='top']")

if test formula return numerous informations...i know how display information available row 26 row 57 in columns & b.

thanks in advance help,

very best regards,

seb

you can use query function strip down data required.

=query(importxml("http://www.goldforex.be/servlet/javaparser?pgm=lst_or_new&lg=fr","//tr[@valign='top']");"select col1, col2 limit 31 label col1 '', col2 ''";26)

the page query spreadsheet function has disappeared in recent times. basic explanation when searching query in function list. select clause uses gviz query language api, although article not definitive when comes ou can , cannot use in spreadsheet function select clause.