Excel chishandiso chine simba chinotibvumira kuchengeta, kuongorora, uye kushandura data nenzira yakarongeka uye yakarongeka. Nekudaro, dzimwe nguva tingangoda kuita otomatiki mamwe mabasa, sekuchinja kukosha kwesero chaiyo, kana kuvandudza nekugadzirisa data mukati meExcel sheet. Nerubatsiro rwePython programming mutauro nemaraibhurari ayo, tinogona kuita mabasa aya zviri nyore uye kugadzira mhinduro dzinoshanda uye dzine simba kune zvatinoda zvekutonga data. Muchikamu chino, tichaongorora nzira dzakasiyana-siyana dzekushandura kukosha kwesero muExcel sheet uchishandisa Python, uye isu tichaongorora nhanho-ne-nhanho tsananguro yekodhi.
Kuchinja Excel Values uchishandisa Python
Imwe yakakurumbira Python raibhurari iyo inotibvumira kuverenga, kunyora, uye kugadzirisa Excel mafaera ndiyo openpyxl library. Raibhurari iyi inopindirana zvikuru nemhando dzose .xlsx uye .xlsm mafaira uye inopa huwandu hwakawanda hwezvinhu zvekushanda neExcel spreadsheets.
Kuisa uye Kupinza Openpyxl
Kuti ushandise openpyxl raibhurari, iwe unofanirwa kutanga waiisa pane yako system. Iwe unogona kuita izvi uchishandisa inotevera pip command:
``
pip kuisa openpyxl
``
Mushure mekuisa raibhurari, yave nguva yekuipinza muPython script yako.
from openpyxl import load_workbook
Kuchinja Kukosha Kwesero muExcel Sheet
Paunenge uine openpyxl raibhurari yakaunzwa kunze kwenyika, chinhu chekutanga chaunofanirwa kuita kurodha bhuku rebasa reExcel rine pepa raunoda kugadzirisa. Kuti uite izvi, unogona kushandisa iyo `load_workbook ()` basa kubva openpyxl raibhurari.
Pamuenzaniso uyu, ngatifungei kuti tine bepa reExcel rinonzi “sales_data.xlsx” rine bepa rekushanda rinonzi “sales”. Heino kodhi yekuisa bhuku rebasa uye kuwana pepa rebasa rekutengesa:
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
Iye zvino zvatava nekuwana kune chaiyo pepa rekushanda, tinogona kushandura kukosha kwesero ripi neripi nekutsanangura mutsara waro nekoramu kana zita resero (semuenzaniso, "A1", "B2", nezvimwewo). Ngatichinje kukosha kwesero A1:
sheet["A1"] = "New Value"
Mushure mekushandura kukosha kwesero, zvakakosha kuchengetedza shanduko kubhuku rebasa. Isu tinogona kuzviita neiyo inotevera mutsara wekodhi:
workbook.save("sales_data_modified.xlsx")
Kuzviisa pamwe chete, kodhi yakazara yekushandura kukosha kwesero A1 mu "sales_data.xlsx" faira raizotaridzika seizvi:
from openpyxl import load_workbook
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
sheet["A1"] = "New Value"
workbook.save("sales_data_modified.xlsx")
mhedziso
Muchikamu chino, tadzidza maitiro ekuchinja kukosha kwesero mune Excel sheet uchishandisa Python uye openpyxl raibhurari. Maitiro acho anosanganisira kuisa uye kupinza raibhurari, kurodha bhuku rebasa reExcel, uye kutsanangura pepa rebasa ratinoda kugadzirisa. Mushure meizvi, tinogona kushandura zviri nyore maseru maitiro uye kuchengetedza shanduko kubhuku rebasa idzva kana riripo. Iyo openpyxl raibhurari inopa mamwe akasiyana maficha anogona kubatsira otomatiki uye kurerutsa mabasa ane chekuita nekugadzirisa Excel mafaera nePython.
