{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Status Bar","COLUMNS Function","Column Index for Entire Sheet","COLUMNS Function, Entire Sheet","COUNTA Function","VBA","Count Rows","Coutn Columns of Selection"],"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":"Dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Counting Number of Columns in Excel"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]

{"sheet":"Status Bar","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Status Bar"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]

{"sheet":"COLUMNS Function","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using COLUMNS Function"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"No of Columns",{"$f":"COLUMNS(B4:E4)","v":4},{"$f":"_xlfn.FORMULATEXT(C12)","v":"=COLUMNS(B4:E4)"}]
[null,"No of Columns",{"$f":"COLUMNS(B4:E10)","v":4},{"$f":"_xlfn.FORMULATEXT(C13)","v":"=COLUMNS(B4:E10)"}]

{"sheet":"Column Index for Entire Sheet","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"From Column Index"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]

{"sheet":"COLUMNS Function, Entire Sheet","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,2]]}
[]
[null,"Using COLUMNS Function"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"No of Columns in Sheet",null,{"$f":"COLUMNS(1:1)","v":16384},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=COLUMNS(1:1)"}]

{"sheet":"COUNTA Function","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,2]]}
[]
[null,"Using COUNTA Function"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"No of Columns in Sheet",null,{"$f":"COUNTA(B4:E4)","v":4},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=COUNTA(B4:E4)"}]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,2],[13,1,13,2],[12,1,12,2]]}
[]
[null,"Using VBA"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"No of Columns in Selection",null,{"$f":"NumberofColumns(B4:E4)","v":4},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=NumberofColumns(B4:E4)"}]
[null,"No of Columns in Selection",null,{"$f":"NumberofColumns(B4:E10)","v":4},{"$f":"_xlfn.FORMULATEXT(D13)","v":"=NumberofColumns(B4:E10)"}]
[null,"No of Columns in Sheet",null,{"$f":"NumberofColumns(1:1)","v":16384},{"$f":"_xlfn.FORMULATEXT(D14)","v":"=NumberofColumns(1:1)"}]

{"sheet":"Count Rows","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Counting Number of Rows"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"No of Rows in Selection",null,{"$f":"ROWS(B4:E10)","v":7},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=ROWS(B4:E10)"}]
[null,"No of Rows in Sheet",null,{"$f":"ROWS(A:A)","v":1048576},{"$f":"_xlfn.FORMULATEXT(D13)","v":"=ROWS(A:A)"}]

{"sheet":"Coutn Columns of Selection","index":8,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,2],[12,1,12,2]]}
[]
[null,"Column Number of Selected Cell"]
[]
[null,"Employee Name","Jan","Feb","Mar"]
[null,"Jesse Perry",2353,2909,2666]
[null,"Diane Carter",3872,795,1466]
[null,"Jack Bryant",1183,1864,1344]
[null,"Timothy Williams",1408,904,3742]
[null,"Shirley Powell",2342,3721,2040]
[null,"Christine Nelson",2741,1901,600]
[]
[null,"Column Number of C5",null,{"$f":"COLUMN(C5)","v":3},{"$f":"_xlfn.FORMULATEXT(D12)","v":"=COLUMN(C5)"}]
[null,"Column Number of C5:E6",null,{"$f":"COLUMN(C5:E6)","v":3},4,5,{"$f":"_xlfn.FORMULATEXT(D13)","v":"=COLUMN(C5:E6)"}]