Got a question for you MFL experts...
We did a startup on MFL a few years ago, and I was trying to export the draft results to a text/word file. I was looking to back up the startup results onto our league’s proboard site.
Any suggestions? Not looking to manually type everything out. And copy/paste is a real mess as well. Didn’t know if there was an easy alternative.
Thanks guys.
MFL Draft Report Exporting To Text?
-
slaughterrt
- Hall of Fame
- Posts: 4537
- Joined: Tue Mar 05, 2013 5:11 pm
Re: MFL Draft Report Exporting To Text?
http://www64.myfantasyleague.com/2018/s ... port+draft
Answer: It's easy to get data from your MyFantasyLeague.com league into Excel following these steps.
1. Go to the web page you'd like to import, and then choose the This Page > Printer Friendly Page menu option. It's important to go to the printer friendly version of the page, and not the full page, to prevent Excel from being confused about the extraneous data on the page.
2. Copy (Control-C) the full web site address (URL) from that web page.
3. From Excel, go to "Data > Import External Data > New Web Query..." or "Data > Get External Data > From Web" option. The actual name of the option depends on what version of Excel you're running.
4. From inside the Excel pop-up window, paste (Control-V) the URL/web page address of the web page you'd like to import.
5. Click on the arrow next to the table in this report that you'd like to import.
6. Click on the import button and voila, your spreadsheet is populated.
The best part about this is that any time you want to refresh the data from the site into your spreadsheet, you only have to click on the "Data > Refresh Data" (or, "Refresh All", depending on your Excel version) option, and your spreadsheet is updated - far easier than either copy/paste or even importing a text file.
For more detailed tips on how this works, please consult Excel's on-line help documentation, available from Excel's Help Menu, or this google search.
----
Not sure if that is what you want.
Answer: It's easy to get data from your MyFantasyLeague.com league into Excel following these steps.
1. Go to the web page you'd like to import, and then choose the This Page > Printer Friendly Page menu option. It's important to go to the printer friendly version of the page, and not the full page, to prevent Excel from being confused about the extraneous data on the page.
2. Copy (Control-C) the full web site address (URL) from that web page.
3. From Excel, go to "Data > Import External Data > New Web Query..." or "Data > Get External Data > From Web" option. The actual name of the option depends on what version of Excel you're running.
4. From inside the Excel pop-up window, paste (Control-V) the URL/web page address of the web page you'd like to import.
5. Click on the arrow next to the table in this report that you'd like to import.
6. Click on the import button and voila, your spreadsheet is populated.
The best part about this is that any time you want to refresh the data from the site into your spreadsheet, you only have to click on the "Data > Refresh Data" (or, "Refresh All", depending on your Excel version) option, and your spreadsheet is updated - far easier than either copy/paste or even importing a text file.
For more detailed tips on how this works, please consult Excel's on-line help documentation, available from Excel's Help Menu, or this google search.
----
Not sure if that is what you want.
Please speak to clarion contrarion before considering the use of vetos..
-
slaughterrt
- Hall of Fame
- Posts: 4537
- Joined: Tue Mar 05, 2013 5:11 pm
Re: MFL Draft Report Exporting To Text?
Very cool. Did not know that was an option but I’m gonna have to give it a try,
Thanks
Thanks