'''
Created on 30 avr. 2014

@author: thibaut.feret
'''
import glob
import os
import datetime
import xlrd

def listdirectory(path):  
    fichier=[]  
    l = glob.glob(path+'\\*')  
    for i in l:  
        if os.path.isdir(i): fichier.extend(listdirectory(i))  
        else: fichier.append(i)  
    return fichier
# Cell Types: 0=Empty, 1=Text, 2=Number, 3=Date, 4=Boolean, 5=Error, 6=Blank
def ReadAndTestXLS(book,worksheet,numrow,numcol,typ,NoData):
    cell_type= worksheet.cell_type(rowx=numrow, colx=numcol)
    if cell_type==typ and typ!=3:
        cell_val=worksheet.cell_value(rowx=numrow, colx=numcol)
    elif cell_type==typ and typ==3:
        cell_val=worksheet.cell_value(rowx=numrow, colx=numcol)
        cell_val = datetime.datetime(*xlrd.xldate_as_tuple(cell_val, book.datemode))
        cell_val=cell_val.isoformat()
    else:
        cell_val=NoData
    return(cell_val)