{"project":{"profile":{"name":"pivotTable","description":""},"commands":[{"father":"readxlsx","command":"{\"file_path\":\"C:/Users/Rocketbot/Desktop/Libro1.xlsx\"}","option":"","var":"","index":0,"group":"excel","execute":2,"if":"","children":[],"else":[],"id":"7c6f4082-08cf-519a-b8e2-8a7eb7fedbb2","mode_live":true,"getvar":"","screenshot":"","img":"","message":"readxlsx  {\"file_path\":\"C:/Users/Rocketbot/Desktop/Libro1.xlsx\"}","extra":true,"result":"True"},{"father":"module","command":"{\"module_name\":\"PivotTableExcel\",\"module\":\"createPivotTable\",\"data\":\"Hoja1!A1:C7\",\"destination\":\"Hoja2!E3\",\"tableName\":\"PivotTableName\"}","option":"","var":"","index":1,"group":"scripts","execute":2,"if":"","children":[],"else":[],"id":"5c82f9d1-ce6f-e7f5-0935-cd44959b5dcc","mode_live":true,"getvar":"","screenshot":"","img":"","message":"module  {\"module_name\":\"PivotTableExcel\",\"module\":\"createPivotTable\",\"data\":\"Hoja1!A1:C7\",\"destination\":\"Hoja2!E3\",\"tableName\":\"PivotTableName\"}","extra":[],"result":"True"},{"father":"module","command":"{\"module_name\":\"PivotTableExcel\",\"module\":\"addField\",\"sheet\":\"Hoja1\",\"table\":\"pivotTableName\",\"option_\":\"xlRowField\",\"data\":\"Nombre\"}","option":"","var":"","index":2,"group":"scripts","execute":2,"if":"","children":[],"else":[],"id":"1920cb12-64b9-ba88-3221-c74a89841852","mode_live":true,"getvar":"","extra_data":null,"screenshot":"","img":""},{"father":"module","command":"{\"module_name\":\"PivotTableExcel\",\"module\":\"refreshPivot\",\"sheet\":\"Hoja2\",\"table\":\"PivotTableName\"}","option":"","var":"","index":3,"group":"scripts","execute":2,"if":"","children":[],"else":[],"id":"6199d2e4-03c0-6d47-9d70-fc3599bb38cc","mode_live":true,"getvar":"","screenshot":"","img":""},{"father":"module","command":"{\"module_name\":\"PivotTableExcel\",\"module\":\"filter\",\"sheet\":\"Hoja2\",\"table\":\"pivotTableName\",\"filter\":\"Pais\",\"value\":\"mex,chi\"}","option":"","var":"","index":4,"group":"scripts","execute":2,"if":"","children":[],"else":[],"id":"fefd1820-7dac-4f4f-d511-01354579bc04","mode_live":true,"getvar":"","screenshot":"","img":"","message":"module  {\"module_name\":\"PivotTableExcel\",\"module\":\"filter\",\"sheet\":\"Hoja2\",\"table\":\"pivotTableName\",\"filter\":\"Pais\",\"value\":\"mex,chi\"}","extra":[],"result":"True"}],"vars":[],"ifs":[]}}