I'm looking for a way to link massive amounts of data in OpenOffice for a sim league I'm in. Here's an example of what I'm trying to link to my spreadsheet.
http://rslsim.atspace.com/html/players/player1stats.htm
You see player1stat. There are roughly 600 players though, and linking everyone separately would be way to tedious. The only thing that changes in the link is the player number for example:
http://rslsim.atspace.com/html/players/player1stats.htm
http://rslsim.atspace.com/html/players/player2stats.htm
....
http://rslsim.atspace.com/html/players/player600stats.htm
etc etc

I want to import all of them into a spreadsheet. What's the most efficient way to do this? Another program? Another way? Please help.

Probably a better way, but you can write a little application to download these pages for you, and save the information in a comma delimited format that you want, then import them into your document.

Each player seems to have an uniquely assigned ID number, and a webpage with their stats located at http://rslsim.atspace.com/html/players/playerID.htm
Just write your app to snatch all of these pages you are interested in.

Only problem I would see is that when the information changes on the website, you'll have to re-download the data, and not sure what else you will have to do (depending on what your doing).

This post was edited by Azrad on Jul 23 2013 04:41am

open data.csv

you can alter (1..600) to specify user range you want to get

This post was edited by nuvo on Jul 23 2013 05:07am

Is this for excel? I only have open office.

you can open .csv in openoffice just fine

just need to generate the file with ruby, code is above :^

(needs gem mechanize: gem install mechanize)

Need a better solution that ruby shit never worked.

Yeah I don't know about the details of that command, but the basic idea is right at the very least. Write a script to download the data and store it, then get it into excel anyway you want.

This post was edited by Azrad on Aug 3 2013 11:00pm

No idea how to do that lol

i recommend octave

wouldnt know how to use it lol