Spreadsheet Import Example

Script

StringBuilder sb = new StringBuilder();

sb.append("http://chart.apis.google.com/chart?");

sb.append("cht=bvg");
sb.append("&chs=1000x300");
sb.append("&ch=");
sb.append("&chxt=x,y,y");
sb.append("&chbh=5,1,5");
sb.append("&chxr=0,");
sb.append(Float.parseFloat(years.get(0)).intValue());
sb.append(",");
sb.append(Float.parseFloat(years.get(years.size() - 1)).intValue());
sb.append(",2|1,0,20");
sb.append("&chds=0,20");
sb.append("&chxl=2:|1000%20megalitres%2fday");
sb.append("&chxp=2,50");
sb.append("&chco=FF0000,00FF00,0000FF");
sb.append("&chdl=");

for (int i = 0; i < headers.size(); i++) {
    sb.append(headers.get(i).replace(" ", "%20"));
    if (i+1 < data.size()) {
      sb.append("|");
    }
}

if (title != void) {
  sb.append("&chtt=");
  sb.append(type);
}
if (data != void) {
  sb.append("&chd=t:");
  for (int i = 0; i < data.size(); i++) {
    List data1 = (List) data.get(i);
    for (int j = 0; j < data1.size(); j++) {
      Float value = Float.parseFloat(data1.get(j));
      sb.append(value.intValue());
      if (j+1 < data1.size()) {
        sb.append(",");
      }
    }
    if (i+1 < data.size()) {
      sb.append("|");
    }
  }
}


graphURL = sb.toString();

Script

URL inputURL = null;
if (base != void) {
	inputURL = new URL(new URL(base), url);
} else {
	inputURL = new URL(url);
}

byte[] contents;
if (inputURL.openConnection().getContentLength() == -1) {
	// Content size unknown, must read first...
	byte[] buffer = new byte[1024];
	int bytesRead = 0;
	int totalBytesRead = 0;
	InputStream is = inputURL.openStream();
	while (bytesRead != -1) {
		totalBytesRead += bytesRead;
		bytesRead = is.read(buffer, 0, 1024);
	}
	contents = new byte[totalBytesRead];
} else {
	contents = new byte[inputURL.openConnection().getContentLength()];
}
int bytesRead = 0;
int totalBytesRead = 0;
InputStream is = inputURL.openStream();
while (bytesRead != -1) {
	bytesRead = is.read(contents, totalBytesRead, contents.length - totalBytesRead);
	totalBytesRead += bytesRead;
	if (contents.length==totalBytesRead) break;
}

image = contents;

Script

data = new ArrayList();
headers = new ArrayList();

headers.add(electricity.remove(0));
headers.add(fish_farming.remove(0));
headers.add(public_water_supply.remove(0));

data.add(electricity);
data.add(fish_farming);
data.add(public_water_supply);

year.remove(0);
years = year;

Value