I-Excel sisixhobo esinamandla esisivumela ukuba sigcine, sihlalutye, kwaye silawule idatha ngendlela ecwangcisiweyo necwangcisiweyo. Nangona kunjalo, ngamanye amaxesha sinokudinga ukuzenzekelayo imisebenzi ethile, njengokutshintsha ixabiso leseli ethile, okanye ukuhlaziya kunye nokuguqula idatha ngaphakathi kwamaphepha e-Excel. Ngoncedo lolwimi lwenkqubo yePython kunye namathala eencwadi ayo, sinokuyifeza ngokulula le misebenzi kwaye senze izisombululo ezisebenzayo neziguquguqukayo kwiimfuno zethu zolawulo lwedatha. Kweli nqaku, siza kuphonononga iindlela ezahlukeneyo zokutshintsha ixabiso leseli kwiphepha le-Excel usebenzisa iPython, kwaye siya kukhangela kwinkcazo yesinyathelo-nge-nyathelo yekhowudi.
Ukutshintsha amaxabiso e-Excel usebenzisa iPython
Elinye ithala leencwadi lePython elidumileyo elisivumela ukuba sifunde, sibhale, kwaye silungise iifayile ze-Excel yile openpyxl ithala leencwadi. Eli thala leencwadi lihambelana kakhulu kunye neefomati zefayile ze-xlsx kunye .xlsm kwaye ibonelela ngoluhlu olubanzi lweempawu zokusebenza kunye ne-Excel spreadsheets.
Ukufakela kunye nokungenisa i-openpyxl
Ukusebenzisa ilayibrari ye-openpyxl, kufuneka uqale uyifake kwinkqubo yakho. Unokwenza oku usebenzisa lo myalelo wepayipi ulandelayo:
``
pip faka i-openpyxl
``
Emva kokufaka ithala leencwadi, lixesha lokuyingenisa kwiskripthi sakho sePython.
from openpyxl import load_workbook
Ukutshintsha ixabiso leSeli kwiPhepha le-Excel
Nje ukuba ube nelayibrari ye-openpyxl engenisiweyo, into yokuqala ekufuneka uyenzile kukulayisha incwadi ye-Excel enephepha ofuna ukulilungisa. Ukwenza oku, ungasebenzisa i `load_workbook ()` umsebenzi kwithala leencwadi le-openpyxl.
Kulo mzekelo, masicinge ukuba sinephepha le-Excel elibizwa ngokuba yi-"sales_data.xlsx" kunye nephepha lomsebenzi elibizwa ngokuba yi-"sales". Nantsi ikhowudi yokulayisha incwadi yomsebenzi kunye nokufikelela kwiphepha lomsebenzi wokuthengisa:
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
Ngoku sinofikelelo kwiphepha lomsebenzi elithile, singatshintsha ixabiso layo nayiphi na iseli ngokuchaza umqolo kunye nekholamu okanye igama leseli (umzekelo, “A1”, “B2”, njl. njl.). Masitshintshe ixabiso leseli A1:
sheet["A1"] = "New Value"
Emva kokutshintsha ixabiso leseli, kubalulekile ukugcina utshintsho kwincwadi yomsebenzi. Singakwenza oko ngomgca wekhowudi ulandelayo:
workbook.save("sales_data_modified.xlsx")
Ukuyibeka yonke, ikhowudi epheleleyo yokutshintsha ixabiso leseli A1 kwifayile "sales_data.xlsx" iya kujongeka ngolu hlobo:
from openpyxl import load_workbook
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
sheet["A1"] = "New Value"
workbook.save("sales_data_modified.xlsx")
isiphelo
Kweli nqaku, sifunde indlela yokutshintsha ixabiso leseli kwiphepha le-Excel usebenzisa iPython kunye nelayibrari ye-openpyxl. Inkqubo ibandakanya ukufaka kunye nokungenisa ngaphandle kwethala leencwadi, ukulayisha incwadi yokusebenza ye-Excel, kunye nokucacisa iphepha lomsebenzi esifuna ukulilungisa. Emva koko, sinokutshintsha ngokulula amaxabiso eseli kwaye sigcine utshintsho kwincwadi entsha okanye ekhoyo. Ithala leencwadi le-openpyxl linika ezinye izinto ezahlukeneyo ezinokunceda ukwenza lula kunye nokwenza lula imisebenzi enxulumene nokulawula iifayile ze-Excel ngePython.
