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.

Following is my code:

```py
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;

```

The output is :

```none
Suite Location is None

```

The value in cell for D3 to H3 is :

```none
c:\users\xyz\desktop\abc\c++\events\comevents

```

I even tried printing all the values in the sheet but except for integer values all values returned None.

Following is the changed code:

```py
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;

```

The output is:

```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
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

```

The Excel file has following content:

```none
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

```