import time
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
import random
import pandas as pd
from selenium.webdriver import Chrome
from selenium.webdriver.common.by import By
df = pd.read_excel("1.xlsx", dtype=str)
#print(df.head())
driver = Chrome()
for idx, row in df.iterrows():
url = "http://www.sefaz.to.gov.br/dare/servlet/hnetccwkda"
driver.get(url)
城市 = row["城市"]
州 = row['州']
公司号 = row["公司号"]
公司名 = row['公司名']
金额 = row["金额"]
罚款 = row["罚款"]
发票号 = row["发票号"]
print(城市, 州, 公司号, 公司名, 金额, 罚款, 发票号)
print(type(公司号))
driver.find_element(By.XPATH, '//*[@id="_CECPFCNPJ"]').send_keys(公司号)
time.sleep(0.1)
driver.find_element(By.XPATH, '//*[@id="TABLE2"]/tbody/tr[5]/td/p/input').click()
time.sleep(0.1)
#Nome / Razão Social
driver.find_element(By.XPATH, '//*[@id="_DRERAZSOC"]').clear()
driver.find_element(By.XPATH, '//*[@id="_DRERAZSOC"]').send_keys(公司名)
time.sleep(0.1)
#Município Receita
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[5]/td[2]/font/select').click()
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[5]/td[2]/font/select').send_keys('PALMAS - 1721000')
#Município Origem
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[4]/td[2]/select').click()
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[4]/td[2]/select').send_keys(州)
time.sleep(2)
#Código Receita
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[12]/td[2]/font/select').click()
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[12]/td[2]/font/select').send_keys('116')
time.sleep(1)
#Data Vencimento:
driver.find_element(By.XPATH, '//*[@id="_DREDTAVEN"]').send_keys('04/11/2022')
time.sleep(0.1)
#Valor da Receita:
driver.find_element(By.XPATH, '//*[@id="_DREVLRPRI"]').click()
driver.find_element(By.XPATH, '//*[@id="_DREVLRPRI"]').send_keys(金额)
time.sleep(0.1)
#Período referência
driver.find_element(By.XPATH, '//*[@id="_DREREFCHAR"]').clear()
driver.find_element(By.XPATH, '//*[@id="_DREREFCHAR"]').send_keys('11/2022')
time.sleep(0.1)
#Multa:
driver.find_element(By.XPATH, '//*[@id="_DREVLRMLT"]').clear()
driver.find_element(By.XPATH, '//*[@id="_DREVLRMLT"]').send_keys(罚款)
time.sleep(0.1)
#Município Origem
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[4]/td[2]/font/select').click()
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[4]/td[2]/font/select').send_keys(城市)
time.sleep(1)
#//*[@id="TABLE1"]/tbody/tr[22]/td[5]/input
driver.find_element(By.XPATH, '//*[@id="TABLE1"]/tbody/tr[22]/td[5]/input').click()
time.sleep(0.1)
# // *[ @ id = "_DRENFECHV"]
driver.find_element(By.XPATH, '//*[@id="_DRENFECHV"]').click()
driver.find_element(By.XPATH, '//*[@id="_DRENFECHV"]').send_keys('00000000000000000000000000000000000000000000')
#Observação:
driver.find_element(By.XPATH, '//*[@id="TABLE3"]/tbody/tr/td[2]/textarea').clear()
driver.find_element(By.XPATH, '//*[@id="TABLE3"]/tbody/tr/td[2]/textarea').send_keys(发票号)
time.sleep(0.1)
#//*[@id="TABLE2"]/tbody/tr[8]/td/p/input[1]
driver.find_element(By.XPATH, '//*[@id="TABLE2"]/tbody/tr[8]/td/p/input[1]').click()
time.sleep(0.8)
alerta = driver.switch_to.alert
alerta.accept()
time.sleep(1)
运行正常但是点击提交的时候PDF默认打开不保存我想让他默认保存该怎么办