This is a discussion on importing values from excel - Clipper ; Hi, I am using: oExcel:=XLApplication{"Excel.Application"} to import a range of excel cells into a VO array but; in a column that I spect only strings and when the cell content is something like: 321358 or .656577 I receive a numeric ...
importing values from excel Hi,
I am using:
oExcel:=XLApplication{"Excel.Application"}
to import a range of excel cells into a VO array but;
in a column that I spect only strings and when the cell content is
something like:
321358 or .656577 I receive a numeric value like 321358.00 or
0.656577.
What can I do in order to get the data spected (string) in the array?
Thanks
Oscar Hernandez
Re: importing values from excel Oscar
Here's one way:
for nIndex := 1 upto alen( anArray )
if isNumeric( anArray[ nIndex ] ) )
anArray[ nIndex ] := ntrim( anArray[ nIndex ] )
endif
next
Another way is to make sure the column in the excel spreadsheet is defined as a 'Character/Text/String' type.
--
CYA
Steve
LinkBack URL
About LinkBacks