title: Data Model in excel 2010 and 2013 // data retrieval
body: <p>In Excel  <a href="http://msdn.microsoft.com/fr-fr/library/office/ff838417.aspx" rel="nofollow">2013</a> and <a href="http://msdn.microsoft.com/en-us/library/ff194775%28v=office.14%29.aspx" rel="nofollow">2010</a> there is the notion of WorkbookConnection, which represents a connection to an external source of data. We can access them through PowerPivot or other tools.</p>
  
  <p>One particular type of connection is the OLEDB connection (but there are other kinds), which after refresh gets the data according to the <a href="http://msdn.microsoft.com/en-us/library/ff838765%28v=office.14%29.aspx" rel="nofollow">documentation</a>.</p>
  
  <p>I would like to <strong>access those data</strong> the workbook has locally, coming from those connection.</p>
  
  <p>=> Is there a way to have access to a direct property (a range/ListObject (aka table)) ?</p>
  
  <p>For the moment, it seems the only option is to retro-engineer the convention used for the different kind of sources and lookup heuristically tables based on names.. (It seems trivial, but I can't find the answer in the documentation )</p>