Subversion Repositories SmartDukaan

Rev

Rev 9492 | Rev 9505 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 9492 Rev 9493
Line 167... Line 167...
167 
    excel_integer_format = '0'
 167 
    excel_integer_format = '0'
168 
    integer_style = xlwt.XFStyle()
 168 
    integer_style = xlwt.XFStyle()
169 
    integer_style.num_format_str = excel_integer_format
 169 
    integer_style.num_format_str = excel_integer_format
170
170
171 
    sheet.write(0, 0, "Item ID", heading_xf)
 171 
    sheet.write(0, 0, "Item ID", heading_xf)
- 
 
 172 
    sheet.write(0, 1, "Brand", heading_xf)
- 
 
 173 
    sheet.write(0, 2, "Model Name", heading_xf)
- 
 
 174 
    sheet.write(0, 3, "Model Number", heading_xf)
- 
 
 175 
    sheet.write(0, 4, "Color", heading_xf)
172 
    sheet.write(0, 1, "Problem Type", heading_xf)
 176 
    sheet.write(0, 5, "Problem Type", heading_xf)
173
177
174 
    i=1
 178 
    i=1
175 
    for item in items:
 179 
    for item in items:
176 
        sheet.write(i, 0, item.item_id)
 180 
        sheet.write(i, 0, item.item_id)
- 
 
 181 
	sheet.write(i, 1, item.brand)
- 
 
 182 
	sheet.write(i, 2, item.model_name)
- 
 
 183 
	sheet.write(i, 3, item.model_number)
- 
 
 184 
	sheet.write(i, 4, item.color)
177 
        if len(item.issue)!=0:
 185 
        if len(item.issue)!=0:
178 
            sheet.write(i, 1, "Wrong item id or wrong warehouse Id")
 186 
            sheet.write(i, 5, "Wrong item id or wrong warehouse Id")
179 
        else:
 187 
        else:
180 
            sheet.write(i, 1, "Unable to fetch info from snapdeal server")
 188 
            sheet.write(i, 5, "Unable to fetch info from snapdeal server")
181 
        i+=1
 189 
        i+=1
182
190
183
191
184
192
185 
 
 193