batch cmd for call python create xlsx sheet for mercado livre

@ECHO OFF
CHCP 65001
ECHO #####################################################################################
ECHO # ## copyright gsavix 2018-2026 terms gpl V2 or later
ECHO # %DATE% AS %TIME:~0,8%
ECHO # COMPUTADOR.: %COMPUTERNAME% USUARIO.: %USERNAME%
ECHO # PASTA......: %CD%
ECHO # FAZ-PES333.BAT *** INICIO ***
ECHO # ----------------------------- TABELA  3 PRECO MERCADO LIVRE --------------------------------------
ECHO # CHAMA PES333.BAT PES333 - CLASSIFICA VP1748EX 3 PRECO MERCADO LIVRE.
ECHO #
ECHO # INFORME O NOME DO ARQUIVO PRECO MERCADO LIVRE.: AAAA-MM-DD-03-MLIVRE-VP1748EX.CSV
ECHO #
ECHO # ----------------------------- TABELA 3 PRECO BASE MERCADO LIVRE --------------------------------------------
ECHO #
ECHO # CHAMA PES333.BAT PES333 - CLASSIFICA VP1748EX PRECO MERCADO LIVRE.
ECHO #
REM  # VARIAVEL AXARQ = PASTA ONDE ESTAO ARQUIVOS
SET  AXARQ=.\ARQ\
IF [%1]==[] (GOTO P900-ERRO)
Setlocal
REM  # VERIFICA O TAMANHO DO ARGUMENTO INFORMADO AAAA-MM-DD-03-MLIVRE-VP1748EX.CSV
SET  AXFN=%1
REM  # CALCULA TAMANHO DO ARG STRLEN.CMD AGORA TEM 33 POSICOES COM 03 CODIGO DA TABELA MLIVRE
CALL strLen.cmd %AXFN% AXTA
IF   %AXTA% NEQ 33 GOTO P900-ERRO
REM  #########################################################
ls   -l %AXARQ%%1
SET  AXERRO=%ERRORLEVEL%
REM  ##########################################################
ECHO # EXISTENCIA %AXARQ%%1 STATUS %AXERRO% HORARIO %TIME:~0,8%
IF   %AXERRO% GTR 0 GOTO P900-ERRO
SET  AXDIR=.\LOG\
For /f "tokens=1-2 delims=/:" %%a in ('time /t') do (set HHMM=%%a%%b)
SET  AXAGORA=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2%T%HHMM%%TIME:~6,2%
SET  AXFNSAI=%AXDIR%LOG-PES333-%AXAGORA%.TXT
ECHO # REGISTRO.: %AXFNSAI%
PES333.BAT %AXFN% %AXFNSAI% | TEE %AXFNSAI%
ECHO # PES333.BAT STATUS = %ERRORLEVEL% HORARIO %TIME:~0,8%
ECHO # FAZ-PES333.BAT *** FIM ***
GOTO P990-FIM-SAI
REM  ####### SO EXECUTA EM CASO DE ERRO #######
:P900-ERRO
ECHO # INFORME O NOME DO ARQUIVO CONTENDO PRECO MERCADO LIVRE - TABELA 3 VERUP EXEMPLO .:
ECHO # FAZ-PES333.BAT AAAA-MM-DD-03-MLIVRE-VP1748EX.CSV
ECHO #                ----------
ECHO #                           DATA REFERENCIA DOS PRECOS LISTA DE PRECO
ECHO #                           03-MLIVRE-VP1748EX.CSV
ECHO #                           CONSTANTE 03-MLIVRE-VP1748EX.CSV
ECHO #                           PARA INDICAR TABELA MERCADO LIVRE
ECHO #
ECHO # ESSE ARQUIVO %AXARQ%%1 NAO EXISTE NA SUB PASTA %AXARQ%
ECHO # VEJA A LISTA ABAIXO DO QUE EXISTE
ECHO # SE NECESSARIO, PARA CANCELAR  E RECOMECAR USE CONTROL-C
ECHO #
ECHO # COMPUTADOR.: %COMPUTERNAME% USUARIO.: %USERNAME%
ECHO # PASTA......: %CD%
ECHO ### copyright gsavix 2018-2026 terms gpl V2 or later
DIR  %AXARQ%*03-MLIVRE*.CSV /W
ECHO # ---------------------------------------------------------------------- #
ECHO # ATENCAO O ARGUMENTO INFORMADO DEVE TER 33 CARACTERES                   #
ECHO # REFAZER A CHAMADA DO FAZ-PES333.BAT PASSANDO NOME DO ARQUIVO           #
ECHO #           CONTENTO PRECO MERCADO LIVRE - TABELA 3                      #
ECHO #           EX.: AAAA-MM-DD-03-MLIVRE-VP1748EX.CSV                       #
ECHO #                2033-01-31-03-MLIVRE-VP1748EX.CSV                       #
ECHO #                                                                        #
ECHO # ---------------------------------------------------------------------- #
GOTO P990-FIM-SAI
:P990-FIM-SAI