{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[11,8,13,12],[2,8,2,12]]}
["S.no","CODE","SLAB","LOCATION","TYPE","STEP"]
[null,"k01v","SLAB - 1","LOCATION - T","NORMAL","STEP - 1"]
[null,"k01v","SLAB - 1","LOCATION - T","NORMAL","STEP - 1",null,null,"MACRO CONDITION:-"]
[null,"k01v","SLAB - 1","LOCATION - T","NORMAL","STEP - 1"]
[null,"k01v","SLAB - 1","LOCATION - T","NORMAL","STEP - 1",null,null,"S NO","CODE","SLAB","LOCATION","TYPE","STEP"]
[5,"k01v","SLAB - 1","LOCATION - T","NORMAL","STEP - 1",null,null,1,"k01v","1,2","T,B","Normal , Sip","STEP - 1"]
[null,null,null,null,null,null,null,null,2,"y02k","1,2","T,B","Normal , Sip","STEP - 2"]
[6,"k01v","SLAB - 2","LOCATION - T","NORMAL","STEP - 1",null,null,3,"n01p",2,"B","Sip","STEP - 3"]
[7,"k01v","SLAB - 2","LOCATION - T","NORMAL","STEP - 1",null,null,4,"j55s",1,"T","Normal","STEP - 4"]
[8,"k01v","SLAB - 2","LOCATION - T","NORMAL","STEP - 1"]
[9,"k01v","SLAB - 2","LOCATION - T","NORMAL","STEP - 1"]
[10,"k01v","SLAB - 2","LOCATION - T","NORMAL","STEP - 1",null,null,"When i give above said condition, Then it will automatically generate like these rows by Macro. And no need any row gaps. Example: no need gap between 5 and 6 row. It is top most urgent. Kinldy do the needful urgent basis."]
[]
[]
[11,"k01v","SLAB - 1","LOCATION - B","NORMAL","STEP - 1"]
[12,"k01v","SLAB - 1","LOCATION - B","NORMAL","STEP - 1"]
[13,"k01v","SLAB - 1","LOCATION - B","NORMAL","STEP - 1"]
[14,"k01v","SLAB - 1","LOCATION - B","NORMAL","STEP - 1"]
[15,"k01v","SLAB - 1","LOCATION - B","NORMAL","STEP - 1"]
[16,"k01v","SLAB - 2","LOCATION - B","NORMAL","STEP - 1"]
[17,"k01v","SLAB - 2","LOCATION - B","NORMAL","STEP - 1"]
[18,"k01v","SLAB - 2","LOCATION - B","NORMAL","STEP - 1"]
[19,"k01v","SLAB - 2","LOCATION - B","NORMAL","STEP - 1"]
[20,"k01v","SLAB - 2","LOCATION - B","NORMAL","STEP - 1"]
[]
[21,"k01v","SLAB - 1","LOCATION - T","SIP","STEP - 1"]
[22,"k01v","SLAB - 1","LOCATION - T","SIP","STEP - 1"]
[23,"k01v","SLAB - 1","LOCATION - T","SIP","STEP - 1"]
[24,"k01v","SLAB - 1","LOCATION - T","SIP","STEP - 1"]
[25,"k01v","SLAB - 1","LOCATION - T","SIP","STEP - 1"]
[26,"k01v","SLAB - 2","LOCATION - T","SIP","STEP - 1"]
[27,"k01v","SLAB - 2","LOCATION - T","SIP","STEP - 1"]
[28,"k01v","SLAB - 2","LOCATION - T","SIP","STEP - 1"]
[29,"k01v","SLAB - 2","LOCATION - T","SIP","STEP - 1"]
[30,"k01v","SLAB - 2","LOCATION - T","SIP","STEP - 1"]
[31,"k01v","SLAB - 1","LOCATION - B","SIP","STEP - 1"]
[32,"k01v","SLAB - 1","LOCATION - B","SIP","STEP - 1"]
[33,"k01v","SLAB - 1","LOCATION - B","SIP","STEP - 1"]
[34,"k01v","SLAB - 1","LOCATION - B","SIP","STEP - 1"]
[35,"k01v","SLAB - 1","LOCATION - B","SIP","STEP - 1"]
[36,"k01v","SLAB - 2","LOCATION - B","SIP","STEP - 1"]
[37,"k01v","SLAB - 2","LOCATION - B","SIP","STEP - 1"]
[38,"k01v","SLAB - 2","LOCATION - B","SIP","STEP - 1"]
[39,"k01v","SLAB - 2","LOCATION - B","SIP","STEP - 1"]
[40,"k01v","SLAB - 2","LOCATION - B","SIP","STEP - 1"]
[]
[41,"y02k","SLAB - 1","LOCATION - T","NORMAL","STEP - 2"]
[42,"y02k","SLAB - 1","LOCATION - T","NORMAL","STEP - 2"]
[43,"y02k","SLAB - 1","LOCATION - T","NORMAL","STEP - 2"]
[44,"y02k","SLAB - 1","LOCATION - T","NORMAL","STEP - 2"]
[45,"y02k","SLAB - 1","LOCATION - T","NORMAL","STEP - 2"]
[]
[46,"y02k","SLAB - 2","LOCATION - T","NORMAL","STEP - 2"]
[47,"y02k","SLAB - 2","LOCATION - T","NORMAL","STEP - 2"]
[48,"y02k","SLAB - 2","LOCATION - T","NORMAL","STEP - 2"]
[49,"y02k","SLAB - 2","LOCATION - T","NORMAL","STEP - 2"]
[50,"y02k","SLAB - 2","LOCATION - T","NORMAL","STEP - 2"]
[]
[51,"y02k","SLAB - 1","LOCATION - B","NORMAL","STEP - 2"]
[52,"y02k","SLAB - 1","LOCATION - B","NORMAL","STEP - 2"]
[53,"y02k","SLAB - 1","LOCATION - B","NORMAL","STEP - 2"]
[54,"y02k","SLAB - 1","LOCATION - B","NORMAL","STEP - 2"]
[55,"y02k","SLAB - 1","LOCATION - B","NORMAL","STEP - 2"]
[56,"y02k","SLAB - 2","LOCATION - B","NORMAL","STEP - 2"]
[57,"y02k","SLAB - 2","LOCATION - B","NORMAL","STEP - 2"]
[58,"y02k","SLAB - 2","LOCATION - B","NORMAL","STEP - 2"]
[59,"y02k","SLAB - 2","LOCATION - B","NORMAL","STEP - 2"]
[60,"y02k","SLAB - 2","LOCATION - B","NORMAL","STEP - 2"]
[]
[61,"y02k","SLAB - 1","LOCATION - T","SIP","STEP - 2"]
[62,"y02k","SLAB - 1","LOCATION - T","SIP","STEP - 2"]
[63,"y02k","SLAB - 1","LOCATION - T","SIP","STEP - 2"]
[64,"y02k","SLAB - 1","LOCATION - T","SIP","STEP - 2"]
[65,"y02k","SLAB - 1","LOCATION - T","SIP","STEP - 2"]
[66,"y02k","SLAB - 2","LOCATION - T","SIP","STEP - 2"]
[67,"y02k","SLAB - 2","LOCATION - T","SIP","STEP - 2"]
[68,"y02k","SLAB - 2","LOCATION - T","SIP","STEP - 2"]
[69,"y02k","SLAB - 2","LOCATION - T","SIP","STEP - 2"]
[70,"y02k","SLAB - 2","LOCATION - T","SIP","STEP - 2"]
[71,"y02k","SLAB - 1","LOCATION - B","SIP","STEP - 2"]
[72,"y02k","SLAB - 1","LOCATION - B","SIP","STEP - 2"]
[73,"y02k","SLAB - 1","LOCATION - B","SIP","STEP - 2"]
[74,"y02k","SLAB - 1","LOCATION - B","SIP","STEP - 2"]
[75,"y02k","SLAB - 1","LOCATION - B","SIP","STEP - 2"]
[76,"y02k","SLAB - 2","LOCATION - B","SIP","STEP - 2"]
[77,"y02k","SLAB - 2","LOCATION - B","SIP","STEP - 2"]
[78,"y02k","SLAB - 2","LOCATION - B","SIP","STEP - 2"]
[79,"y02k","SLAB - 2","LOCATION - B","SIP","STEP - 2"]
[80,"y02k","SLAB - 2","LOCATION - B","SIP","STEP - 2"]
[]
[81,"n01p","SLAB - 2","LOCATION - B","SIP","STEP - 3"]
[82,"n01p","SLAB - 2","LOCATION - B","SIP","STEP - 3"]
[83,"n01p","SLAB - 2","LOCATION - B","SIP","STEP - 3"]
[84,"n01p","SLAB - 2","LOCATION - B","SIP","STEP - 3"]
[85,"n01p","SLAB - 2","LOCATION - B","SIP","STEP - 3"]
[]
[86,"j55s","SLAB - 1","LOCATION - T","NORMAL","STEP - 4"]
[87,"j55s","SLAB - 1","LOCATION - T","NORMAL","STEP - 4"]
[88,"j55s","SLAB - 1","LOCATION - T","NORMAL","STEP - 4"]
[89,"j55s","SLAB - 1","LOCATION - T","NORMAL","STEP - 4"]
[90,"j55s","SLAB - 1","LOCATION - T","NORMAL","STEP - 4"]

