You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
414 B
15 lines
414 B
# Manipulando arquivos de Excell
|
|
import pandas as pd
|
|
from time import sleep
|
|
arquivo = 'Chatbots-Controle.xlsx'
|
|
aba = 'Em andamento'
|
|
header = 0
|
|
file = pd.read_excel(arquivo, sheet_name=aba, header=header)
|
|
|
|
#print(file['PROJETO'])
|
|
cod = int(input('Código do Projeto: '))
|
|
|
|
for c in range(0, len(file)):
|
|
#print(file['CLIENTE'][c])
|
|
if file['PROJETO'][c] == cod:
|
|
print(f'Cliente: {file["CLIENTE"][c]}')
|
|
|