title: Can I use SpreadsheetGear to read from a CSV file without it formatting the cells?
body: <p>Given a simple CSV file that consists of a string of digit characters and a date in UK format:
  <code>"00000000","01/01/2014"</code> </p>
  
  <p>and code to get the used cells: </p>
  
  <pre><code>IWorkbookSet workbookSet = SpreadsheetGear.Factory.GetWorkbookSet();
  IWorkbook workbook = workbookSet.Workbooks.Open(@"C:\file.csv");
  IRange cells = workbook.Worksheets[0].UsedRange;
  </code></pre>
  
  <p>when I access <code>cells[0,0].Text</code> it gives it as <code>0</code>, because it's treating it as numeric and therefore the leading 0s are meaningless. It will do the same for the date. I'm trying to manually construct a DataTable from the cells, but I need the original values in the file.</p>
  
  <p>I tried:</p>
  
  <pre><code>SpreadsheetGear.Advanced.Cells.IValues cells = (SpreadsheetGear.Advanced.Cells.IValues)workbook.Worksheets[0];
  var sb = new StringBuilder();
  cells[0,0].GetText(sb);
  </code></pre>
  
  <p>but nothing is appended to the string builder.</p>
  
  <p>How can I get access to the original file values?</p>