{"sheet":"Sheet2","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["k01v","SLAB - 1","LOCATION - T","Normal ","STEP - 1"]
["k01v","SLAB -2","LOCATION -T","Normal ","STEP - 1"]
["k01v","SLAB -1","LOCATION -B","Normal ","STEP - 1"]
["k01v","SLAB -2","LOCATION -B","Normal ","STEP - 1"]
["k01v","SLAB -1","LOCATION -T"," Sip","STEP - 1"]
["k01v","SLAB -2","LOCATION -T"," Sip","STEP - 1"]
["k01v","SLAB -1","LOCATION -B"," Sip","STEP - 1"]
["k01v","SLAB -2","LOCATION -B"," Sip","STEP - 1"]
["y02k","SLAB -1","LOCATION -T","Normal ","STEP - 2"]
["y02k","SLAB -2","LOCATION -T","Normal ","STEP - 2"]
["y02k","SLAB -1","LOCATION -B","Normal ","STEP - 2"]
["y02k","SLAB -2","LOCATION -B","Normal ","STEP - 2"]
["y02k","SLAB -1","LOCATION -T"," Sip","STEP - 2"]
["y02k","SLAB -2","LOCATION -T"," Sip","STEP - 2"]
["y02k","SLAB -1","LOCATION -B"," Sip","STEP - 2"]
["y02k","SLAB -2","LOCATION -B"," Sip","STEP - 2"]
["n01p","SLAB -2","LOCATION -B","Sip","STEP - 3"]
["j55s","SLAB -1","LOCATION -T","Normal","STEP - 4"]

{"sheet":"Sheet3","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["S NO","CODE","SLAB","LOCATION","TYPE","STEP"]
[1,"k01v","1,2","T,B","Normal , Sip","STEP - 1"]
[2,"y02k","1,2","T,B","Normal , Sip","STEP - 2"]
[3,"n01p",2,"B","Sip","STEP - 3"]
[4,"j55s",1,"T","Normal","STEP - 4"]