pip install pywin32
pip install xlrd

import win32api,win32con,time,xlrd

"""
Author:NoamaNelson
Date:2019-11-26
Discription:Python sets the resolution of Windows computer graphics card and obtains the resolution
"""

book1 = xlrd.open_workbook('常見分辨率.xlsx') # 打開表格
q = book1.sheet_by_index(0) # 使用索引的方式獲取sheet1工作簿
i = 0
while(i<=5):
    print("第%d次設置"%i)
    mwidth = str(q.cell_value(i+1,0))    # 獲取單元格中的值
    nwidth = mwidth.split(".")[0]    # 獲取的值為float，轉換成字符串然后進行分割取整
    WidthSet = int(nwidth) # 從表格中獲取的分辨率寬的值
    #print(WidthSet)

    mhigth = str(q.cell_value(i+1,1))    # 獲取單元格中的值
    nhigth = mhigth.split(".")[0]    # 獲取的值為float，轉換成字符串然后進行分割取整
    HeightSet = int(nhigth)    # 從表格中獲取的分辨率寬的值
    #print(HeightSet)
    
    ResoLutionSet = win32api.EnumDisplaySettings(None, 0) # 調用win32api接口,獲取顯示設備信息

    ResoLutionSet.PelsHeight = HeightSet # 設置分辨率高
    ResoLutionSet.PelsWidth = WidthSet # 設置分辨率寬
    print("設置的分辨率寬: %d, 設置的分辨率高: %d, 即設置的分辨率為：%d x %d" % (WidthSet, HeightSet, WidthSet, HeightSet))

    ResoLutionSet.BitsPerPel = 32 # 顯示設備的顏色分辨率
    ResoLutionSet.DisplayFixedOutput = 2 # 設置分辨率后拉伸畫面，否則切換到小分辨率時，屏幕只在中間一小塊

    if (win32api.ChangeDisplaySettings(ResoLutionSet, 0)) == 0: # DISP_CHANGE_SUCCESSFUL
        win32api.ChangeDisplaySettings(ResoLutionSet, 0) # 設置生效
    else:
        win32api.ChangeDisplaySettings(None, 0) # 恢復默認

    screenNum = win32api.GetSystemMetrics(win32con.SM_CMONITORS)
    print("顯示設備的總數量為: %d" % screenNum)

    aScreenWidth = win32api.GetSystemMetrics(win32con.SM_CXVIRTUALSCREEN)
    aScreenHeight = win32api.GetSystemMetrics(win32con.SM_CYVIRTUALSCREEN)
    print("當前屏幕總的分辨率為：%d × %d " % (aScreenWidth, aScreenHeight))

    WidthGet = win32api.GetSystemMetrics(win32con.SM_CXSCREEN) # 獲得屏幕分辨率X軸
    HeightGet = win32api.GetSystemMetrics(win32con.SM_CYSCREEN) # 獲得屏幕分辨率Y軸
    print ("獲取的分辨率寬: %d, 獲取的分辨率高: %d, 即獲取的分辨率為：%d x %d" % (WidthGet, HeightGet, WidthGet, HeightGet))
    time.sleep(3)
   
    i += 1