본문 바로가기

Python15

paramiko ssh 접속 개선판 (수정3) import osimport syssys.path.append(os.getcwd() + "\lib")import paramikofrom paramiko import SSHException, AuthenticationExceptionimport datetimeimport timeimport pandas as pdimport threadingimport PySimpleGUI as psgfrom queue import Queue        # 엑셀 읽어오기def xlsx_read(pd_name):       pd_xlsx = pd.read_excel(pd_name, engine = "openpyxl", sheet_name=0)        try:        pd_name = pd_xlsx['hostnam.. 2024. 10. 18.
Fortigate 방화벽 전체 로그를 이용한 정책 추출 필요한 모듈: PySimpleGUI, pandas, openpyxl from __future__ import absolute_import from __future__ import division from __future__ import print_function from os import path  import io import os import sys sys.path.append(os.getcwd() + "\lib") import re import csv import shutil import PySimpleGUI as psg # Python 2 and 3 compatibility if (sys.version_info     fd_read_options = 'r'     fd_write_options =.. 2024. 7. 25.
netmiko cisco telnet 접속 프로그램 (수정2) (신버전)import osimport syssys.path.append(os.getcwd() + "\lib")import pandas as pdfrom netmiko import SSHDetect, ConnectHandler, NetmikoAuthenticationException, NetmikoTimeoutExceptionfrom paramiko.ssh_exception import SSHExceptionimport PySimpleGUI as psgimport datetimeimport threadingimport concurrent.futuresimport time    # 엑셀 읽어오기def xlsx_read(pd_name):       pd_xlsx = pd.read_excel(pd_name, e.. 2024. 1. 24.
netmiko ssh 접속 프로그램 (수정2) (신버전)import osimport syssys.path.append(os.getcwd() + "\lib")import pandas as pdfrom netmiko import SSHDetect, ConnectHandler, NetmikoAuthenticationException, NetmikoTimeoutExceptionfrom paramiko.ssh_exception import SSHExceptionimport PySimpleGUI as psgimport datetimeimport threadingimport concurrent.futuresimport time# 엑셀 읽어오기def xlsx_read(pd_name):       pd_xlsx = pd.read_excel(pd_name, engin.. 2024. 1. 24.