{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guide","Exemple","Feuil4","Feuil5","Feuil6"],"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":"Guide","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,3,2],[6,0,9,0],[6,1,9,1],[6,2,9,2],[19,2,20,2],[10,0,13,0],[10,1,13,1],[10,2,13,2],[14,0,16,0],[14,1,16,1],[14,2,16,2],[37,0,38,0],[37,1,38,1],[37,3,38,3],[0,0,0,3],[23,0,24,0],[23,1,24,1],[23,2,24,2],[27,0,29,0],[27,1,29,1],[31,0,33,0],[31,1,33,1],[17,0,18,0],[17,1,18,1],[17,2,18,2],[19,0,20,0],[19,1,20,1]]}
["A Quick Guide to the VBA ArrayList"]
["Task","Method","Parameters","Examples"]
["Access item","Item","index - long integer","value = list.Item(0)                             > En base 0"]
[null,null,null,"value = list.Item(3)"]
["Access item added last","Item","index - long integer","value = list.Item(list.Count - 1)"]
["Access item added first","Item","index - long integer","value = list.Item(0)               > value = list.Item(0)(0) si c'est un Array() à pls dimensions"]
["Access all items (For Each)","N/A","N/A","Dim element As Variant"]
[null,null,null,"For Each element In fruit"]
[null,null,null,"Debug.Print element"]
[null,null,null,"Next element"]
["Access all items (For)","Item","index - long integer","Dim i As Long"]
[null,null,null,"For i = 0 To list.Count - 1"]
[null,null,null,"Debug.Print list.item(i)"]
[null,null,null,"Next i"]
["Add item","Add","object or value","list.Add \"Apple\"                                 > Peut aussi être un Array(…, …, …)"]
[null,null,null,"list.Add \"Pear\"                                  > Accepte les doublons"]
[null,null,null,"list.Item(0)=\"Banana\"                        > Peut modifier un élément de la liste"]
["Copy ArrayList to another ArrayList","Clone","None","Dim list2 As Object"]
[null,null,null,"Set list2 = list.Clone"]
["Copy to Array","ToArray","None","Dim arr As Variant"]
[null,null,null,"arr = list.ToArray"]
["Copy to a range (row)","ToArray","None","Sheet1.Range(\"A1\").Resize(1, list.Count).Value = list.ToArray"]
["Copy to a range (column)","ToArray","None","Sheet1.Range(\"A3\").Resize(list.Count, 1).Value = WorksheetFunction.Transpose(list.ToArray)"]
["Create","CreateObject","\"System.Collections.ArrayList\"","Dim list As Object"]
[null,null,null,"Set list = CreateObject(\"System.Collections.ArrayList\")"]
["Declare","N/A","N/A","Dim list As Object"]
["Find - check if item exists","Contains","item to find","list.Contains(\"Apple\")                              > Sensible à la casse"]
["Find the position of an item in the ArrayList","IndexOf","1. Item to find.","Dim index As Long"]
[null,null,"2. Position to start searching from.","' Search from 0 position"]
[null,null,null,"index = fruit.IndexOf(\"Pear\", 0)                 > -1 si non trouvé"]
["Get number of items","Count","None","totalElements = list.Count"]
["Insert Item","Insert","1. Index - position to insert at.","list.Insert 0, \"Peach\" ' First"]
[null,null,"2 Value - object or value to insert.","list.Insert 1, \"Banana\" ' Second"]
[null,null,null,"list.Insert list.Count, \"Orange\" ' Last"]
["Remove all Items","Clear","None","list.Clear"]
["Remove item at position","RemoveAt","Index - position where the item is","list.RemoveAt 0"]
["Remove item by name","Remove","Item - the item to remove from the ArrayList","list.Remove \"Apple\""]
["Remove a range of Items","RemoveRange","1. Index - starting postion.","list.RemoveRange 1,3"]
[null,null,"2. Count - the number of items to remove."]
["Reverse the list","Reverse","None","list.Reverse"]
["Sort in ascending","Sort","None","list.Sort                            > Ne peut pas trier les Array(), Non sensible à la casse\nSur certains de mes tests le tri n'était pas bon (noms de famille avec des tirets, des quotes)."]

{"sheet":"Exemple","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nom Famille","Prénom","Note","Dates","Commentaire",null,null,"Nom Famille","Prénom","Nb","Moyenne"]
[null,null,null,null,null,null,null,"CROCHE","Sarah",3,13.9]
[null,null,null,null,null,null,null,"DEFER","Jean",3,16.3]
[null,null,null,null,null,null,null,"DEFER","Phil'Or",2,12.8]
[null,null,null,null,null,null,null,"TERRIEUR","Alain",2,10.5]
[null,null,null,null,null,null,null,"TERRIEUR","Alex",3,17.2]
[null,null,null,null,null,null,null,"TINE","Clément",3,8.4]

{"sheet":"Feuil4","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Note","Dates","Commentaire","Id"]
["CROCHE","Sarah",{"$f":"11+0.7","v":11.7},"2024-03-01","Très bien",1]
["DEFER","Jean",11,"2024-03-01","Peut mieux faire",2]
["DEFER","Phil'Or",17.5,"2024-03-01","Excellent",3]
["TERRIEUR","Alain",14,"2024-03-01","Très bien",4]
["TERRIEUR","Alex",17.5,"2024-03-01","Manque de régularité",5]
["TINE","Clément",7.7,"2024-03-01","Doit fournir des efforts",6]

{"sheet":"Feuil5","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["CROCHE","Sarah",15,"Très bien","2024-03-18"]
["DEFER","Jean",19,"Très bien","2024-03-18"]
["DEFER","Phil'Or",8,"Doit fournir des efforts","2024-03-18"]
["TERRIEUR","Alain",7,"Doit fournir des efforts","2024-03-18"]
["TERRIEUR","Alex",17,"Manque de régularité","2024-03-18"]
["TINE","Clément",9,"Manque de régularité","2024-03-18"]

{"sheet":"Feuil6","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Nom Famille","Prénom","Note","Date","Commentaire"]
["CROCHE","Sarah",15,"2024-04-09"]
["DEFER","Jean",19,"2024-04-09"]
["DEFER","Phil'Or",0,"2024-04-09"]
["TERRIEUR","Alain",0,"2024-04-09"]
["TERRIEUR","Alex",17,"2024-04-09"]
["TINE","Clément",8.5,"2024-04-09"]