def upload_main(argv): if len(argv) != 2: return __doc__ path = argv[1] sheet = load_sheet(path) try: collection = hyou.login(json_path=CREDENTIAL_PATH) except Exception: return ('Your credential is missing, expired or invalid.' 'Please authenticate again by --authenticate.') title = os.path.basename(path).decode('utf-8') spreadsheet = collection.create_spreadsheet(title, rows=len(sheet), cols=len(sheet[0])) with spreadsheet[0] as worksheet: for srow, trow in zip(sheet, worksheet): for i, value in enumerate(srow): trow[i] = value print spreadsheet.url
def upload(self, results): collection = hyou.login(self._credential_path) spreadsheet = collection[self._sheet_id] sorted_results = sorted(results.values(), key=lambda page: page['page_id']) #self._upload_allocator_sizes(sorted_results, spreadsheet) #self._upload_partitions(sorted_results, spreadsheet) self._upload_partitions_allocated_sizes(sorted_results, spreadsheet) #self._upload_partition_buffer_details(sorted_results, spreadsheet) self._upload_partition_fast_malloc_details(sorted_results, spreadsheet)
def main(): json_path = os.path.join(os.path.dirname(__file__), 'creds', 'unittest-sheets.json') collection = hyou.login(json_path) spreadsheet = collection['1hxNAHH-DUWgFcC603mFARGYOeKUwiRq56VsHOJSA5Z0'] print('Running tests with %s ...' % spreadsheet.url) worksheet_title = 'sheet%08d' % random.randrange(100000000) worksheet = spreadsheet.add_worksheet(worksheet_title, rows=20, cols=10) print('Created %s' % worksheet_title) try: print('Testing...') assert worksheet.title == worksheet_title assert worksheet.rows == 20 assert worksheet.cols == 10 worksheet.rows = 15 assert worksheet.rows == 15 view = worksheet.view(start_row=2, end_row=4, start_col=3, end_col=6) assert len(view) == 2 assert len(view[0]) == 3 view[0][0] = 'a' view[0][1:] = ['b', 'c'] view[-1][:] = ['d', 'e', 'f'] view.commit() assert view[1][1] == 'e' worksheet.refresh() assert worksheet[3][4] == 'e' finally: spreadsheet.delete_worksheet(worksheet_title) print('Removed %s' % worksheet_title) print('PASSED!')
def upload_main(argv): if len(argv) != 2: return __doc__ path = argv[1] sheet = load_sheet(path) try: collection = hyou.login(json_path=CREDENTIAL_PATH) except Exception: return ('Your credential is missing, expired or invalid.' 'Please authenticate again by --authenticate.') title = os.path.basename(path).decode('utf-8') spreadsheet = collection.create_spreadsheet( title, rows=len(sheet), cols=len(sheet[0])) with spreadsheet[0] as worksheet: for srow, trow in zip(sheet, worksheet): for i, value in enumerate(srow): trow[i] = value print spreadsheet.url
def upload_main(argv): if len(argv) != 3: return __doc__ path, title = argv[1:] title = title.decode('utf-8') sheet = load_sheet(path) try: collection = hyou.login(json_path=CREDENTIAL_PATH) except Exception: return ('Your credential is missing, expired or invalid.' 'Please authenticate again by --authenticate.') spreadsheet = collection.create_spreadsheet( title, rows=len(sheet), cols=len(sheet[0])) with spreadsheet[0] as worksheet: for srow, trow in zip(sheet, worksheet): for i, value in enumerate(srow): trow[i] = value print 'https://docs.google.com/spreadsheets/d/%s/edit' % spreadsheet.key