Last active
July 6, 2023 11:31
-
-
Save Shankjbs571/3fc2bb71d04f9ace610890a92682ecd7 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def generate_excel_HPPE14152(request): | |
| print("ByShashank") | |
| # This is the base code to set the top parameters | |
| asn = request.GET.get('asn') | |
| date = request.GET.get('date') | |
| response = HttpResponse(content_type='application/vnd.ms-excel') | |
| response['Content-Disposition'] = 'attachment; filename="my_excel_file.xls"' | |
| #Setting up the Styles | |
| wb = xlwt.Workbook(encoding='utf-8') | |
| font_style2 = xlwt.easyxf('font: bold True, name Calibri, height 220; alignment: vertical center, horizontal center, wrap on; pattern: pattern solid, fore_colour light_green; borders: left thin, right thin, top thin, bottom thin') | |
| font_style = xlwt.easyxf('font: height 180; align: vertical center, horizontal center, wrap on; pattern: pattern solid, fore_colour ice_blue; borders: left thin, right thin, top thin, bottom thin') | |
| font_style1 = xlwt.easyxf('font: bold True, name Calibri, height 300; align: vertical center, horizontal center, wrap on; pattern: pattern solid, fore_colour light_green; borders: left thin, right thin, top thin, bottom thin') | |
| blue_style = xlwt.easyxf('pattern: pattern solid, fore_color blue;') | |
| styleg = xlwt.easyxf('font: bold True, height 180; align: vertical center, horizontal center, wrap on; pattern: pattern solid, fore_colour sky_blue; borders: left thin, right thin, top thin, bottom thin') | |
| styleg.font.colour_index = xlwt.Style.colour_map['black'] | |
| styley = xlwt.easyxf( 'font: colour blue, bold True;') | |
| styler = xlwt.easyxf( 'font: colour red, bold True;') | |
| #Database Connection and Data Fetching | |
| cursor=connection.cursor() | |
| cursor.execute(''' | |
| SELECT t1."Engine_Div_trx_code", t2."Engine_division_Para", t1."Engine_div_sub_para", t1."CHECK", "REMARKS", t1."Engine_Division_Inspection_code" | |
| FROM public.dlw_engine_division_hhpe14152_trx t1 , public.dlw_engine_division_mst t2 | |
| WHERE t1."Engine_Division_Inspection_code"=t2."Engine_Division_Inspection_code" | |
| AND t1."Assembly_Sl_No"=%s | |
| ORDER BY t1."Engine_Div_trx_code" ASC ''',[asn]) | |
| result = cursor.fetchall() | |
| # Here we are starting with the worksheet Creation | |
| ws1 = wb.add_sheet('Sheet 1') | |
| #Sheet Headings | |
| ws1.write_merge(0, 3, 0, 9, 'Title- Check sheet of HHP Engine Assembly Inspection for 4000/4500 HP.',font_style1) | |
| ws1.write_merge(4, 7,0, 9, '1.0 Introduction:- It includes inspection of HHP ENGINE ASSEMBLY 4000/4500 HP. in Erection Shop\n2.0 Methods : As given below.',font_style1) | |
| ws1.write_merge(8, 9,0, 4, 'Assembly SL. No'+str(asn),font_style2) | |
| ws1.write_merge(8, 9,5, 9, 'Date: '+str(date),font_style2) | |
| title_row=10 | |
| ws1.write_merge(12,12,0,1,'S.No',styleg) | |
| ws1.write_merge(12,12,2,5,'Description',styleg) | |
| ws1.write_merge(12,12,6,6,'Check',styleg) | |
| ws1.write_merge(12,12,7,9,'Remark',styleg) | |
| count=0 | |
| row = 13 | |
| last_title='anything' | |
| for i in result: | |
| print("i[1] ",i[1]) | |
| if i[1]=='1.OST Housing ': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '1.OST Housing',font_style2) | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='2. Counter weights free end' or i[1]=='2.Counter weights free end': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '2. Counter weights free end',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title='2.Counter weights free end' | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='3.OST Cover': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '3.OST Cover',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='4. Fuel Filter Block': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '4. Fuel Filter Block',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='5. Fuel Piping': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '5. Fuel Piping',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='6. Injector Control Shaft Brackets': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '6. Injector Control Shaft Brackets',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='7. Water Supply Elbows': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '7. Water Supply Elbows',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='8. Detector Assembly (EPD)': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '8. Detector Assembly (EPD)',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='9. Hot Oil Valve (Thermostat Valve)': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '9. Hot Oil Valve (Thermostat Valve)',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='10. Cylinder Test Valves': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '10. Cylinder Test Valves ',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='11. Dip Stick': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '11. Dip Stick',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='12. Governor': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '12. Governor',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='13. Rocker Arm Assembles And Valve Bridges': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '13. Rocker Arm Assembles And Valve Bridges',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='14. Micro Links': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '14. Micro Links',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='15. Injector Control Shaft And Levers.': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '15. Injector Control Shaft And Levers.',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='16. Adjust injector micro links.': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '16. Adjust injector micro links.',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='17.Oil slinger and shims': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '17.Oil slinger and shims',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='18. Starter motor bracket': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '18. Starter motor bracket',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='19. Coupling disc to engine': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '19. Coupling disc to engine',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='20. Turbocharger lube oil filter': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '20. Turbocharger lube oil filter',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='21. Turbocharger': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '21. Turbocharger',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='21. Turbocharger': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '21. Turbocharger',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='22. AFTERCOOLER PIPING': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '22. AFTERCOOLER PIPING',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='23. AUXILIARY GENERATOR DRIVE': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '23. AUXILIARY GENERATOR DRIVE',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='24. SOAKBACK TUBING': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '24. SOAKBACK TUBING',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='25. OIL SEPARATOR': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '25. OIL SEPARATOR',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='26. EXHAUST MANIFOLD': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '26. EXHAUST MANIFOLD',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='27. EXHAUST VALVE AND INJECTOR ROCKER ARM TIMING': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '27. EXHAUST VALVE AND INJECTOR ROCKER ARM TIMING',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='28. HANDHOLE COVERS.': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '28. HANDHOLE COVERS.',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='29. TOP DECK COVERS.': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '29. TOP DECK COVERS.',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='30. FINAL PAYOFF': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '30. FINAL PAYOFF',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| elif i[1]=='31. FOR ENGINE MANUFACTURE AND ASSEMBLY REFERENCES REFER TO: A.I.4189 FOR 56/ ENGINES A.I. 2127 FOR 645 AND 710 ENGINES E.S.F.R.2050 FOR SERVICE ENGINES A.I.2153 FOR ALL MODEL 645E NAVY (HIGH SHOCK) ENGINES': | |
| if i[1]!=last_title: | |
| ws1.write_merge(title_row,title_row+1,0, 9, '31. FOR ENGINE MANUFACTURE AND ASSEMBLY REFERENCES REFER TO: A.I.4189 FOR 56/ ENGINES A.I. 2127 FOR 645 AND 710 ENGINES E.S.F.R.2050 FOR SERVICE ENGINES A.I.2153 FOR ALL MODEL 645E NAVY (HIGH SHOCK) ENGINES',font_style2) | |
| print("title_row ",title_row) | |
| row=row+3 | |
| print("row ",row) | |
| ws1.write_merge(row,row,0,1,'S.No',styleg) | |
| ws1.write_merge(row,row,2,5,'Description',styleg) | |
| ws1.write_merge(row,row,6,6,'Check',styleg) | |
| ws1.write_merge(row,row,7,9,'Remark',styleg) | |
| row+=1 | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| else: | |
| ws1.write_merge(row,row,0,1,i[0],font_style) | |
| ws1.write_merge(row,row,2,5,i[2],font_style) | |
| ws1.write_merge(row,row,6,6,i[3],font_style) | |
| ws1.write_merge(row,row,7,9,i[4],font_style) | |
| row+=1 | |
| title_row=row+1 | |
| last_title=i[1] | |
| # Saving the Sheets and Return of Response | |
| wb.save(response) | |
| return response |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment