Enye yezona zinto zibalaseleyo nge-Excel kukukwazi ukukhusela iifayile zakho kuwo onke amanqanaba. Unokukhetha ukukhusela iNcwadi yoMsebenzi kutshintsho lwesakhiwo, oko kuthetha ukuba abantu abangagunyaziswanga abanako ukutshintsha inani okanye ukulandelelana kwamaphepha kwincwadi yomsebenzi. Ungakwazi nokuseta igama eligqithisiweyo ukuthintela nabani na ekutshintsheni amaphepha okusebenzela, nto leyo ethetha ukuba akanako ukukopa, ukuhlela okanye ukucima nasiphi na isiqulatho kumaphepha okusebenzela. Kwaye unokuseta igama eligqithisiweyo lokuvula eliya kuthintela umntu ekuvuleni uxwebhu ngaphandle kokuba unegama lokugqitha.
Ngelixa la magama agqithisiweyo anokusebenza, anokukuthintela ekufikeleleni okanye ekuguquleni uxwebhu xa ufuna njalo. Ukuba awukwazi ukufikelela kuxwebhu lwe-Excel okanye i-spreadsheet ngenxa yokuba awulazi igama eligqithisiweyo okanye ulibele, eli nqaku liya kuba luncedo kakhulu. Kuyo, siza kujonga ezinye zeendlela onokususa ngazo igama lokugqitha kuxwebhu lwe-Excel.
Icandelo 1: Yintoni enokwenzeka yokususa igama lokugqitha kwi-Excel
Ngaphambi kokuxoxa ngendlela onokuyisusa ngayo igama lokugqitha kwiphepha le-Excel, sicinga ukuba kufuneka sijongane nombono oqhelekileyo wokuvula igama lokugqitha kunye nethuba lokuvula igama lokugqitha le-Excel.
Ukuvula igama lokugqithisa yinkqubo esebenzisa iindlela ezahlukeneyo ukubuyisela okanye ukususa igama lokugqitha kwidatha egcinwe okanye egqithiswe ngenkqubo yekhompyutha. Enye yeendlela ezisetyenziswa kakhulu zokususa igama lokugqitha yindlela yokuhlasela ngamandla brute. Le ndlela isebenzisa indlela yokuqikelela ethelekelela ngokuphindaphindiweyo amagama ayimfihlo ahlukeneyo de kufumaneke igama elichanekileyo. Ke yintoni enokwenzeka yokususa igama lokugqitha le-Excel? Inyaniso mayixelelwe, akukho nkqubo inokuqinisekisa i-100% yezinga lempumelelo kwimarike. Kodwa inkqubo egqwesileyo yokungakhuseli amaxwebhu e-Excel inokunciphisa kakhulu ixesha. Ke ngoko, ithuba lokususa isitshixo linokwanda kakhulu.
Kubantu abangengobuchwephesha, sicebisa kakhulu ukuba uzame i-Excel password unlocker ukukunceda ukususa igama lokugqitha kwiifayile ze-Excel.
Icandelo 2: Ulisusa njani igama lokugqitha ngokukhawuleza
Ukuba awukwazi ukuvula uxwebhu lwe-Excel ngaphandle kwegama lokugqitha, ezi zilandelayo zezinye zeendlela onokuzama ngazo.
Indlela yoku-1: Susa igama lokugqithisa kwiFayile ye-Excel enePassers ye-Excel
Ngelona thuba libalaseleyo lempumelelo, unokufuna ukusebenzisa inkqubo enamandla: Ipasile le-Excel . Le yinkqubo yokuvula igama lokugqitha enokuba luncedo ekuncedeni ugqithe igama lokugqitha lokuvula kulo naluphi na uxwebhu lweExcel, noguqulelo lwamva nje. Inenani leefitsha ezilungiselelwe ukwenza ukubuyisela igama lokugqitha kube lula kakhulu. Ziquka oku kulandelayo:
- Isantya sokuvula igama eligqithisiweyo ngokukhawuleza : Inesinye sezantya zokuvula iipassword ezikhawulezayo emarikeni, ikwazi ukuqinisekisa iipassword eziphantse zibe yi-3,000,000 ngomzuzwana.
- Ubuninzi bamathuba okufumana igama lokugqitha -Ikunika ukhetho lokukhetha kwiindlela ezi-4 zokuhlasela kunye nesichazi-magama sezigidi zamagama agqithisiweyo asetyenziswa rhoqo, ukwandisa ngakumbi amathuba okufumana kwakhona iphasiwedi kunye nokunciphisa kakhulu ixesha lokubuyisela.
- Akukho lahleko yedatha : Akukho nanye idatha kuxwebhu lwakho lwe-Excel eya kuchaphazeleka ngayo nayiphi na indlela yinkqubo yokubuyisela.
- Ukhuseleko lwedatha : Awudingi ukulayisha ifayile yakho kwiseva yabo, ngoko ke, ubumfihlo bakho bedatha buthenjisiwe nge-100%.
- Akukho mda : Inkqubo iyahambelana nazo zonke iinguqulelo zeWindows kunye neenguqulelo zeExcel. Ukongeza, akukho mda kubungakanani befayile.
Le yindlela onokuyisebenzisa ngayo iPasss ye-Excel ukuvula ifayile ye-Excel ekhuselweyo ngegama eliyimfihlo.
Inyathelo loku-1 :Fakela iPasi yeExcel kwikhompyuter yakho emva koko uyiqalise. Kwifestile enkulu, cofa "Buyisa amagama okugqithisa".
Inyathelo lesi-2 : Cofa iqhosha elithi “+” ukukhetha uxwebhu lwe-Excel ofuna ukungalikhuseli. Xa uxwebhu longezwe kwiprogram, khetha imo yokuhlasela ongathanda ukuyisebenzisa kwaye ucofe "Buyisa." Indlela yohlaselo oyikhethayo iya kuxhomekeka kubunzima begama eligqithisiweyo kwaye nokuba unayo nayiphi na ingcamango yokuba ingaba yintoni na.
Inyathelo lesi-3 : Nje ukuba ukhethe imo yohlaselo, cofa kwiqhosha elithi “Buyisa” kwaye iPass ye-Excel iya kuqalisa kwangoko ukusebenza ukubuyisela igama eligqithisiweyo. Emva kwemizuzu embalwa, inkqubo iya kugqiba kwaye kufuneka ubone igama lokugqitha kwisikrini.
Ungasebenzisa igama eligqithisiweyo elifunyenweyo ukuvula uxwebhu olukhuselweyo lwe-Excel ngoku.
Indlela yesi-2: Susa igama lokugqitha kwifayile ye-Excel kwi-intanethi
Akukho mfuneko yokufaka nayiphi na isoftware kwikhompyuter yakho ukuze uguqule igama eliyimfihlo lokuvula kuxwebhu lwakho lwe-Excel. Ungasebenzisa esinye sezixhobo ezininzi ze-intanethi ezenzelwe loo msebenzi. Ukusebenzisa isixhobo se-intanethi kunokuba kulungele wena ukuba ifayile ayinalo ulwazi olubalulekileyo kunye negama lokugqitha ekuthethwa ngalo libuthathaka. Uninzi lwezixhobo ze-intanethi zisebenzisa i-brute force attack recovery method kwaye ngoko zisebenza kuphela malunga ne-21% yexesha. Kukho izixhobo ze-intanethi ezinezinga lempumelelo ye-61%, kodwa zizixhobo zeprayimari, oku kuthetha ukuba kufuneka uhlawule ukuzisebenzisa.
Kodwa mhlawumbi eyona nto ingalunganga kakhulu yokusebenzisa izixhobo ze-intanethi kukuba kufuneka ulayishe ifayile ye-Excel kwiqonga le-intanethi. Oku kubeka ingozi kwidatha ekwifayile ye-Excel kuba ungazi ukuba abanini besixhobo se-intanethi baya kwenza ntoni ngoxwebhu lwakho xa igama eligqithisiweyo lisusiwe.
Iingxaki zale ndlela:
- Izinga lokuphumelela eliphantsi : Izinga lokubuyisela liphantsi kakhulu, lingaphantsi kwe-100% izinga lokuphumelela.
- Umlinganiselo wesayizi yefayile : Abavuleli be-password be-Excel kwi-Intanethi bahlala benomda kubungakanani befayile. Kwabanye abavuleli begama lokugqitha, ubungakanani befayile abunakudlula kwi-10 MB.
- Isantya esicothayo sokubuyisela : Xa usebenzisa i-Excel password yokuvula kwi-intanethi, kufuneka ube noqhagamshelo lwe-intanethi oluzinzileyo nolunamandla. Ngaphandle koko, inkqubo yokubuyisela iya kucotha ngokwenene okanye ibambelele.
Icandelo 3: Yaphula i-password ye-Excel ukwenza uhlengahlengiso
Njengoko besesitshilo ngaphambili, akunakwenzeka ukuba ufumane uxwebhu lwe-Excel olungenakuguqulwa. Umnini woxwebhu unokumisela izithintelo ezenza kube nzima kubasebenzisi ukuhlela umxholo woxwebhu. Kule meko, ungazama esinye sezi zisombululo zilandelayo:
Indlela yoku-1: Sebenzisa iPassper ye-Excel (100% iRate yempumelelo)
Ukongeza kwi-Excel password recovery, Ipasile le-Excel Ikwasisixhobo esihle sokuvula i-Excel spreadsheets/worksheets/workbooks. Ngokucofa kanye, zonke izithintelo zokuhlela kunye nokufomatha zingasuswa nge-100% yezinga lempumelelo.
Nantsi indlela yokuvula i-Excel spreadsheet/workbook:
Inyathelo loku-1 : Vula iPasi ye-Excel kwikhompyuter yakho kwaye emva koko ucofe u-“Susa izithintelo.”
Inyathelo lesi-2 : Cofa "Khetha iFayile" ukungenisa uxwebhu kwinkqubo.
Inyathelo lesi-3 : Nje ukuba uxwebhu longezwe, cofa "Cima" kwaye inkqubo iya kususa naziphi na izithintelo kuxwebhu ngemizuzwana nje emi-2.
Indlela yesi-2: Susa iiPasswords ze-Excel ngokuTshintsha iSandiso seFayile
Ukuba usebenzisa i-MS Excel 2010 okanye ngaphambili, unokuvula uxwebhu ngokutshintsha ulwandiso lwefayile. Le yindlela owenza ngayo.
Inyathelo loku-1 : Qala ngokwenza ikopi yefayile ye-Excel ekhuselweyo ngegama eligqithisiweyo, ukuze ube nekopi xa kukho into engahambi kakuhle.
Inyathelo lesi-2 : Cofa ekunene ifayile uze ukhethe "Qamba ngokutsha." Guqula ulwandiso lwefayile ukusuka ku-“.csv” okanye “.xls” ukuya ku-“.zip”.
Inyathelo lesi-3 : Vula imixholo yefayile yeZip esandula ukuyilwa kwaye emva koko ukhangele ku “xl\amaphepha okusebenzela\”. Fumana iphepha lomsebenzi ofuna ukulivula. Cofa ekunene kuyo kwaye ukhethe "Hlela" ukhetho lokuvula ifayile kwiNotepad.
Inyathelo lesi-4 : Sebenzisa "Ctrl + F" umsebenzi ukuvula umsebenzi wokukhangela kunye nokukhangela "SheetProtection". Ukhangela umgca wokubhaliweyo oqala ngo; «
Inyathelo lesi-5 : Cima umgca wonke wokubhaliweyo uze ugcine ifayile kwaye uyivale. Ngoku tshintsha ulwandiso lwefayile ukuya ku .csv okanye .xls.
Awusayi kuphinda ufune igama eligqithisiweyo xa ufuna ukuhlela okanye ukuguqula i-worksheet.
Iingxaki zale ndlela:
- Le ndlela isebenza kuphela kwi-Excel 2010 kunye neenguqulelo zangaphambili.
- Ungavula kuphela iphepha lomsebenzi elinye ngexesha. Ukuba unamaphepha okusebenzela amaninzi akhuselweyo kwifayile ye-Excel, kufuneka uphinde la manyathelo angasentla kwiphepha ngalinye.
Indlela yesi-3: Fumana iPassword ye-Excel usebenzisa i-Google Sheets
I-Google Drive ikhuphe uhlaziyo olutsha ukuxhasa amaxwebhu e-MS Office akhuselwe ngegama eliyimfihlo. I-Google Drive ibonelela ngendlela engantsonkothanga kakhulu yokuvula naluphi na uxwebhu lwe-Excel xa ufuna ukuyilungisa. La manyathelo alandelayo aya kukuxelela indlela yokuvula ifayile ye-Excel ekhuselweyo ngegama eliyimfihlo kwi-Google Sheets.
Inyathelo loku-1 : Yiya kuGoogle Drive nakweyiphi na ibhrawuza ekwikhompyuter yakho kwaye ungene ukuba awukangeni.
Inyathelo lesi-2 : Cofa ithebhu "Entsha" kwaye ukhethe i-Google Sheets. Ukuba sele uyibekile ifayile yakho ye-Excel etshixiweyo kwiDrayivu yakho, ungakhetha u-"Vula" ukuvula ifayile ngqo. Kungenjalo, kufuneka ulayishe ifayile yakho ngokucofa ku "Ngenisa" ukhetho.
Inyathelo lesi-3 : Ngoku vula uxwebhu olukhuselweyo lwe-Excel kwaye emva koko ucofe kwikona ephezulu ngasekhohlo ukukhetha zonke iiseli ezikolu xwebhu.
Inyathelo lesi-4 : Cofa u-"Kopisha" okanye ucinezele u-Ctrl + C.
Inyathelo lesi-5 : Ngoku sebenzisa inkqubo yakho ye-MS Excel kwaye ucinezele u-Ctrl+ V. Yonke idatha ekwi-password ekhuselweyo kwi-Excel spreadsheet iya kudluliselwa kule ncwadi yokusebenza intsha. Ungalungisa uxwebhu ngayo nayiphi na indlela oyifunayo.
Iingxaki zale ndlela:
- Le ndlela ithatha ixesha ukuba kukho amaxwebhu okusebenzela amaninzi atshixiwe kuxwebhu lwakho lwe-Excel.
- I-Google Sheets ifuna uqhagamshelo lwe-Intanethi oluzinzileyo ukuze ufake iifayile. Ukuba uqhagamshelo lwakho lwe-Intanethi lubuthathaka okanye ifayile yakho ye-Excel inkulu, inkqubo yokulayisha iyacotha okanye ide ingqubeke.
Indlela 4. Susa i-Excel Spreadsheet Password ngeVBA Code
Indlela yokugqibela esiza kuyijonga kukusebenzisa ikhowudi yeVBA ukuvula i-Excel spreadsheet. Le ndlela iya kusebenza kuphela kwi-Excel 2010, 2007, kunye neenguqulelo zangaphambili. Kubalulekile ukuqaphela ukuba le ndlela inokususa kuphela igama eligqithisiweyo kwiphepha lomsebenzi. Inkqubo yokuvula inzima, ngoko ke la manyathelo alandelayo aya kuba luncedo.
Inyathelo loku-1 : Vula i-password ekhuselweyo ye-Excel spreadsheet ene-MS Excel. Cinezela "Alt+F11" ukuvula iVBA ifestile.
Inyathelo lesi-2 : Cofa "Faka" kwaye ukhethe "Imodyuli" kwiinketho.
Inyathelo lesi-3 : Faka ikhowudi elandelayo kwifestile entsha.
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
Inyathelo lesi-4 : Cofa F5 ukwenza umyalelo.
Inyathelo lesi-5 : Khawume kancinci. Ibhokisi yencoko yababini entsha izakuvela ngegama eligqithisiweyo elisebenzisekayo. Cofa "Kulungile" kwaye emva koko uvale iVBA window.
Inyathelo lesi-6 : Buyela kwi-spreadsheet yakho ye-Excel ekhuselweyo. Ngoku, uya kufumanisa ukuba iphepha lomsebenzi likhangelwe.
Iingxaki zale ndlela:
- Ukuba kukho amaxwebhu omsebenzi amaninzi akhuselweyo kwi-Excel yakho, kufuneka uphinde la manyathelo angasentla kwiphepha lomsebenzi ngalinye.
Ukuqukumbela
Ukususa igama eligqithisiweyo kuxwebhu lwe-Excel akufuneki kube nzima. Ngezantya zokubuyisela ngokukhawuleza, iindlela ezininzi zokuhlasela kunye nesantya esiphezulu sokubuyisela, Ipasile le-Excel ibonisa eyona ndlela ilungileyo yokususa ngokukhawuleza igama lokugqitha kulo naluphi na uxwebhu lweExcel.
![Ulisusa njani igama lokugqithisa kwiProjekthi yeVBA ye-Excel [Iindlela ezi-4]](https://www.passmapa.com/images/desbloquear-proyecto-vba-excel-390x220.png)