Spreadsheet Import Example

None

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();

Name	Type	Description
SpreadsheetImport	spreadsheet
GenerateGraphURL	beanshell	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();
Get_Image_From_URL	localworker	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;
Beanshell	beanshell	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;

Name	Description	Inputs	Outputs
GenerateGraphURL		title data headers years	graphURL
Beanshell		year electricity fish_farming public_water_supply	data headers years

Source	Sink
SpreadsheetFile	SpreadsheetImport:fileurl
Beanshell:data	GenerateGraphURL:data
Beanshell:headers	GenerateGraphURL:headers
Beanshell:years	GenerateGraphURL:years
GenerateGraphURL:graphURL	Get_Image_From_URL:url
SpreadsheetImport:year	Beanshell:year
SpreadsheetImport:electricity	Beanshell:electricity
SpreadsheetImport:fish_farming	Beanshell:fish_farming
SpreadsheetImport:public_water_supply	Beanshell:public_water_supply
Get_Image_From_URL:image	graph

Spreadsheet Import Example

Preview

Run

Run this Workflow in the Taverna Workbench...

Workflow Components

Script

Script

Script

Reviews (0)

Comments (0)

Other workflows that use similar services (0)