Sql and excel
Right now I use sql to get data from an excel spreadsheet sent to us from a vendor. Inside of this sheet there is 9 cells in a row that have pricing information and the column headings change because the column heading is the week the price is valid. So I use column numbers to select instead of name. I don't think this has anything to do with my problem but when I post code some people may scratch their heads if they see all numbers instead of column names. My problem is that there are four cells in the middle of this nine that always come out as zero. Regardless of what I do. I have tried manually typing in the information, I have copied all data out of the sheet and into another sheet. Still same results. Here is the code.
for(i = 0; i < 10; i++){
amount2[i] = 0;
amount2[i] = rs.getDouble(i+25);
System.out.println(upc +" " + amount2[i]);
}
Results of this code are it prints the first 3 cells pricing then the next four are always 0 then after that the pricing is back again.
Anyone have any good ideas or have seen this happen. Thanks.
