title: web scraping and transferring data into excel using python
body: <p>im able to fully scrap the material i needed the problem is i cant get the data into excel. </p>
  
  <pre><code>from lxml import html
  import requests
  import xlsxwriter
  
  page = requests.get('website that gets mined')
  tree = html.fromstring(page.content)
  
  
  
  
  items = tree.xpath('//h4[@class="item-title"]/text()')
  prices = tree.xpath('//span[@class="price"]/text()')
  description = tree.xpath('//div[@class="description text"]/text()')
  print 'items: ', items
  print 'Prices: ', prices
  print 'description', description
  </code></pre>
  
  <p>everything works fine until this section where i try to get the data into excel
  this is the error message: </p>
  
  <pre><code>for items,prices,description in (array):
  ValueError: too many values to unpack
  Exception Exception: Exception('Exception caught in workbook destructor. Explicit close() may be required for workbook.',) in &lt;bound method Workbook.__del__ of &lt;xlsxwriter.workbook.Workbook object at 0x104735e10&gt;&gt; ignored
  </code></pre>
  
  <p>this is what it was trying to do </p>
  
  <pre><code>array = [items,prices,description]
  workbook   = xlsxwriter.Workbook('test1.xlsx')
  worksheet = workbook.add_worksheet()
  row = 0
  col = 0
  
  for items,prices,description in (array):
      worksheet.write(row, col, items)
      worksheet.write(row, col + 1, prices)
      worksheet.write(row, col + 2, description)
      row += 1
  workbook.close()
  </code></pre>