{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Feuil2"],"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":"Feuil1","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Uniquied","Startdate","LegacyID","BusinessEmail","TownOrCity","Country","PostalCode","linemanageruniqueid","GeographicOrganisationStructure","OrganisationalStructure","Job",null,null,{"$f":"COUNTA(N2:N10)","v":9}]
[254,"2000-04-01","ID00147","marie.dupont@pilo-ag.fr","LORAIN","MARTINIQUE",97215,1472,"MARTINIQUE","D000","A170",null,null,"EmployeeIDs",null,"LegacyID"]
[456,"2021-05-22","ID57128",null,"RIVIERE PILOTE","GUADELOUPE",97159,786,"GUADELOUPE","R405","A254",null,null,"ContactInformation",null,"BusinessEmail"]
[457,"2013-01-03","ID35972","rodrigue.nomar@pilo-af.fr","CARBET","MARTINIQUE",97214,2658,"MARTINIQUE","D001","A324",null,null,"MainPostalAddress",null,"TownOrCity"]
[458,"2018-07-16","ID59754",null,"DUCOS","MARTINIQUE",97224,2658,"MARTINIQUE","P450","A654",null,null,"MainPostalAddress",null,"Country"]
[5874,"2005-11-14","ID00258",null,"MARIN","GUYANE",97321,null,"GUYANE","D000","V987",null,null,"MainPostalAddress",null,"PostalCode"]
[2658,"2008-03-13","ID04587","elodie.depari@pilo.fr","DUCOS","MARTINIQUE",97224,2587,"MARTINIQUE","V458","A354",null,null,"Situation","{{0}}","linemanageruniqueid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Situation","{{0}}","GeographicOrganisationStructure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Situation","{{0}}","OrganisationalStructure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Situation","{{0}}","Job"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tableau des informations à mettre dans le tableau transposé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Peut être allongé si besoin était, modifier alors la plage de la formule en N1 "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Alt+F8 pour faire afficher les macros "]
[null,null,null,null,null,null,null,null,null,null,null,"ou Developpeur dans le ruban - Macros"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"et faire executer la macro transpo"]
[null,null,null,null,null,null,null,null,null,null,null,"le tableau sera composé en Feuil2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Pour voir le code de la macro commenté :"]
[null,null,null,null,null,null,null,null,null,null,null,"clic droit sur l'onglet de cette feuille puis Visualiser le code"]
[null,null,null,null,null,null,null,null,null,null,null,"Aller dans Module 1"]

{"sheet":"Feuil2","index":1,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["uniquied","startdate","enddate","dataset","key","field","value"]