{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Clients","Produits","Commandes","Vendu"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":"Clients","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Noms Prénoms","Adresse","Ville","Téléphone"]
["Nom1 Prénom1","adresse1","ville1",123456789]
["Nom2 Prenom2","Adresse2","ville2",213456789]
["Nom3 Prénom3","adresse3","ville3",303456789]
["Nom4 Prenom4","adresse4","ville4",493456789]
["Nom5 Prénom5","adresse5","ville5",583456789]
["Nom9 Prénom9","adresse 9","ville 9",912457896]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Commande et gestion de commande par article - Comment Ça Marche (commentcamarche.net)"]

{"sheet":"Produits","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Produits","en commande"]
["dinde",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":0}]
["foie gras",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":2}]
["douze escargots",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":0}]
["produit4",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":0}]
["produit5",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":12}]
["produit9",{"$f":"SUMIFS(TCommandes[Quantité],TCommandes[Produits],TProduits[[#This Row],[Produits]])","v":0}]

{"sheet":"Commandes","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Date","Numero","Noms Prénoms","Produits","Quantité","Commentaire"]
["2020-11-28T05:15:00",3,"Nom5 Prénom5","produit5",5]
["2020-12-01T07:00:00",2,"Nom2 Prenom2","foie gras",2]
["2020-12-04T06:05:00",5,"Nom5 Prénom5","produit5",2]
["2020-12-01T10:20:00",4,"Nom4 Prénom4","produit5",5]

{"sheet":"Vendu","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Date","Numero","Noms Prénoms","Produits","Quantité"]
["2020-11-29T06:46:00",5,"Nom4 Prenom4","produit4",1.2]
["2020-11-29T06:46:00",5,"Nom4 Prenom4","douze escargots",10]
["29/11/2020 07:28",8,"Nom2 Prenom2","foie gras",2]
["29/11/2020 07:28",8,"Nom2 Prenom2","douze escargots",2]
["28/11/2020 05:56",4,"Nom1 Prénom1","douze escargots",3]
["28/11/2020 05:56",4,"Nom1 Prénom1","foie gras",2]
["25/11/2020 07:11",7,"Nom1 Prénom1","foie gras",1]
["2020-11-27T10:15:00",1,"Nom2 Prenom2","foie gras",3]
["2020-11-27T15:10:00",2,"Nom3 Prénom3","douze escargots",5]
["2020-11-28T05:15:00",3,"Nom5 Prénom5","produit5",5]
["2020-11-28T05:15:00",3,"Nom5 Prénom5","produit5",5]
["29/11/2020 06:46",6,"Nom4 Prenom4","dinde",1]
["29/11/2020 06:46",6,"Nom4 Prenom4","douze escargots",5]
["29/11/2020 06:46",6,"Nom4 Prenom4","foie gras",2]
["2020-12-01T07:00:00",2,"Nom2 Prenom2","douze escargots",2]
["2020-12-01T07:00:00",2,"Nom2 Prenom2","foie gras",2]
["2020-12-01T07:00:00",2,"Nom2 Prenom2","dinde",1]
["2020-12-01T07:00:00",2,"Nom2 Prenom2","produit5",2]