title: How to get value present in a merged cell?
body: <p>I want to get value of a merged cell that has range from D3 to H3 using openpyxl library.
  As per my understanding most libraries read data from 1st cell itself. Thus the merged content is present in it but I get a none value when I read it.</p>
  
  <p>Following is my code:</p>
  
  <pre class="lang-py prettyprint-override"><code>wb = load_workbook(work_directory_path+'/outputs/report_vap.xlsx')
  ws = wb.get_sheet_by_name("Summary")
  suite_path = ws.cell('D3').value
  if not isinstance(suite_path, unicode):
      value=unicode(suite_path)
  value=value.encode('utf8')
  print "Suite Location is "+value;
  </code></pre>
  
  <p>The output is :</p>
  
  <pre class="lang-none prettyprint-override"><code>Suite Location is None
  </code></pre>
  
  <p>The value in cell for D3 to H3 is :</p>
  
  <pre class="lang-none prettyprint-override"><code>c:\users\xyz\desktop\abc\c++\events\comevents
  </code></pre>
  
  <p>I even tried printing all the values in the sheet but except for integer values all values returned None.</p>
  
  <p>Following is the changed code:</p>
  
  <pre class="lang-py prettyprint-override"><code>wb = load_workbook(work_directory_path+'/outputs/report_vap.xlsx')
  ws = wb.get_sheet_by_name("Summary")
  for row_index in range (ws.get_highest_row()):
      for col_index in range (ws.get_highest_column()):
          print ws.cell(row=row_index, column=col_index).value
  suite_path = ws.cell('A11').value
  print suite_path
  if not isinstance(suite_path, unicode):
     value=unicode(suite_path)
  value=value.encode('utf8')
  print "Suite Location is "+value;
  </code></pre>
  
  <p>The output is:</p>
  
  <pre class="lang-none prettyprint-override"><code>None
  
  
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  
  
  None
  
  
  
  
  None
  
  
  None
  
  
  
  
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  
  
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  1
  1
  None
  None
  None
  None
  None
  None
  9
  1106
  None
  None
  None
  None
  None
  None
  10
  1107
  None
  None
  None
  None
  None
  None
  None
  None
  None
  None
  Suite Location is None
  Suite Location is None
  12
  </code></pre>
  
  <p>The Excel file has following content:</p>
  
  <pre class="lang-none prettyprint-override"><code>Project/module ID   Project/module  Build Analysis  Language    Compiler    Source File Source File
  
  1_1 HTMLEdit.vcxproj    Success C++ Microsoft Visual Studio 2010 ( version 10.0 )   1   1
  
  1_2 HTMLEdit.vcxproj    Success C++ Microsoft Visual Studio 2010 ( version 10.0 )   9   1106
  Total                   10  1107
  </code></pre>