var Prog=json_State["prog"];
var json_State = JSON.parse(localStorage.getItem("State"))|| {"prog":"","onglet":"lab"}; 
var json_mois={"01":"Janvier", "02":"Février","03":"Mars","04":"Avril","05":"Mai","06":"Juin","07":"Juillet","08":"Août","09":"Septembre","10":"Octobre","11":"Novembre","12":"Décembre"}

function charge_XLS(){
	if(window.XMLHttpRequest) var oReq = new XMLHttpRequest();
	else if(window.ActiveXObject) oReq = new ActiveXObject('MSXML2.XMLHTTP.3.0');
	else throw 'XHR unavailable for your browser';
	
	oReq.open("GET", 'test.xlsx', true);
	oReq.responseType = 'arraybuffer';
	oReq.onreadystatechange = function (aEvt) {
		if (oReq.readyState == 4 && oReq.status == 200) {
			//Fichier Excel test.xlsx reçu et début traitement
			var data = new Uint8Array(oReq.response);
			var arr = new Array();
			for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
			var bstr = arr.join("");
			var workbook = XLSX.read(bstr, {type:"binary"});
			var sheet =workbook.Sheets["Users"];
			json=XLSX.utils.sheet_to_json(sheet)
			for(var i in json){
				if(json[i]["Login"].toUpperCase()==user().toUpperCase()){
					var html="<select id='prog_id' class='titre' style='border:none;width:150px'>"
					json[i]["Programme"].split("/").forEach(function(item){
						html+="<option value='"+ item +"'>"+item+"</option>";
					})
					html+="</select>"
					//$("#nom").html(json[i]["Programme"]);
					$("#programme").html(html);
					$("#prog_id").on("change", function(){init();save_conf()});
					$("#prog_id").val(Prog);
				}
			}
			
			var first_sheet_name = workbook.SheetNames[0];
			var sheet =workbook.Sheets[first_sheet_name];
			
			Actions=XLSX.utils.sheet_to_json(sheet);

	/* 		Va chercher les données dans l'onglet "Plannification350"" du fichier Excel  */			
			var sheet =workbook.Sheets["Plannification350"];
			Planif350=XLSX.utils.sheet_to_json(sheet);
			var o=[],p=[];
			Planif350.forEach(function(item){
				ma_date=getdate(item["Date"]);
				if(ma_date){if(ma_date<today){o.push(item)}else{p.push(item)}};
		
			  p.forEach(function(item){
			 $("#planning tbody").append("<tr><td>"+json_mois[item["Date"].split("/")[1]]	+ "</td><td>"+item["Date"]+ "</td><td>"+item["ATA"]+"</td> </tr>");
			}) 
 
			init();
		}
	};
	oReq.send();

}