{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Ordres","Requêtes","Modèle client"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Ordres","index":0,"n_rows":1,"n_cols":9,"rows_kept":1}
["DateExécution","Sens","OrdreNbr","Produit","Mise","Ouverture","Clôture","G_P","Paiement"]

{"sheet":"Requêtes","index":1,"n_rows":2,"n_cols":2,"rows_kept":2}
["Nom","Requête"]
["OrdresPassés","let\n    Source = Excel.CurrentWorkbook(){[Name=\"MaTable\"]}[Content], \n    TypesAdaptes = Table.TransformColumnTypes(Source,{\n        {\"DateExécution\", type datetime}, \n        {\"Sens\", type text}, \n        {\"OrdreNbr\", Int64.Type}, \n        {\"Produit\", type text}, \n        {\"Mise\", type number}, \n        {\"Ouverture\", type number}, \n        {\"Clôture\", type number}, \n        {\"G_P\", type text}, \n        {\"Paiement\", type number}}),\n    LignesFiltrees = Table.SelectRows(TypesAdaptes, each [DateExécution] > #datetime(|AnneeDebut|, |MoisDebut|, |JourDebut|, |HeureDebut|, |MinutesDebut|, |SecondesDebut|) and [DateExécution] < #datetime(|AnneeFin|, |MoisFin|, |JourFin|, |HeureFin|, |MinutesFin|, |SecondesFin|))\nin\n    LignesFiltrees"]

{"sheet":"Modèle client","index":2,"n_rows":4,"n_cols":6,"rows_kept":4}
[]
[]
[null,null,"Date Début","2022-02-21","Date Fin","2022-03-31"]
[null,null,"Heure limite","19:43:05"]