5 Messages

Digest #3876

Trouble pulling a table from a webpage (?) by jpsartrean

Re: Trouble pulling a table from a webpage (?) by "Kermit W. Prather" kermitpra

Re: Trouble pulling a table from a webpage (?) by jpsartrean

Happy new year!!! Thank you for your continued support. by "Gaston Bullrich" gbullr

(no subject) by "Gaston Bullrich" gbullr

Messages

1a

Trouble pulling a table from a webpage (?)

Mon Jan 2, 2017 9:19 am (PST) . Posted by:

jpsartrean

Hello,

I've been trying to use the add in to pull a table from the following webpage:

http://rotoguru1.com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x

I'd like the entire table there of " Game-by-Game History of Prices and Points "

I'm able to do this in Google Sheets using the formula =IMPORTHTML("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","table",7), but have been unable to do the same in Excel using the add in, no matter what syntax I try with RCHGetHTMLTable or RCHGetTableCell.

Any thoughts? Thanks ever so much!!

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1b

Re: Trouble pulling a table from a webpage (?)

Mon Jan 2, 2017 10:14 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

This will need Randy to response as the data is not in the source for that page.
Unfortunately, more and more sites are going to using JSON to pull data rather than put it in the webpage source.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 02, 2017 12:19 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Trouble pulling a table from a webpage (?)

Hello,

I've been trying to use the add in to pull a table from the following webpage:

http://rotoguru1.com/cgi-bin/playrh.cgi?4102x

I'd like the entire table there of " Game-by-Game History of Prices and Points "

I'm able to do this in Google Sheets using the formula =IMPORTHTML("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","table",7), but have been unable to do the same in Excel using the add in, no matter what syntax I try with RCHGetHTMLTable or RCHGetTableCell.

Any thoughts? Thanks ever so much!!

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

1c

Re: Trouble pulling a table from a webpage (?)

Mon Jan 2, 2017 10:31 am (PST) . Posted by:

jpsartrean

Thanks for trying to help Kermit --- but I do believe the data I'm looking for is in the source page itself, no?

view-source:http://rotoguru1.com/cgi-bin/playrh.cgi?4102x

beginning around 49 at the left (?)

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2 Happy new year!!! Thank you for your continued support.

Mon Jan 2, 2017 12:20 pm (PST) . Posted by:

"Gaston Bullrich" gbullr

RchGetHTML Table error

Not getting anything back and this used to work great.

thoughts?

=rchgethtmltable("
http://www.investing.com/rates-bonds/world-government-bonds",E2)

E2 = Switzerland 1Y

Thank you .

--
Gaston Bullrich
9 Island Avenue Apt 1406
Miami Beach, Florida 33139
Cel. 917 517 9907