Jump to content

Pulling High Scores On Excel?


Kolin

Recommended Posts

Hey,

 

I had a relatively simple question really, I want to know how to program excel to automatically pull my character's experience in each skill from the Runescape high scores, and place the data on my spreadsheet so I can do some tracking/calculations.

 

I'm running Excel 2007.

 

Thanks :)

Link to comment
Share on other sites

First of all you need to setup the spread sheet, you need to format 41 cells in a column to type TEXT(

), we do this so that excel doesn't mess up the number formatting by adding extra ","'s, and this needs to be done before the data import.

 

For the first 27 cells you use the following three formulae.

=LEFT(A1, FIND(",", A1, 1) - 1)
=MID(A1, FIND(",", A1, 1) + 1, FIND(",", A1, FIND(",", A1, 1) + 1) - FIND(",", A1, 1) - 1)
=RIGHT(A1, LEN(A1) - FIND(",", A1, FIND(",", A1, 1) + 1 ))

 

For the next 14 cells you use these two:

=LEFT(A28, FIND(",", A28, 1) - 1)
=RIGHT(A28, LEN(A28) - FIND(",", A28, 1))

 

You will need to change the cell references.

 

Edit: I assumed you would be using the lite hiscores api:

http://hiscore.runescape.com/index_lite.ws?player=zezima

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.