Convert number stored as text to number
Posted: Tue Jun 01, 2010 6:46 am
How can I convert a number stored as text to a number. I can do it in Excel but can't figure out a simple way to do it using XLSReadWriteII4.
For now I'm just using
XLS.Sheet[0].AsFloat[i,z] := StrToFloat(StringReplace(XLS.Sheet[0].asString[i,z], ',','',[rfReplaceAll]));
and it works.
I wonder it there's another way.
For now I'm just using
XLS.Sheet[0].AsFloat[i,z] := StrToFloat(StringReplace(XLS.Sheet[0].asString[i,z], ',','',[rfReplaceAll]));
and it works.
I wonder it there's another way.