var pastdataXml;

window.tws = window.tws || {};
window.tws.toLoad = window.tws.toLoad || [];
window.tws.toLoad.push('loadXml');

window.tws.loadXml = function() {

	var onloadXml = function( XML ) {
		pastdataXml = XML;
		var workSheetNames = getWorkSheets(pastdataXml);
		
		for(var sheet=0; sheet<getWorkSheets(pastdataXml).length;sheet++){
			var sheetName = getWorkSheets(pastdataXml)[sheet];
		}
		
		//buildYearlyTimeline(searchFrom);
		buildPastdataTable();
	};
	
	
	
	var buildPastdataTable = function() {
		
		var html = '';
		var line = 'odd';
		var className = '';
		var sheet = 0;
		
		var sheetName = getWorkSheets(pastdataXml)[sheet];
		var wsObj = getWorkSheet(pastdataXml,sheetName);
		var w = getWorkSheetColCount(wsObj);
		var h = getWorkSheetRowCount(wsObj);

		
		html += '<table>';
		for(var j=0; j<h; j++){
		
			if(j%2==0){
					line = 'even';
					className = '';
				}
			else{
					line = 'odd';
					className = ' class="white"';
			}
			
			html+='<tr>';
			if(j==0){
				for(var i=0; i<w;i++){
					value = getCellData(pastdataXml,sheetName,i,j);
					html += '<th class="tbody">'+ value +'</th>';
				}
			}
			else{
				for(var i=0; i<w;i++){
					value = getCellData(pastdataXml,sheetName,i,j).split('.')[0];
					if(i==0){
						html += '<th'+className+'>'+value+'</th>';
					}
					else{
						html += '<td'+className+'>'+value+'</td>';
					}
				}
			}
			html +='</tr>';
		}
		html +'</table>';

		$(targetId).set('html', html);
	
	};
    new Request({
        url: filename,
        method: 'get',
        onComplete: function(){onloadXml(this.response.xml)}
    }).send();

};