if not os.path.exists(flag): sam_cnt = sam_cnt+1 sam_nm.append(sample) if sam_cnt == 0: status = 'full_marked' elif sam_cnt == len(sample_dir): status = 'none_marked' else: status = 'some_marked' return status,sam_nm; ## getting the spreadsheet from given name and appropriate worksheet credentials = get_credentials(config['credentials_file']) ssheet = SpreadSheet(credentials,config['gpl_spreadsheet']) wksheet = ssheet.get_worksheet(config['gpl_worksheet']) cell_feed = ssheet.get_cell_feed(wksheet) print "**** DONE ****\n" ##log print "Parsing worksheet and obtaining information..." ##log ## iterating through cell's content and gives list of prject signed delivered col_tot = int(cell_feed.col_count.text) projects_done, cell_content, row, ck, rNum = ([], [], [], 0, 1) for cell in cell_feed.entry: row.append(cell.content.text or "") ck = ck+1 if ck == col_tot: if rNum == 1: head1 = row elif rNum == 2: head2 = row
