Ok for those that may have the same problem here is my conclusion:


DO NOT use Ole
use Microsoft.Office.Interop.Excel

Using that I managed to read/fetch what was in the spreadsheet regardless of what other internal attaributes may affect Ole in not offering back what is in the XLS.

Cheers