2 xls files if statement
in
Contributed Library Questions
•
2 years ago
hopefully someone can help. I'm using xls reader.
anyone have any idea why the if statement won't work?
what's inside the if works on it's own, but won't work with the if. I want it to print cells if the cell from the first excel sheet matches the cell from the second sheet, through the 2 loops.
reader = new XlsReader( this, "titles.xls" );
reader2 = new XlsReader( this, "Nov10.xls");
//loop through list of titles, only 3 as i know one of these 3 appear in the start of second sheet
for (int i = 6887; i < 6888; i = i+1) {
fig=0;
//loop through novemeber titles and figures
for (int z = 1; z < 10; z = z+1) {
if ((reader.getString(i, 1)) == (reader2.getString(z, 1)) ) {
fig = fig+(reader2.getFloat( z, 5)) ;
print(reader2.getString(z,1));
print ("----");
print(fig);
print ("---");
fig=0;
}//if closes
}//nov titles loop closes
}//titles loop closes
1
