6 Messages
Digest #3911
Messages
Sun Feb 5, 2017 6:09 pm (PST) . Posted by:
jpsartrean
Hello,
I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function (clicking on the arrow next to the table to import it).
I'm also able to do it with Google Sheets using the formula =IMPORTHTML("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","table",7) -- but I've been unable to automate the same with the add in in Excel, no matter what syntax I try... be it RCHGetHTMLTable, RCHGetTableCell, etc...
Any thoughts? Thanks ever so much!!
I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function (clicking on the arrow next to the table to import it).
I'm also able to do it with Google Sheets using the formula =IMPORTHTML("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","
Any thoughts? Thanks ever so much!!
Sun Feb 5, 2017 7:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This worked for me:
=RCHGetHTMLTable("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x
","Game-by-Game")
On Sun, Feb 5, 2017 at 7:09 PM, jpsartrean@
...wrote:
>
>
> I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function
> (clicking on the arrow next to the table to import it).
>
>
> I'm also able to do it with Google Sheets using the formula =IMPORTHTML("
> http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","table",7) -- but I've
> been unable to automate the same with the add in in Excel, no matter what
> syntax I try... be it RCHGetHTMLTable, RCHGetTableCell, etc...
>
>
> Any thoughts? Thanks ever so much!!
>
>
>
=RCHGetHTMLTable("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x
","Game-by-Game")
On Sun, Feb 5, 2017 at 7:09 PM, jpsartrean@
...wrote:
>
>
> I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function
> (clicking on the arrow next to the table to import it).
>
>
> I'm also able to do it with Google Sheets using the formula =IMPORTHTML("
> http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","
> been unable to automate the same with the add in in Excel, no matter what
> syntax I try... be it RCHGetHTMLTable, RCHGetTableCell, etc...
>
>
> Any thoughts? Thanks ever so much!!
>
>
>
Sun Feb 5, 2017 8:28 pm (PST) . Posted by:
jpsartrean
Hmm... tried similar syntax before and it didn't (and still doesn't) work.... your suggestion just returns "Game-by-Game History of Prices and Points" instead of the actual table... strange...
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
This worked for me:
=RCHGetHTMLTable("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","Game-by-Game")
On Sun, Feb 5, 2017 at 7:09 PM, jpsartrean@ ...wrote:
I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function (clicking on the arrow next to the table to import it).
I'm also able to do it with Google Sheets using the formula =IMPORTHTML("http://rotoguru1. com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x", "table",7) -- but I've been unable to automate the same with the add in in Excel, no matter what syntax I try... be it RCHGetHTMLTable, RCHGetTableCell, etc...
Any thoughts? Thanks ever so much!!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
This worked for me:
=RCHGetHTMLTable("http://rotoguru1.com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x","Game-by-Game")
On Sun, Feb 5, 2017 at 7:09 PM, jpsartrean@ ...wrote:
I've been trying to use the add in to automatically 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 using Excel's internal 'Get Data from Web' function (clicking on the arrow next to the table to import it).
I'm also able to do it with Google Sheets using the formula =IMPORTHTML("http://rotoguru1. com/cgi-bin/playrh.cgi?4102x http://rotoguru1.com/cgi-bin/playrh.cgi?4102x", "table"
Any thoughts? Thanks ever so much!!
Sun Feb 5, 2017 10:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to array-enter the formula over a range. Entering it into a single
cell just gets you the data from the first row and first column of the
table.
On Sun, Feb 5, 2017 at 9:28 PM, jpsartrean@
...
wrote:
>
> Hmm... tried similar syntax before and it didn't (and still doesn't)
> work.... your suggestion just returns "Game-by-Game History of Prices and
> Points" instead of the actual table... strange...
>
>
cell just gets you the data from the first row and first column of the
table.
On Sun, Feb 5, 2017 at 9:28 PM, jpsartrean@
...
wrote:
>
> Hmm... tried similar syntax before and it didn't (and still doesn't)
> work.... your suggestion just returns "Game-by-
> Points" instead of the actual table... strange...
>
>
Mon Feb 6, 2017 9:38 am (PST) . Posted by:
"RHo" frk1rxh
got it. thanks
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, February 6, 2017 1:54 AM
Subject: Re: [smf_addin] Importing table from this webpage?
You need to array-enter the formula over a range. Entering it into a single cell just gets you the data from the first row and first column of the table.
On Sun, Feb 5, 2017 at 9:28 PM, jpsartrean@... wrote:
| Hmm... tried similar syntax before and it didn't (and still doesn't) work.... your suggestion just returns "Game-by-Game History of Prices and Points" instead of the actual table... strange... |
#yiv4523761716 #yiv4523761716 -- #yiv4523761716ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4523761716 #yiv4523761716ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4523761716 #yiv4523761716ygrp-mkp #yiv4523761716hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4523761716 #yiv4523761716ygrp-mkp #yiv4523761716ads {margin-bottom:10px;}#yiv4523761716 #yiv4523761716ygrp-mkp .yiv4523761716ad {padding:0 0;}#yiv4523761716 #yiv4523761716ygrp-mkp .yiv4523761716ad p {margin:0;}#yiv4523761716 #yiv4523761716ygrp-mkp .yiv4523761716ad a {color:#0000ff;text-decoration:none;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ygrp-lc {font-family:Arial;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ygrp-lc #yiv4523761716hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ygrp-lc .yiv4523761716ad {margin-bottom:10px;padding:0 0;}#yiv4523761716 #yiv4523761716actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4523761716 #yiv4523761716activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4523761716 #yiv4523761716activity span {font-weight:700;}#yiv4523761716 #yiv4523761716activity span:first-child {text-transform:uppercase;}#yiv4523761716 #yiv4523761716activity span a {color:#5085b6;text-decoration:none;}#yiv4523761716 #yiv4523761716activity span span {color:#ff7900;}#yiv4523761716 #yiv4523761716activity span .yiv4523761716underline {text-decoration:underline;}#yiv4523761716 .yiv4523761716attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4523761716 .yiv4523761716attach div a {text-decoration:none;}#yiv4523761716 .yiv4523761716attach img {border:none;padding-right:5px;}#yiv4523761716 .yiv4523761716attach label {display:block;margin-bottom:5px;}#yiv4523761716 .yiv4523761716attach label a {text-decoration:none;}#yiv4523761716 blockquote {margin:0 0 0 4px;}#yiv4523761716 .yiv4523761716bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4523761716 .yiv4523761716bold a {text-decoration:none;}#yiv4523761716 dd.yiv4523761716last p a {font-family:Verdana;font-weight:700;}#yiv4523761716 dd.yiv4523761716last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4523761716 dd.yiv4523761716last p span.yiv4523761716yshortcuts {margin-right:0;}#yiv4523761716 div.yiv4523761716attach-table div div a {text-decoration:none;}#yiv4523761716 div.yiv4523761716attach-table {width:400px;}#yiv4523761716 div.yiv4523761716file-title a, #yiv4523761716 div.yiv4523761716file-title a:active, #yiv4523761716 div.yiv4523761716file-title a:hover, #yiv4523761716 div.yiv4523761716file-title a:visited {text-decoration:none;}#yiv4523761716 div.yiv4523761716photo-title a, #yiv4523761716 div.yiv4523761716photo-title a:active, #yiv4523761716 div.yiv4523761716photo-title a:hover, #yiv4523761716 div.yiv4523761716photo-title a:visited {text-decoration:none;}#yiv4523761716 div#yiv4523761716ygrp-mlmsg #yiv4523761716ygrp-msg p a span.yiv4523761716yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4523761716 .yiv4523761716green {color:#628c2a;}#yiv4523761716 .yiv4523761716MsoNormal {margin:0 0 0 0;}#yiv4523761716 o {font-size:0;}#yiv4523761716 #yiv4523761716photos div {float:left;width:72px;}#yiv4523761716 #yiv4523761716photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4523761716 #yiv4523761716photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4523761716 #yiv4523761716reco-category {font-size:77%;}#yiv4523761716 #yiv4523761716reco-desc {font-size:77%;}#yiv4523761716 .yiv4523761716replbq {margin:4px;}#yiv4523761716 #yiv4523761716ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4523761716 #yiv4523761716ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4523761716 #yiv4523761716ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4523761716 #yiv4523761716ygrp-mlmsg select, #yiv4523761716 input, #yiv4523761716 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4523761716 #yiv4523761716ygrp-mlmsg pre, #yiv4523761716 code {font:115% monospace;}#yiv4523761716 #yiv4523761716ygrp-mlmsg * {line-height:1.22em;}#yiv4523761716 #yiv4523761716ygrp-mlmsg #yiv4523761716logo {padding-bottom:10px;}#yiv4523761716 #yiv4523761716ygrp-msg p a {font-family:Verdana;}#yiv4523761716 #yiv4523761716ygrp-msg p#yiv4523761716attach-count span {color:#1E66AE;font-weight:700;}#yiv4523761716 #yiv4523761716ygrp-reco #yiv4523761716reco-head {color:#ff7900;font-weight:700;}#yiv4523761716 #yiv4523761716ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ov li a {font-size:130%;text-decoration:none;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4523761716 #yiv4523761716ygrp-sponsor #yiv4523761716ov ul {margin:0;padding:0 0 0 8px;}#yiv4523761716 #yiv4523761716ygrp-text {font-family:Georgia;}#yiv4523761716 #yiv4523761716ygrp-text p {margin:0 0 1em 0;}#yiv4523761716 #yiv4523761716ygrp-text tt {font-size:120%;}#yiv4523761716 #yiv4523761716ygrp-vital ul li:last-child {border-right:none !important;}#yiv4523761716
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Monday, February 6, 2017 1:54 AM
Subject: Re: [smf_addin] Importing table from this webpage?
You need to array-enter the formula over a range. Entering it into a single cell just gets you the data from the first row and first column of the table.
On Sun, Feb 5, 2017 at 9:28 PM, jpsartrean@... wrote:
| Hmm... tried similar syntax before and it didn't (and still doesn't) work.... your suggestion just returns "Game-by-
#yiv4523761716 #yiv4523761716 -- #yiv4523761716ygrp-
Mon Feb 6, 2017 2:57 pm (PST) . Posted by:
rharmelink
Here:
http://finance.yahoo.com/screener/new http://finance.yahoo.com/screener/new
http://finance.yahoo.com/screener/new http://finance.yahoo.com/screener/new
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar