I-Excel iyithuluzi elinamandla elisivumela ukuthi sigcine, sihlaziye, futhi silawule idatha ngendlela ehlelekile nehlelekile. Nokho, ngezinye izikhathi kungase kudingeke senze ngokuzenzakalelayo imisebenzi ethile, njengokushintsha inani leseli ethile, noma ukubuyekeza nokulungisa idatha ngaphakathi kwamashidi e-Excel. Ngosizo lolimi lokuhlela lwe-Python nemitapo yalo yolwazi, singakwazi ukufeza le misebenzi kalula futhi sidale izixazululo eziphumelelayo nezishukumisayo zezidingo zethu zokuphatha idatha. Kulesi sihloko, sizohlola izindlela ezahlukahlukene zokushintsha inani leseli eshidini le-Excel sisebenzisa iPython, futhi sizongena encazelweni yesinyathelo ngesinyathelo sekhodi.
Ukushintsha Amanani e-Excel usebenzisa iPython
Omunye umtapo wezincwadi wePython odumile osivumela ukuthi sifunde, sibhale, futhi siguqule amafayela e-Excel i-openpyxl umtapo wolwazi. Lo mtapo wezincwadi uhambisana kakhulu nawo womabili amafomethi wefayela le-.xlsx kanye ne-.xlsm futhi uhlinzeka ngezici ezihlukahlukene ukuze usebenze namaspredishithi e-Excel.
Ukufaka nokungenisa i-openpyxl
Ukuze usebenzise ilabhulali ye-openpyxl, udinga kuqala ukuyifaka kusistimu yakho. Ungakwenza lokhu usebenzisa umyalo we-pip olandelayo:
``
pip ufake i-openpyxl
``
Ngemuva kokufaka umtapo wezincwadi, yisikhathi sokuwungenisa kumbhalo wakho wePython.
from openpyxl import load_workbook
Ukushintsha Inani Leseli Eshidini le-Excel
Uma umtapo wezincwadi we-openpyxl ungenisiwe, into yokuqala okudingeka uyenze ukulayisha incwadi yokusebenzela ye-Excel equkethe ishidi ofuna ukulilungisa. Ukuze wenze lokhu, ungasebenzisa umsebenzi othi `load_workbook()` ovela kulabhulali ye-openpyxl.
Kulesi sibonelo, ake sicabange ukuthi sineshidi le-Excel elibizwa ngokuthi “sales_data.xlsx” elineshidi lokusebenza elibizwa ngokuthi “sales”. Nansi ikhodi yokulayisha incwadi yokusebenzela futhi ufinyelele ishidi lokusebenza lokuthengisa:
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
Manje njengoba sesikwazi ukufinyelela ishidi elithile lokusebenzela, singashintsha inani lanoma iyiphi iseli ngokucacisa irowu nekholomu yalo noma igama leseli (isb., “A1”, “B2”, njll.). Masiguqule inani leseli A1:
sheet["A1"] = "New Value"
Ngemva kokushintsha inani leseli, kubalulekile ukugcina izinguquko encwadini yokusebenzela. Singakwenza lokho ngomugqa wekhodi olandelayo:
workbook.save("sales_data_modified.xlsx")
Uma sihlanganisa konke, ikhodi ephelele yokuguqula inani leseli A1 kufayela elithi “sales_data.xlsx” izobukeka kanje:
from openpyxl import load_workbook
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
sheet["A1"] = "New Value"
workbook.save("sales_data_modified.xlsx")
Isiphetho
Kulesi sihloko, sifunde ukuthi singashintsha kanjani inani leseli eshidini le-Excel usebenzisa i-Python kanye nomtapo wezincwadi we-openpyxl. Inqubo ibandakanya ukufaka nokungenisa umtapo wolwazi, ukulayisha incwadi yokusebenzela ye-Excel, nokucacisa ishidi lokusebenzela esifuna ukulilungisa. Ngemva kwalokho, singashintsha kalula amanani eseli futhi silondoloze izinguquko encwadini yokusebenzela entsha noma ekhona kakade. Umtapo wezincwadi we-openpyxl unikeza ezinye izici ezihlukahlukene ezingasiza ukwenza ngokuzenzakalela nokwenza lula imisebenzi ehlobene nokuphatha amafayela e-Excel ngePython.
