Okuqukethwe
Ngemva kokufunda lesi sihloko, uzofunda indlela yokudala ifayela elihlukile lesithombe (.png, .jpg, .bmp noma enye ifomethi) eshadini ku-Excel noma ulithumele, isibonelo, kudokhumenti ye-Word noma isethulo se-PowerPoint.
I-Microsoft Excel ingenye yezinhlelo zokusebenza ezinamandla kakhulu zokuhlaziya idatha. Ku-arsenal yayo kunamathuluzi amaningi nemisebenzi yokubuka le datha ngeso lengqondo. Amashadi (noma amagrafu) angelinye lamathuluzi anjalo. Ukuze udale ishadi ku-Excel, udinga nje ukukhetha idatha bese uchofoza isithonjana seshadi esigabeni semenyu esihambisanayo.
Kodwa, ukukhuluma ngokufaneleka, kubalulekile ukusho ubuthakathaka. Ngeshwa, ayikho indlela elula ku-Excel yokugcina ishadi njengesithombe noma ukuthekelisa komunye umbhalo. Kungaba kuhle uma singachofoza kwesokudla kugrafu futhi sibone umyalo onjengawo Londoloza njengomdwebo or Thumela. Kodwa, njengoba iMicrosoft ayizange inakekele ukusidalela imisebenzi enjalo, khona-ke sizoza nokuthile ngokwethu.
Kulesi sihloko, ngizokukhombisa izindlela ezi-4 zokulondoloza ishadi le-Excel njengesithombe ongakwazi ukusinamathisela kamuva kweminye imibhalo ye-Office, okuhlanganisa i-Word ne-PowerPoint, noma ukuyisebenzisele ukwakha i-infographics ekhangayo.
Kopisha umdwebo kusihleli sezithombe bese usigcina njengesithombe
Umngane wami wake wabelana nami ngemfihlo: ngokuvamile ukopisha amashadi akhe ukusuka ku-Excel kuya ku-Paint. Wakha ishadi abese ecindezela inkinobho PhrintaScreen, bese ivula i-Paint bese inamathisela isithombe-skrini. Ngemuva kwalokho, itshala izindawo ezingafuneki zesithombe bese igcina isithombe esisele efayeleni. Uma usukwenzile okufanayo kuze kube manje, kungcono ukukhohlwe futhi ungaphinde usebenzise le ndlela yobuntwana! Sizokwenza ngokushesha nangobuhlakani! 🙂
Isibonelo, ku-Excel 2010 yami, ngidale ishadi likaphayi elihle le-XNUMX-D elibonisa idatha mayelana nezibalo zabantu bezivakashi zethu zesayithi, futhi manje ngifuna ukuthekelisa leli shadi kusuka ku-Excel njengesithombe. Masikwenze ndawonye:
- Chofoza kwesokudla endaweni yeshadi bese uchofoza Kopisha (Kopisha). Asikho isidingo sokuchofoza kugrafu ngokwayo, ngoba lokhu kuzokhetha izakhi ngazinye, hhayi umdwebo wonke, kanye nomyalo. Kopisha (Kopisha) ngeke kuvele.
- Vula upende bese unamathisele ishadi usebenzisa isithonjana Faka (Namathisela) ithebhu Ikhaya (Ekhaya) bese uyacindezela Ctrl + V.
- Manje kusele kuphela ukulondoloza umdwebo njengefayela lesithombe. Chofoza Igcine njenge (Gcina njenge) bese ukhetha ifomethi eyodwa kulawa aphakanyisiwe (.png, .jpg, .bmp noma .gif). Uma ufuna ukukhetha ifomethi ehlukile, chofoza Amanye amafomethi (Amanye amafomethi) ekugcineni kohlu.
Akubi lula! Ukuze ulondoloze ishadi le-Excel ngale ndlela, noma yimuphi umhleli wezithombe uzokwenza.
Khipha ishadi lisuka ku-Excel liye ku-Word noma i-PowerPoint
Uma udinga ukuthumela ishadi lisuka ku-Excel liye kolunye uhlelo lwe-Office, njenge-Word, i-PowerPoint, noma i-Outlook, indlela engcono kakhulu yokwenza lokhu yibhodi lokunamathisela.
- Kopisha ishadi ku-Excel njengasesibonelweni sangaphambilini kokuthi Isinyathelo 1.
- Kudokhumenti ye-Word noma isethulo se-PowerPoint, chofoza lapho ofuna ukufaka khona ishadi bese uchofoza Ctrl + V. Noma esikhundleni sokucindezela Ctrl + V, chofoza kwesokudla noma yikuphi kudokhumenti, futhi isethi yonke yezinketho ezengeziwe izovuleka phambi kwakho esigabeni Namathisela Izinketho (Izinketho zokunamathisela).
Inzuzo enkulu yale ndlela ukuthi ngale ndlela ishadi le-Excel elisebenza ngokugcwele lithunyelwa kwelinye ifayela, hhayi nje isithombe. Igrafu izohlala ixhumene neshidi le-Excel langempela futhi izozibuyekeza ngokuzenzakalelayo lapho idatha ekulelo shidi le-Excel ishintsha. Lokhu kusho ukuthi akudingekile ukuthi ukopishe futhi unamathisele ishadi futhi ngoshintsho ngalunye kudatha esetshenzisiwe ukulakha.
Londoloza ishadi ku-Word naku-PowerPoint njengesithombe
Ku-Office 2007, 2010, kanye nezinhlelo zokusebenza zika-2013, ishadi le-Excel lingakopishwa njengesithombe. Kulokhu, izoziphatha njengesithombe esivamile futhi ngeke ibuyekezwe. Isibonelo, ake sikhiphe ishadi le-Excel kudokhumenti ye-Word 2010.
- Encwadini yokusebenzela ye-Excel, kopisha ishadi, bese uvula idokhumenti ye-Word, beka ikhesa lapho ufuna ukunamathisela khona ishadi, bese uchofoza umcibisholo omncane omnyama ngezansi kwenkinobho. Faka (Namathisela), etholakala kuthebhu Ikhaya (Ekhaya).
- Kumenyu evulayo, sinentshisekelo entweni Namathisela okukhethekile (Namathisela Okukhethekile) - Kuboniswa umcibisholo kusithombe-skrini ngenhla. Chofoza kuyo - ibhokisi lengxoxo legama elifanayo lizovuleka ngohlu lwamafomethi wesithombe atholakalayo, okuhlanganisa i-Bitmap (bitmap), i-GIF, i-PNG ne-JPEG.
- Khetha ifomethi oyifunayo bese uchofoza OK.
Cishe ithuluzi Namathisela okukhethekile (Namathisela Okukhethekile) iyatholakala futhi ezinguqulweni zangaphambili ze-Office, kodwa ngaleso sikhathi angizange ngiyisebenzise, ngakho-ke ngeke ngisho 🙂
Londoloza wonke amashadi ezincwadi ze-Excel njengezithombe
Izindlela esisanda kuxoxa ngazo ziwusizo uma kuziwa enanini elincane lemidwebo. Kodwa kuthiwani uma udinga ukukopisha wonke amashadi encwadini yokusebenzela ye-Excel? Uma ukopisha futhi unamathisele ngayinye yazo ngayinye, kungathatha isikhathi eside. Ngiyashesha ukukujabulisa – akumele wenze lokhu! Kukhona indlela yokulondoloza wonke amashadi encwadini yokusebenzela ye-Excel ngesikhathi esisodwa.
- Uma usuqedile ukudala amashadi encwadini yakho yokusebenzela, chofoza okuthi Ifayela (Ifayela) bese uchofoza inkinobho Igcine njenge (Igcine njenge).
- Ibhokisi lengxoxo lizovela Ilondoloza idokhumenti (Igcine njenge). Kuhlu lokudonsela phansi Uhlobo lwefayela (Londoloza njengohlobo) khetha Веб-страница (Ikhasi lewebhu, *.htm, *.html). Futhi hlola lokho esigabeni Londoloza (Londoloza) inketho ekhethiwe Incwadi Ephelele (Yonke Incwadi Yokusebenzela) njengoba kukhonjisiwe kusithombe-skrini esingezansi:
- Khetha ifolda ozolondoloza amafayela bese uchofoza inkinobho Londoloza (Gcina).
Kufolda ekhethiwe kanye namafayela .html wonke amashadi aqukethwe encwadini yokusebenzela ye-Excel njengamafayela azokopishwa . Png. Isithombe-skrini esingezansi sibonisa okuqukethwe kwefolda lapho ngigcine khona incwadi yami yokusebenzela. Incwadi yami yokusebenzela ye-Excel inamakhasi amathathu aneshadi ngalinye - futhi kufolda engiyikhethile, sibona amashadi amathathu agcinwe njengamafayela ayimifanekiso. . Png.
Njengoba wazi, i-PNG ingelinye lamafomethi angcono kakhulu wokucindezela izithombe lapho kungekho ukulahleka kwekhwalithi. Uma uncamela ukusebenzisa amanye amafomethi ezithombe, bese uwaguqulela kuwo .jpg, . Gif, .bmp noma yimuphi omunye ngeke kube nzima.
Ukulondoloza Ishadi Njengesithombe Ngokusebenzisa I-VBA Macro
Uma uvamise ukudinga ukuthekelisa amashadi e-Excel njengezithombe, ungawenza ngokuzenzakalelayo lo msebenzi usebenzisa i-VBA macro. Ngenhlanhla, maningi amamakhro anjalo asebhaliwe, ngakho-ke akudingeki ukuthi siphinde sisungule isondo 🙂
Isibonelo, ungasebenzisa isixazululo esizanyiwe nesiyiqiniso esithunyelwe nguJohn Peltier kubhulogi yakhe. I-macro yayo ilula kakhulu:
ActiveChart.Export "D:My ChartsSpecialChart.png"
Lo mugqa wekhodi udala ifayela eliyisithombe kufolda enikeziwe . Png futhi ithumele umdwebo kuwo. Ungakha i-macro yakho yokuqala manje ngezinyathelo ezi-4 ezilula, noma ngabe ungakaze ukwenze ngaphambili empilweni yakho.
Ngaphambi kokuthi uqale ukubhala i-macro, lungiselela ifolda yokuthekelisa ishadi. Esimweni sethu, lokhu kuzoba ifolda Amashadi Ami kudiski D. Ngakho-ke, wonke amalungiselelo aqediwe, masenze i-macro.
- Encwadini yakho ye-Excel, vula ithebhu Unjiniyela (Unjiniyela) futhi esigabeni Ikhodi (Ikhodi) chofoza isithonjana amamakhro (Amamakhro).
Qaphela: Uma udala i-macro okokuqala, khona-ke, cishe, ithebhu Unjiniyela (Unjiniyela) uzofihlwa. Kulokhu, hamba kuthebhu Ifayela (Ifayela), chofoza Amapharamitha (Izinketho) bese uvula isigaba Lungiselela iribhoni (Enza ngendlela oyifisayo Amaribhoni). Engxenyeni engakwesokudla yewindi, ohlwini Amathebhu amakhulu (Amathebhu Ayinhloko) maka ibhokisi eliseduze kokuthi Unjiniyela (Unjiniyela) bese uchofoza OK.
- Nikeza igama kumamakhro amasha, isibonelo, SaveSelectedChartAsImage, futhi wenze itholakalele le ncwadi yokusebenzela kuphela.
- Chofoza inkinobho Dala (Dala), lokhu kuzovula iwindi lomhleli we-Visual Basic, lapho isiqalo nesiphetho se-macro entsha kuzobe sekukhonjisiwe. Emugqeni wesibili, kopisha umbhalo omkhulu olandelayo:
ActiveChart.Export "D:My ChartsSpecialChart.png" - Vala i-Visual Basic Editor nakuthebhu Ifayela (Filet) guba Igcine njenge (Igcine njenge). Londoloza incwadi yakho yokusebenza njenge Incwadi yokusebenzela ye-Excel ene-Macro-enabled (I-Excel Macro-Enabled Workbook, *.xlsm). Yilokho, ukwenzile!
Manje ake siqhube i-macro esisanda kuyidala ukuze sibone ukuthi isebenza kanjani. Ima kancane… Kukhona enye into okudingeka siyenze. Kudingeka sikhethe ishadi le-Excel esifuna ukulithekelisa ngoba i-macro yethu isebenza kuphela neshadi elikhethiwe. Chofoza noma yikuphi emaphethelweni eshadi. Uhlaka olumpunga olukhanyayo oluvela eduze komdwebo luzobonisa ukuthi lukhethwe ngokugcwele.
Vula ithebhu futhi Unjiniyela (Unjiniyela) bese uchofoza isithonjana amamakhro (amakhrosi). Uhlu lwamamakhro atholakala encwadini yakho yokusebenzela luzovuleka. Gqamisa SaveSelectedChartAsImage Bese uqhafaza Qalisa (Gijima).
Manje vula ifolda oyicacisile ukuze ulondoloze ifayela - kufanele kube nesithombe . Png ngomdwebo othunyelwe kwamanye amazwe. Ungagcina amashadi ngefomethi ehlukile ngendlela efanayo. Ukuze wenze lokhu, kwanele ukushintsha ku-macro . Png on .jpg or . Gif - thanda lokhu:
ActiveChart.Export "D:My ChartsSpecialChart.jpg"
Yilokho kuphela okwanamuhla, futhi ngithemba ukuthi ube nesikhathi esimnandi ufunda lesi sihloko. Ngiyabonga ngokunaka!