audai
12 years agoOccasional Contributor
Read an Excel file
I want to read an Excel file with multiple columns and one of the columns have multiple data, some String and other Integer like in attachment in column filterValue.
As you see in the file I have 4 values of type integer and one of type string, but when I read the string one it couldn't read it why?????
trCol = aqConvert.VarToStr(DDT.CurrentDriver.Value(0));
strValue = aqConvert.VarToStr(DDT.CurrentDriver.Value(4));
colName = aqConvert.VarToStr(DDT.CurrentDriver.Value(2));
op = aqConvert.VarToStr(DDT.CurrentDriver.Value(3));
Thanks in advance.
As you see in the file I have 4 values of type integer and one of type string, but when I read the string one it couldn't read it why?????
trCol = aqConvert.VarToStr(DDT.CurrentDriver.Value(0));
strValue = aqConvert.VarToStr(DDT.CurrentDriver.Value(4));
colName = aqConvert.VarToStr(DDT.CurrentDriver.Value(2));
op = aqConvert.VarToStr(DDT.CurrentDriver.Value(3));
Thanks in advance.