Forum Discussion

chicks's avatar
chicks
Regular Contributor
14 years ago

Excel column returns null for non-numeric characters

Anybody seen anything like this or have any comments? short version ========= When I tried to use aqConvertVarToStr on values in an excel column that had non-numeric characters, I got ei...
Martin_Blass's avatar
Martin_Blass
New Contributor
8 years ago

Thanks!

I was struggling a bit with it...

 

Just a hint for others - If you have no column names you still have to fill in something for the name in the Schema.ini file. In particular you have to use letter "F" and the column number...

 

e.g.

[parameter_sets.csv]
ColNameHeader=True
Format=Delimited(;)
Col1=F1 Text
Col2=F2 Text
Col3=F3 Text
Col4=F4 Text
Col5=F5 Text
Col6=F6 Text
Col7=F7 Text
Col8=F8 Text