How to get the value of a merged cell?

I am working on a project which has to make pdf report from couple of Excel files. The files should look like this: http://img194.imageshack.us/i/24766860.jpg/ and the pdf should look like this: http://img96.imageshack.us/i/u2ntitled.jpg/ where the location column must have the value of the me开发者_开发问答rged cell in the excel file(B2:E2).

So the difficulty is how to read the merged cell and put its value in the location column.

If that info is not enough I can add the source code. If you want any other info ask I'll give it right away.

---

Merged cells in excel are read by their first cell address. You should be able to pick up merged cell B2:E2 as B2