title: Load an Excel cell value with a leading apostrophe
body: <p>I want to be able to load the exact text within an Excel cell using Spreadsheet gear. This is because I want the leading apostrophe.</p>
  
  <p>For Example the cell has the text;
  'Test' This is a test.
  Spreadsheet gear strips away the leading '.</p>
  
  <pre><code>SpreadsheetGear.IWorkbook workbook = null;
  workbook = SpreadsheetGear.Factory.GetWorkbookSet(Workbooks.Open(excelFileName);
  IRange usedRange = workbook.Worksheets[0].UsedRange;
  Text = workbook.Worksheets[0].Cells[row, 0].Value as string;
  </code></pre>
  
  <p>Is this a limitation of loading data from Excel? Or is there just a different way to load the contents of an Excel cell using Spreadsheet gear?</p>