python win32com excel object pyi file
git clone https://github.com/windwiny/oletype
cd oletype
# download web page, generate enumeration, and class method, property comment json
# will output excel.info.json
ruby downapi.rb
# python inspect objecty, list win32com objects methods, and parameters
# method return type may not show, find from download api
# read excel.info.json file,
# output to oletype/excel.py oletype/excel.pyi
python gen_win32com.py
python demo\demo1.pypip wheel ./
dir *.whl
pip install oletype-0.4.0-py3-none-any.whl --force-reinstall
use vscode open demo.py file, let coding
let var type
import win32com.client
from oletype import excel
exapp: excel.Application = None
exapp = win32com.client.Dispatch('excel.application')
exapp.Visible = True
exapp.Workbooks.Add()
wb: excel._Workbook = exapp.ActiveWorkbook
ws = exapp.ActiveSheet
input var and dot, vscode will show quick info and method signatures.