title: How can I solve "ValueError: Cannot convert to Excel"? (Using Python & openpyxl)?
body: <p>I am scraping a price from a website using lxml and I'd like to insert that price into an existing Excel file using openpyxl. When I run the code, I get the error:</p>
  <blockquote>
  <p>ValueError: Cannot convert ['$364'] to Excel</p>
  </blockquote>
  <p>('$364' is the scraped price). How do I fix this? It appears that line 11 of code: <code>sheet['A1'] = price</code> is the problem. My entire code is below:</p>
  <pre><code>from lxml import html
  import requests
  page = requests.get('http://www.randomlengths.com/Woodwire/RL-Lbr-Pnl/')
  tree = html.fromstring(page.content)
  price = tree.xpath('//*[@id=&quot;main-frame&quot;]/div/div[1]/table/tbody/tr[2]/td[2]/strong/text()')
  print(price)
  
  import openpyxl
  xfile = openpyxl.load_workbook('C:/Users/noah.merkousko/randomlengthslumber.xlsx')
  sheet = xfile.get_sheet_by_name('Framing Lumber')
  sheet['A1'] = price
  xfile.save('random lengths lumber test.xls') 
  </code></pre>