urgent,
now am using infragistics v 11.1.
am trying to import the data form xls to dataset. but in zipcode column. leading zero is not getting from xls,
so i need to format the Xls column orelse i need to get leading zero
pls help me.
The required number of digits in Excel is determined by the format string of the cell. Currently, there is no support for combining the value of a cell with its format string to determine what the display would look like in the Micrsoft Excel UI. You can submit a feature request for this. And for now, you will need to manually determine how many digits there are in the cell's value and pad zeros on the front if needed.