Folder.GetFiles Folder: caminho_boletim FileFilter: $'''*.xlsx''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> arquivo_boletim Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: arquivo_boletim[0] Visible: True ReadOnly: False Instance=> planilha_bens WAIT 2 IF Contains(planilha_bens, $'''Habilitar Conteúdo''', True) THEN UIAutomation.Click.Click Element: appmask['Window \'BEM - 2024 - Item de Custo - SETEMBRO 2024 - Excel\'']['Button \'Habilitar Conteúdo\''] ClickType: UIAutomation.ClickType.LeftClick MousePositionRelativeToElement: UIAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 END MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: planilha_bens TextToSend: $'''{Alt}coui{Return}''' DelayBetweenKeystrokes: 100 SendTextAsHardwareKeys: False MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: planilha_bens TextToSend: $'''{Alt}coui{Down}{Down}{Return}''' DelayBetweenKeystrokes: 100 SendTextAsHardwareKeys: False Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: planilha_bens Name: $'''Relatório de Composição''' MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: planilha_bens TextToSend: $'''{Control}({T}){Alt}ckl''' DelayBetweenKeystrokes: 100 SendTextAsHardwareKeys: False # ABRIR RELATÓRIO GERADO Folder.GetFiles Folder: caminho_relatorio FileFilter: $'''*.xlsx''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> arquivo_relatorio Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: arquivo_relatorio[0] Visible: True ReadOnly: False Instance=> planilha_relatorio IF Contains(planilha_bens, $'''Habilitar Conteúdo''', True) THEN UIAutomation.Click.Click Element: appmask['Window \'BEM - 2024 - Item de Custo - SETEMBRO 2024 - Excel\'']['Button \'Habilitar Conteúdo\''] ClickType: UIAutomation.ClickType.LeftClick MousePositionRelativeToElement: UIAutomation.RectangleEdgePoint.MiddleCenter OffsetX: 0 OffsetY: 0 END MouseAndKeyboard.SendKeys.FocusAndSendKeysByInstanceOrHandle WindowInstance: planilha_relatorio TextToSend: $'''{Control}({T})''' DelayBetweenKeystrokes: 100 SendTextAsHardwareKeys: False WAIT 2 Excel.CopyCellsFromExcel.CopyAllCells Instance: planilha_relatorio WAIT 2 Excel.SelectCellsFromExcel.SelectNamedCell Instance: planilha_bens CellName: $'''A1''' Excel.PasteCellsToExcel.Paste Instance: planilha_bens Excel.GetFirstFreeColumnRow Instance: planilha_bens FirstFreeColumn=> coluna_livre FirstFreeRow=> linha_livre Excel.CloseExcel.Close Instance: planilha_relatorio # [ControlRepository][PowerAutomateDesktop] { "ControlRepositorySymbols": [ { "IgnoreImagesOnSerialization": false, "Repository": "{\r\n \"Screens\": [\r\n {\r\n \"Controls\": [\r\n {\r\n \"AutomationProtocol\": \"uia3\",\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Button\",\r\n \"InstanceId\": \"e08b3a3b-49ad-4586-b603-bd9171d027b1\",\r\n \"Name\": \"Button 'Habilitar Conteúdo'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL2\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Process\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Pane 'EXCEL2'\",\r\n \"Tag\": \"pane\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"MsoCommandBar\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 1\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Tool Bar 'MsoCommandBar'\",\r\n \"Tag\": \"toolbar\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"MsoWorkPane\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Business Bar\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Process\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Pane 'Business Bar'\",\r\n \"Tag\": \"pane\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"NUIPane\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Process\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Pane 'NUIPane'\",\r\n \"Tag\": \"pane\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"NetUIHWNDElement\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Process\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Pane 'NetUIHWNDElement'\",\r\n \"Tag\": \"pane\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"NetUInetpane\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Barras de Mensagens\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"UI Custom 'Barras de Mensagens'\",\r\n \"Tag\": \"custom\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"NetUIElement\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Aviso de Segurança\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Group 'Aviso de Segurança'\",\r\n \"Tag\": \"group\"\r\n },\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"NetUISimpleButton\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"IsDefault\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": false\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"Habilitar Conteúdo\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Button 'Habilitar Conteúdo'\",\r\n \"Tag\": \"button\"\r\n }\r\n ],\r\n \"Ignore\": false,\r\n \"ImageSelector\": null,\r\n \"IsCustom\": false,\r\n \"IsImageBased\": false,\r\n \"IsWindowsInstance\": false,\r\n \"Name\": \"Default Selector\",\r\n \"Properties\": []\r\n }\r\n ],\r\n \"Tag\": \"button\",\r\n \"ScreenshotPath\": \"controlRepo-screenshots\\\\27521989-a700-48c7-9cd7-c93e5ccecae7.png\"\r\n }\r\n ],\r\n \"Handle\": {\r\n \"value\": 0\r\n },\r\n \"ProcessName\": null,\r\n \"ScreenShot\": null,\r\n \"ElementTypeName\": \"Window\",\r\n \"InstanceId\": \"22e619e9-0997-475d-bc30-51bdc2df70bf\",\r\n \"Name\": \"Window 'BEM - 2024 - Item de Custo - SETEMBRO 2024 - Excel'\",\r\n \"SelectorCount\": 1,\r\n \"Selectors\": [\r\n {\r\n \"CustomSelector\": null,\r\n \"Elements\": [\r\n {\r\n \"Attributes\": [\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Class\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"XLMAIN\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Enabled\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Id\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"\"\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Name\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"BEM - 2024 - Item de Custo - SETEMBRO 2024 - Excel\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": true,\r\n \"Name\": \"Ordinal\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": 0\r\n },\r\n {\r\n \"Ignore\": false,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Process\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": \"EXCEL\"\r\n },\r\n {\r\n \"Ignore\": true,\r\n \"IsOrdinal\": false,\r\n \"Name\": \"Visible\",\r\n \"Operation\": \"EqualTo\",\r\n \"Value\": true\r\n }\r\n ],\r\n \"CustomValue\": null,\r\n \"Ignore\": false,\r\n \"Name\": \"Window 'BEM - 2024 - Item de Custo - SETEMBRO 2024 - Excel'\",\r\n \"Tag\": \"window\"\r\n }\r\n ],\r\n \"Ignore\": false,\r\n \"ImageSelector\": null,\r\n \"IsCustom\": false,\r\n \"IsImageBased\": false,\r\n \"IsWindowsInstance\": false,\r\n \"Name\": \"Default Selector\",\r\n \"Properties\": []\r\n }\r\n ],\r\n \"Tag\": \"window\",\r\n \"ScreenshotPath\": \"controlRepo-screenshots\\\\657d0805-51d7-4e96-a738-cb00c4f489bd.png\"\r\n }\r\n ],\r\n \"Version\": 1\r\n}", "ImportMetadata": { "DisplayName": "Computador local", "ConnectionString": "", "Type": "Local", "DesktopType": "local" }, "Name": "appmask" } ], "ImageRepositorySymbol": { "Repository": "{\r\n \"Folders\": [],\r\n \"Images\": [],\r\n \"Version\": 1\r\n}", "ImportMetadata": {}, "Name": "imgrepo" }, "ConnectionReferences": [] }