| Line 32... |
Line 32... |
| 32 |
workbook = xlrd.open_workbook(filename)
|
32 |
workbook = xlrd.open_workbook(filename)
|
| 33 |
sheet = workbook.sheet_by_index(0)
|
33 |
sheet = workbook.sheet_by_index(0)
|
| 34 |
num_rows = sheet.nrows
|
34 |
num_rows = sheet.nrows
|
| 35 |
delivery_times = {}
|
35 |
delivery_times = {}
|
| 36 |
for rownum in range(1, num_rows):
|
36 |
for rownum in range(1, num_rows):
|
| 37 |
dest_pincode, dest_code, state, exp, cod, station_type,\
|
37 |
dest_pincode, dest_code, exp, cod, station_type,\
|
| 38 |
delivery_times[WarehouseLocation.Delhi] = sheet.row_values(rownum)[0:7]
|
38 |
delivery_times[WarehouseLocation.Delhi] = sheet.row_values(rownum)[0:6]
|
| 39 |
#delivery_times[WarehouseLocation.Delhi], delivery_times[WarehouseLocation.Mumbai],\
|
39 |
#delivery_times[WarehouseLocation.Delhi], delivery_times[WarehouseLocation.Mumbai],\
|
| 40 |
# delivery_times[WarehouseLocation.Bangalore], delivery_times[WarehouseLocation.Kolkata] = sheet.row_values(rownum)[0:10]
|
40 |
# delivery_times[WarehouseLocation.Bangalore], delivery_times[WarehouseLocation.Kolkata] = sheet.row_values(rownum)[0:10]
|
| 41 |
dest_pincode = str(int(dest_pincode))
|
41 |
dest_pincode = str(int(dest_pincode))
|
| 42 |
dest_code = str(dest_code)
|
42 |
dest_code = str(dest_code)
|
| 43 |
sld = ServiceableLocationDetails()
|
43 |
sld = ServiceableLocationDetails()
|