원하는 기능들 웹에서 코드 긁어다 원하는 기능 구현될때까지 코드 수정하여 완성이 되었습니다.

(엑셀파일의 내용 읽어서 mssql 서버에 올리는 단순 기능)

11Kb밖에 안 되던 소스가 50Mb에 육박하는 실행파일이 되었습니다... @@;;;

(import 항목들 때문에 덩치가 커진거 아닌가 단순 추측 합니다만... 해결 방법을 모르겠네요...)

 

실행파일 변환은 다음 명령을 사용하였습니다.

 

 

 

 

 

 

* 덩치가 왜 이리 커졌지요...?

* 덩치를 줄일 수 있는 방법이 뭐가 있을까요...?

PS D:\pytheon-work> pyinstaller -w -F -n usuj_car_update.exe usuj_car_update.py
158 INFO: PyInstaller: 4.0.dev0+96897fc78d
158 INFO: Python: 3.8.1
162 INFO: Platform: Windows-10-10.0.18362-SP0
175 INFO: wrote D:\pytheon-work\usuj_car_update.exe.spec
190 INFO: UPX is not available.
197 INFO: Extending PYTHONPATH with paths
['D:\\pytheon-work', 'D:\\pytheon-work']
197 INFO: checking Analysis
273 INFO: Building because D:\pytheon-work\usuj_car_update.py changed
273 INFO: Initializing module dependency graph...
286 INFO: Caching module graph hooks...
317 INFO: Analyzing base_library.zip ...
4082 INFO: Processing pre-find module path hook   distutils
4088 INFO: distutils: retargeting to non-venv dir 'c:\\python38\\lib'
6579 INFO: Caching module dependency graph...
6826 INFO: running Analysis Analysis-00.toc
6839 INFO: Adding Microsoft.Windows.Common-Controls to dependent assemblies of final executable
  required by c:\python38\python.exe
7242 INFO: Analyzing D:\pytheon-work\usuj_car_update.py
8530 INFO: Processing pre-find module path hook   site
8533 INFO: site: retargeting to fake-dir 'c:\\python38\\lib\\site-packages\\PyInstaller\\fake-modules'
10122 INFO: Processing pre-safe import module hook   setuptools.extern.six.moves
15893 INFO: Processing pre-safe import module hook   six.moves
21370 INFO: Processing module hooks...
21370 INFO: Loading module hook "hook-distutils.py"...
21379 INFO: Loading module hook "hook-encodings.py"...
21558 INFO: Loading module hook "hook-lib2to3.py"...
21587 INFO: Loading module hook "hook-numpy.core.py"...
21836 INFO: Loading module hook "hook-numpy.py"...
21840 INFO: Loading module hook "hook-openpyxl.py"...
21890 INFO: Loading module hook "hook-pandas.py"...
23530 INFO: Loading module hook "hook-pkg_resources.py"...
24140 INFO: Processing pre-safe import module hook   win32com
Traceback (most recent call last):
  File "<string>", line 2, in <module>
ModuleNotFoundError: No module named 'win32com'
24260 INFO: Processing pre-safe import module hook   win32com
Traceback (most recent call last):
  File "<string>", line 2, in <module>
ModuleNotFoundError: No module named 'win32com'
24542 WARNING: Hidden import "pkg_resources.py2_warn" not found!
24547 INFO: Excluding import '__main__'
24558 INFO:   Removing import of __main__ from module pkg_resources
24560 INFO: Loading module hook "hook-pymssql.py"...
24568 INFO: Loading module hook "hook-PyQt5.py"...
25066 WARNING: Hidden import "sip" not found!
25070 INFO: Loading module hook "hook-PyQt5.QtCore.py"...
25350 INFO: Loading module hook "hook-PyQt5.QtWidgets.py"...
26162 INFO: Loading module hook "hook-pytz.py"...
26501 INFO: Loading module hook "hook-setuptools.py"...
27393 INFO: Loading module hook "hook-sqlite3.py"...
27616 INFO: Loading module hook "hook-sysconfig.py"...
27620 INFO: Loading module hook "hook-xml.dom.domreg.py"...
27622 INFO: Loading module hook "hook-xml.etree.cElementTree.py"...
27623 INFO: Loading module hook "hook-xml.py"...
27625 INFO: Loading module hook "hook-_mssql.py"...
27627 INFO: Loading module hook "hook-_tkinter.py"...
28037 INFO: checking Tree
28326 INFO: checking Tree
28400 INFO: Loading module hook "hook-PyQt5.QtGui.py"...
28920 INFO: Looking for ctypes DLLs
29005 INFO: Analyzing run-time hooks ...
29017 INFO: Including run-time hook 'pyi_rth__tkinter.py'
29027 INFO: Including run-time hook 'pyi_rth_multiprocessing.py'
29032 INFO: Including run-time hook 'pyi_rth_pkgres.py'
29037 INFO: Including run-time hook 'pyi_rth_pyqt5.py'
29069 INFO: Looking for dynamic libraries
35235 INFO: Looking for eggs
35235 INFO: Using Python library c:\python38\python38.dll
35238 INFO: Found binding redirects:
[]
35252 INFO: Warnings written to D:\pytheon-work\build\usuj_car_update.exe\warn-usuj_car_update..exe.txt
35443 INFO: Graph cross-reference written to D:\pytheon-work\build\usuj_car_update.exe\xref-usuuj_car_update.exe.html
35518 INFO: checking PYZ
35533 INFO: Building because toc changed
35533 INFO: Building PYZ (ZlibArchive) D:\pytheon-work\build\usuj_car_update.exe\PYZ-00.pyz   
37050 INFO: Building PYZ (ZlibArchive) D:\pytheon-work\build\usuj_car_update.exe\PYZ-00.pyz commpleted successfully.
37081 INFO: checking PKG
37120 INFO: Building because toc changed
37121 INFO: Building PKG (CArchive) PKG-00.pkg
60876 INFO: Building PKG (CArchive) PKG-00.pkg completed successfully.
60922 INFO: Bootloader c:\python38\lib\site-packages\PyInstaller\bootloader\Windows-64bit\runw..exe
60923 INFO: checking EXE
60985 INFO: Building because toc changed
60986 INFO: Building EXE from EXE-00.toc
60996 INFO: Appending archive to EXE D:\pytheon-work\dist\usuj_car_update.exe
61093 INFO: Building EXE from EXE-00.toc completed successfully.
PS D:\pytheon-work>