I am running the 4.4.1 hotfix version of the Cells software.
I am reading a csv-formatted file. This file contains a particular column--the data in which can either be all numeric or all alphanumeric for a particular row. I need to treat all rows for this particular column as alphanumeric.
A value of "00139820" in the csv-file gets returned to my program as a numeric value of: 139820. The leading zeroes get stripped, and I need them--they are an important component of the data itself.
I have attempted to load this column by referencing myCells[myRow, 2].StringValue.ToString(); I have also tried a number of other properties, but nothing allows the leading zeroes to be represented.
What can I do?