# As seguintes ações obtêm os dados da planilha.
Folder.GetFiles Folder: pasta_planilha 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=> planilha_excel
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: planilha_excel[0] Visible: True ReadOnly: False Instance=> excel
IF (OCR.IfTextOnScreen.TextOnScreenExistsWithWindowsOcr TextToFind: $'''Reabrir''' IsRegex: False WindowsOcrLanguage: OCR.WindowsOcrLanguage.Portuguese SearchForTextOn: OCR.SearchTarget.EntireScreen ImageWidthMultiplier: 1 ImageHeightMultiplier: 1) THEN
    MouseAndKeyboard.MoveMouseToTextOnScreenWithOCR.WaitForTextToAppearAndMoveMouseToTextOnScreenWithWindowsOcr TextToFind: $'''Reabrir''' IsRegEx: False WindowsOcrLanguage: MouseAndKeyboard.WindowsOcrLanguage.Portuguese Occurence: 1 SearchForTextOn: MouseAndKeyboard.SearchTarget.EntireScreen ImageWidthMultiplier: 1 ImageHeightMultiplier: 1 MovementStyle: MouseAndKeyboard.MovementStyle.Instant Timeout: 5 PositionRelativeToText: MouseAndKeyboard.PositionOnImage.MiddleCenter OffsetX: 0 OffsetY: 0
END
Excel.GetFirstFreeColumnRow Instance: excel FirstFreeColumn=> coluna_livre FirstFreeRow=> linha_livre
SET linha_planilha TO 2
/# Para as próximas ações, é necessário que algumas colunas estejam nomeadas da seguinte forma:

Empreendedor
Protocolo
Processo
Status
Notificação
Plataforma#/
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Empreendedor''' MatchCase: False MatchEntireCellContents: True SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_empreendedor
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Nome do projeto''' MatchCase: False MatchEntireCellContents: True SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_nome_projeto
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Processo''' MatchCase: False MatchEntireCellContents: True SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_processo_sei
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Status''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_status
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Motivos de reprovação''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_reprovacao
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Notificação''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_notificacao
Excel.FindAndReplace.FindSingle Instance: excel TextToFind: $'''Plataforma''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Columns FoundColumnIndex=> coluna_robo