def update_items_sheet(self):
self.items = self.sheet.col_values(self.items_colm)[1:]
amazon_bot = AmazonBot(self.items)
urls, prices, name_of_items = amazon_bot.search_items()
print("\nUpdating the Spreadsheet.....\n")
for x in range(len(urls)):
self.sheet.update_cell(x+2, self.price_colm, prices[x])
self.sheet.update_cell(x+2, self.prod_url, urls[x])
self.sheet.update_cell(x+2, self.prod_name, name_of_items[x])
def process_item_list(self):
items = self.sheet.col_values(self.item_col)[1:]
amazon_box = AmazonBot(items)
prices, urls, names = amazon_box.search_items()
print("Updating spreedsheet.")
for i in range(len(prices)):
self.sheet.update_cell(i + 2, self.price_col, prices[i])
self.sheet.update_cell(i + 2, self.url_col, urls[i])
self.sheet.update_cell(i + 2, self.product_name_col, names[i])
def process_item_list(self):
# Skip over the column heading in the spreadsheet.
items = self.sheet.col_values(self.item_col)[1:]
print(items)
amazon_bot = AmazonBot(items)
prices, urls, names = amazon_bot.search_items()
print("Updating spreadsheet.")
print(prices, urls, names)
for i in range(len(prices)):
self.sheet.update_cell(i + 2, self.price_col, prices[i])
self.sheet.update_cell(i + 2, self.url_col, urls[i])
self.sheet.update_cell(i + 2, self.product_name_col, names[i])