title: Accessing the value of the intersection of named ranges of an Excel spreadsheet in Python using xlrd?
body: <p>In Excel VBA, you can use the Intersect function which returns a range object that is the intersection of the arguments. You can then get a value from that like so.</p>
  
  <pre><code>Intersection("Name1", "Name2").Value
  </code></pre>
  
  <p>In a standard cell formula you can do the same thing:</p>
  
  <pre><code>=Name1 Name2
  </code></pre>
  
  <p>How do I accomplish this using xlrd? I've tried reading through the Name class and area2d looks like what I'll be using, but I don't know how to tie this all together.</p>