{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["For_loop_example1_sales","Do_while_loop_continue","Do_until_continue_loop","For_loop_continue_use_if","For_loop-continue_on_error","For_each_loop","Nested_for_loop_Table","nested_for_loop_AverageMarks"],"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":"For_loop_example1_sales","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Sales Data Using For Loop"]
[]
[null,"Product ID","Quantity","Price","Sales"]
[null,101,5,100,500]
[null,102,"Not Available",150]
[null,103,12,250,3000]
[null,104,14,480,6720]
[null,105,16,250,4000]
[null,106,18,120,2160]

{"sheet":"Do_while_loop_continue","index":1,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Continue Do While Loop "]
[]
[null,"Subject","Marks"]
[null,"Physics",92]
[null,"Chemistry",75]
[null,"Literature",-25]
[null,"History",77]
[null,"Mathematics",95]
[null,"Geography",82]
[null,"Total Marks",421]

{"sheet":"Do_until_continue_loop","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Continue Do Until Loop "]
[]
[null,"Subject","Marks"]
[null,"Physics",92]
[null,"Chemistry",75]
[null,"Literature",-25]
[null,"History",77]
[null,"Mathematics",95]
[null,"Geography",82]
[null,"Total Marks",421]

{"sheet":"For_loop_continue_use_if","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Continue For loop Using If Statement"]
[]
[null,"ID","Name","Marks"]
[null,501,"John",88]
[null,502,"Anna",56]
[null,503,"Noah",58]
[null,504,"Jane",79]
[null,505,"Smith","Absent"]
[null,506,"Alex",88]
[null,507,"Joana",77]
[null,508,"Hamlet","Absent"]
[null,509,"Raechel",82]
[null,510,"Marx",85]

{"sheet":"For_loop-continue_on_error","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using On Error Resume Next"]
[]
[null,"ID","Name","Marks"]
[null,501,"John",88]
[null,502,"Anna",56]
[null,503,"Noah",58]
[null,504,"Jane",79]
[null,505,"Smith",{"$f":"1/0","v":{"$error":"#DIV/0!"}}]
[null,506,"Alex",88]
[null,507,"Joana",77]
[null,508,"Hamlet",{"$f":"1/0","v":{"$error":"#DIV/0!"}}]
[null,509,"Raechel",82]
[null,510,"Marx",85]

{"sheet":"For_each_loop","index":5,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Output of For Each Loop"]
[]
[null,"Hello World!"]
[null,"Hello World!"]
[null,"Hello World!"]
[null,"Hello World!"]
[null,"Hello World!"]

{"sheet":"Nested_for_loop_Table","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,3,1,8]]}
[]
[null,null,null,"Multiplication Table Using Nested For Loop"]
[]
[null,1,2,3,4,5,6,7,8,9,10]
[null,2,4,6,8,10,12,14,16,18,20]
[null,3,6,9,12,15,18,21,24,27,30]
[null,4,8,12,16,20,24,28,32,36,40]
[null,5,10,15,20,25,30,35,40,45,50]
[null,6,12,18,24,30,36,42,48,54,60]
[null,7,14,21,28,35,42,49,56,63,70]
[null,8,16,24,32,40,48,56,64,72,80]
[null,9,18,27,36,45,54,63,72,81,90]
[null,10,20,30,40,50,60,70,80,90,100]

{"sheet":"nested_for_loop_AverageMarks","index":7,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculating Average Marks of Section A"]
[]
[null,"ID","Physics","Chemistry","Mathematics"]
[null,101,75,74,94]
[null,102,81,87,96]
[null,103,67,69,78]
[null,104,64,84,94]
[null,105,63,64,84]
[null,106,69,81,97]
[null,107,63,62,87]
[null,108,83,97,97]
[null,109,73,77,78]
[null,110,88,82,82]
[]
[null,"Average of all Subjects",79.666666666666671]