Script Examples

Runescape Virtual High Scores (Personal) (With Script) - importCSVhighscore

function importCSVhighscore() { var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Virtual High Scores"); var cell = ss.getRange("Virtual High Scores!B1"); var cellValue = cell.getValue(); var rsurl = "http://services.runescape.com/m=hiscore/index_lite.ws?player="; // new link //var rsurl = "http://hiscore.runescape.com/index_lite.ws?player="; // old link var csvUrl = rsurl+cellValue; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Script"); var range = sheet.getRange("A1:C60"); range.clearContent(); var csvContent = UrlFetchApp.fetch(csvUrl).getContentText(); var csvData = Utilities.parseCsv(csvContent); var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Script"); sheet.getRange(4, 1, csvData.length, csvData[0].length).setValues(csvData); }

Runescape demo of Track Me PLUS (With Script) - trackme

Runescape demo of Inactive (With Scripts) - importCSVinactive

Runescape demo of clan ranks by xp (With Script) - importCSV

function importCSV() { // II XP II Coded var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Settings Manual Inputs"); // Select active sheet. var cell = ss.getRange("Settings Manual Inputs!D3"); //Get the clan name from cell D3 var cellValue = cell.getValue(); var rsurl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName="; // set up the url address with clan name. var csvUrl = rsurl+cellValue; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("rawdata"); // Clear out old downloaded clan data var range = sheet.getRange("F1:I501"); range.clearContent();
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText(); // call data from url in csv format var csvData = Utilities.parseCsv(csvContent); var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("rawdata"); // select rawdata sheet and get csv clan data pasted into cell F1 sheet.getRange(1, 6, csvData.length, csvData[0].length).setValues(csvData); // raw data tab is hidden, use veiw to unhide. }

Runescape demo of clan ranks by points PLUS (With Script) - importCSVpoints

function importCSVpoints() { // II XP II Coded var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Settings Manual Inputs"); // Select active sheet. var cell = ss.getRange("Settings Manual Inputs!D3"); //Get the clan name from cell D3 var cellValue = cell.getValue(); var rsurl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName="; // set up the url address with clan name. var csvUrl = rsurl+cellValue; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("rawdata"); // Clear out old downloaded clan data var range = sheet.getRange("F1:I501"); range.clearContent();
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText(); // call data from url in csv format var csvData = Utilities.parseCsv(csvContent); var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("rawdata"); // select rawdata sheet and get csv clan data pasted into cell A1 sheet.getRange(1, 6, csvData.length, csvData[0].length).setValues(csvData); // raw data tab is hidden, use veiw to unhide. }

Runescape demo of clan data recorder and tracker (With Script) - ClanData

Runescape demo of Citadel Capping scanner and tracker (With Scripts) - importCSVchanges

Import CSV script II XP II Rev3 - importCSVFromWeb - (To download your latest clan data)

function importCSVFromWeb() { // script name and start script open bracket { // II XP II script ("//" = reference comments beyond this point) var clanname = "Serenity Isle"; // Set Clan name as a variable var rsurl = "http://services.runescape.com/m=clan-hiscores/members_lite.ws?clanName="; // Set up URL address as a variable var csvUrl = rsurl+clanname; // set URL + Clan name as a variable var csvContent = UrlFetchApp.fetch(csvUrl).getContentText(); // Go collect Clan Data in CSV format (comma seperated vector) var csvData = Utilities.parseCsv(csvContent); // store data into variable csvData var ss = SpreadsheetApp.getActiveSpreadsheet(); // clear out previous downloaded data var sheet = ss.getSheets()[0]; // to prevent old data being left behind creating incorrect data var range = sheet.getRange("A1:D501"); // select cells range A1:D501 range.clearContent(); // clear out selected range var ss = SpreadsheetApp.getActiveSpreadsheet(); // Make the first tab sheet the active sheet ("Clandownload") ss.setActiveSheet(ss.getSheets()[0]); // sheet tabs start at zero var sheet = SpreadsheetApp.getActiveSheet(); // select active sheet and paste CSV clan data into cell A1 sheet.getRange(1, 1, csvData.length, csvData[0].length).setValues(csvData); // column 1 , row 1 } // end script