Excel kayan aiki ne mai ƙarfi wanda ke ba mu damar adanawa, bincika, da sarrafa bayanai a cikin tsari da tsari. Koyaya, wani lokacin muna iya buƙatar sarrafa wasu ayyuka, kamar canza ƙimar takamaiman tantanin halitta, ko sabuntawa da gyara bayanai a cikin takaddun Excel. Tare da taimakon harshen shirye-shirye na Python da dakunan karatu, za mu iya aiwatar da waɗannan ayyuka cikin sauƙi kuma mu ƙirƙiri ingantacciyar mafita mai ƙarfi don buƙatun sarrafa bayanai. A cikin wannan labarin, za mu bincika hanyoyi daban-daban don canza darajar tantanin halitta a cikin takardar Excel ta amfani da Python, kuma za mu shiga cikin bayanin mataki-mataki na lambar.
Canza darajar Excel ta amfani da Python
Ɗayan mashahurin ɗakin karatu na Python wanda ke ba mu damar karantawa, rubutawa, da gyara fayilolin Excel shine budepyxl ɗakin karatu. Wannan ɗakin karatu yana dacewa sosai tare da tsarin fayil ɗin .xlsx da .xlsm kuma yana ba da fa'idodi da yawa don aiki tare da maƙunsar bayanai na Excel.
Shigarwa da Shigo da openpyxl
Don amfani da ɗakin karatu na openpyxl, da farko kuna buƙatar shigar da shi akan tsarin ku. Kuna iya yin wannan ta amfani da umarnin pip mai zuwa:
““
pip shigar openpyxl
““
Bayan shigar da ɗakin karatu, lokaci ya yi da za a shigo da shi cikin rubutun Python ɗin ku.
from openpyxl import load_workbook
Canza darajar Cell a cikin takardar Excel
Da zarar an shigo da ɗakin karatu na openpyxl, abu na farko da kuke buƙatar yi shine loda littafin aikin Excel wanda ke ɗauke da takardar da kuke son gyarawa. Don yin wannan, zaku iya amfani da aikin `load_workbook()` daga ɗakin karatu na openpyxl.
Don wannan misalin, bari mu ɗauka muna da takardar Excel mai suna "sales_data.xlsx" tare da takardar aiki mai suna "tallace-tallace". Anan shine lambar don loda littafin aiki da samun damar takardar aikin tallace-tallace:
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
Yanzu da muka sami damar yin amfani da takamaiman takaddun aiki, za mu iya canza ƙimar kowane tantanin halitta ta hanyar tantance layinsa da ginshiƙinsa ko sunan tantanin halitta (misali, “A1”, “B2”, da sauransu). Bari mu canza darajar cell A1:
sheet["A1"] = "New Value"
Bayan canza ƙimar tantanin halitta, yana da mahimmanci don adana canje-canje zuwa littafin aiki. Za mu iya yin hakan tare da layin code mai zuwa:
workbook.save("sales_data_modified.xlsx")
Haɗa shi duka, cikakken lambar don canza ƙimar tantanin halitta A1 a cikin fayil ɗin "sales_data.xlsx" zai yi kama da wannan:
from openpyxl import load_workbook
workbook = load_workbook("sales_data.xlsx")
sheet = workbook["sales"]
sheet["A1"] = "New Value"
workbook.save("sales_data_modified.xlsx")
Kammalawa
A cikin wannan labarin, mun koyi yadda ake canza darajar tantanin halitta a cikin takardar Excel ta amfani da Python da ɗakin karatu na openpyxl. Tsarin ya ƙunshi shigarwa da shigo da ɗakin karatu, loda littafin aikin Excel, da ƙayyadaddun takaddar aikin da muke son gyarawa. Bayan haka, za mu iya sauƙin canza ƙimar tantanin halitta kuma mu adana canje-canje zuwa sabon ko littafin aiki na yanzu. Laburaren openpyxl yana ba da wasu fasaloli daban-daban waɗanda zasu iya taimakawa sarrafa kansa da sauƙaƙe ayyuka masu alaƙa da sarrafa fayilolin Excel tare da Python.
