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...
chicks's avatar
chicks
Regular Contributor
14 years ago
When I'm getting the error, putting the apostrophe before the values does not fix the problem.

I'm only checking two rows at a time. 



Generally, I'm treating everything as text and using vartostr, though it sounds like either the driver or excel is trying to be 'smart'.



Can you tell me more or direct me to something regarding your ini files, please?  I've  worked with CSV files before and ended up

editing them in excel and then saving as CSV because editing the raw CSV was kind of tedious. 



Thanks very much for your advice.



Regards.  Curt









































omit website participant loyaltyCard signupType nameOrPin zipCode
https://qafuelrewards.efuelrewards.com/cppublic/fuelperks/ QA Corner Stores Issue Redeem 1509 3 Test 75001//:867
https://qafuelrewards.efuelrewards.com/cppublic/fuelperks/ QA Corner Stores Issue Redeem 1510 3 Test 75001