ガントチャート

<?xml version="1.0" encoding="UTF-8" ?>

<Module>

<ModulePrefs title="sample1" />

<Content type="html">

<![CDATA[

<script type="text/javascript" src="https://www.google.com/jsapi?autoload={'modules':[{'name':'visualization',

       'version':'1','packages':['timeline']}]}"></script>

<script type="text/javascript">

google.setOnLoadCallback(initialize);

//初期化

function initialize() {    

var query = new google.visualization.Query('https://docs.google.com/spreadsheet/pub?key=0AjN10lCzkUqkdHJqaUxkaUdyOUR3VGQwM3VHWTdWcGc&single=true&gid=8');

query.send(handleQueryResponse);

}

function handleQueryResponse(response) {

  //レスポンスデータを受け取る

  var data = response.getDataTable();

//行の数を取得する

  var numRows = response.getDataTable().getNumberOfRows();

  var dataTable = new google.visualization.DataTable();

  dataTable.addColumn({ type: 'string', id: 'Name' });

  dataTable.addColumn({ type: 'string', id: 'Job' });

  dataTable.addColumn({ type: 'date', id: 'Start' });

  dataTable.addColumn({ type: 'date', id: 'End' });

  for(i=0;i<numRows;i++){

   }

//チャートを描画する

}

</script>

<div id="schedule" style="width: 900px; height: 500px;"></div>

]]>

</Content>

</Module>