Indlela ukususa iphaswedi Excel-ifayile: iindlela ezimbalwa ezilula

Iimeko apho abasebenzisi ukwenza amaxwebhu ngohlobo spreadsheet, abakhusele kunye nephasiwedi, ngendlela eqhelekileyo. Kusenokuba yimfuneko ukuqinisekisa ukuba kwifomula awuzange uguqulwe, okanye nje ubonwe. Amaninzi aqalile ukuba bacinge malunga nendlela ukususa igama ukusuka Excel-ifayile okanye ukususa ukhuselo. Okulandelayo izinto iindlela ezilula ezimbalwa kuvumela ukwenza imisebenzi enjalo nje imizuzu embalwa.

Indlela ukususa ukukhusela ukusuka Excel ifayile, esazi iphasiwedi yakho?

Okokuqala, cinga imeko eqhelekileyo apho uxwebhu okanye iqela kweemakhishithi likhuselwe, kodwa umsebenzisi azi yegama lokugqitha ukuze ukwazi ukutshintsha umxholo.

ususe algorithm wokhuseleko kukuba ngolu hlobo. Okokuqala, sebenzisa lenjongo ephambili, apho uphononongo iprofayili ekhethiweyo lilandelwa inguqulelo deprotection umgca. Ukuze uqinisekise ukuba intshukumo iya kuyalelwa ukuba ufake ipasiwedi ngoku, uze emva koko lufumaneka noxwebhu okanye ifayile ye ukuhlela.

Ngala mazwi alula. Kodwa ukuba ukususa njani ngoko kwifayile yegama eligqithisiweyo Excel, ukuba umsebenzisi kuye Ufuna ukwenza utshintsho kwifayile, indibaniselwano efunekayo ayiyazi oaknye awukhumbuli? Kukho zingasetyenziswa ngeendlela ezininzi.

Indlela ukususa iphaswedi lithetha iprogram ye-Excel-fayile?

Iindlela ngokususa igama kubonakala kakhulu elula. Ukuze wenze oku, vula uxwebhu ofuna ukusebenzisa lo menu ifayile, apho umtya ulwazi malunga kokuba ikhethwe.

Emva koko wacofa iqhosha ngokukhuselwa ethi kokufaka, uze usebenzise ufihlo umba password. Kwi window elivela iya kubonisa ngaphambili wabeka idityaniswe. Indlela ukususa iphaswedi Excel-fayile? Ewe, cima nje bonke abasebenzi bomtya password nokuphinda-ukugcina uxwebhu. Xa ukuvula incwadi kucelwa ukuba ufake akayi kuvela igama lokugqitha.

Ukusebenzisa kutshintshwe ifomathi yefayile

Kukho nenye indlela ephumelelayo ngokulinganayo ukusombulula ingxaki indlela ukususa igama ukusuka Excel-fayile. Sithetha ukutshintsha indlela ifomathi uxwebhu yokuqala.

Okokuqala, vula ifayile ufuna ukugcina ngqo kule nkqubo, njengoko uqhuba XML. Uxwebhu omtsha ngoko kuvulwa kwi "Notepad" njengesiqhelo usebenzisa i menu nqakraza-ekunene kwaye command "Vula nge ...", yaye sele kufuneka ukhangele khona i tag password (idla ngokuba kukhangeleka ngathi Password), uze ukucima imixholo uze ucofe nje ukuze ugcine uxwebhu (for fast Kusindisa ukuhlanganiswa Ctrl + S) zingasetyenziswa.

Kodwa xa kukho inani elikhulu kweemakhishithi, le ndlela sisenokungasebenzi njalo ekuqaleni basindiswe kwakhona ifomati kuxwebhu XLSX, koko wavula nayiphi archiver (Winrar, 7-Zip) ukucatshulwa imixholo kuyo nayiphi na indawo lula.

Okulandelayo ufuna ukufumana abalawuli ulawulo unwrapped okusebenzela, apho iya kuba zonke iifayile sheets format XML (Sheet1, Sheet2, njalo njalo). Emva koko, ngokuba kwiziko ngalinye kufuneka kuphindwa ukusebenza ukuhlelwa kwisicelo kwisicatshulwa. Kuphela echaziwe tag yokukhangela sheetProtection yokuqala uze kususa yonke into phakathi iindibaniso «." Oku kulandelwa ulondolozo umgangatho, ngoko imfuneko ukutsala iifayile ezigcinwe kwi window ezindlela wamkele isiqulatho replacement. Ekugqityweni zonke ezi zenzo kumhleli spreadsheet, iifayile lungagcinwa format lweenkobe.

iinkqubo zeqela lesithathu

Ekugqibeleni, umbuzo indlela ukususa igama ukusuka Excel-ifayile, ingasombululwa ngokusebenzisa iinkqubo ushicilelo ezikhethekileyo ezifana weplishi Password.

Emva ukufakwa, isicelo ihlanganise iqela salo izicelo ofisi (hayi kuphela Excel, kodwa kuzo zonke abanye). Ukucima iphaswedi, xa uqala kuqala nge Sakhe VBA-elishicilelwe kufuneka uqale uvume ukuya ekuphunyezweni macro, uze uvule ifayile, kwaye umhleli engundoqo kwiqela lenjongo ukusebenzisa umyalelo Straxx. Apha kuyimfuneko ukuqonda ukuba isicelo umhlaseli ayikho kwaye ayisebenzi kumgaqo yokukhethwa random yomthonyama ethi idibanise efunekayo. It khubaza ukhuselo ifayile ukusuka ngaphakathi, ngoko ukulusebenzisa ngokukhuselekileyo ngokulula. Ingxelo evela kubasebenzisi abaye basebenzisa le yeempendulo practice, icebisa ukuba inkqubo khowudi yasiwa kumbhalo wonke ithatha malunga ezimbini imizuzu.