E 'ngoe ea lintho tse ntle ka Excel ke bokhoni ba ho sireletsa lifaele tsa hau maemong ohle. U ka khetha ho sireletsa Buka ea Mosebetsi liphetohong tsa meralo, ho bolelang hore batho ba sa lumelloeng ba ke ke ba fetola palo kapa taelo ea maqephe bukeng ea mosebetsi. U ka boela ua seta phasewete ho thibela mang kapa mang ho fetola maqephe a mosebetsi, ho bolelang hore a ke ke a kopitsa, a hlophisa kapa a hlakola litaba life kapa life maqepheng a mosebetsi. Hape u ka beha password ea ho bula e tla thibela motho ho bula tokomane ntle le haeba a na le password.
Le hoja li-passwords tsena li ka sebetsa hantle, li ka u thibela ho fumana kapa ho fetola tokomane ha u e hloka. Haeba u sa khone ho fumana tokomane ea Excel kapa spreadsheet hobane ha u tsebe phasewete kapa u e lebetse, sengoloa sena se tla u thusa haholo. Ho eona, re tla sheba tse ling tsa litsela tseo u ka tlosang phasewete tokomaneng ea Excel.
Karolo ea 1: Monyetla oa ho tlosa phasewete ho Excel ke ofe
Pele re buisana ka hore na u ka tlosa password joang ho Excel sheet, re nahana hore re hloka ho sebetsana le mohopolo o akaretsang oa ho notlolla phasewete le monyetla oa ho notlolla password ea Excel.
Ho notlolla phasewete ke ts'ebetso e sebelisang mekhoa e fapaneng ho khutlisa kapa ho tlosa phasewete ho data e bolokoang kapa e fetisoang ka sistimi ea khomphutha. E 'ngoe ea mekhoa e sebelisoang haholo ea ho tlosa password ke mokhoa oa brute force attack. Mokhoa ona o sebelisa mokhoa oa ho hakanya o atisang ho hakanya li-password tse fapaneng ho fihlela password e nepahetseng e fumanoa. Joale ho na le monyetla oa ho tlosa password ea Excel? 'Nete e bolelloa, ha ho na lenaneo le ka tiisang katleho ea 100%' marakeng. Empa lenaneo le letle la ho sireletsa maqephe a Excel le ka khutsufatsa nako haholo. Ka hona, monyetla oa ho tlosa senotlolo o ka eketseha haholo.
Bakeng sa batho bao e seng litsebi tsa theknoloji, re khothaletsa haholo hore u leke senotlolo sa senotlolo sa Excel ho u thusa ho tlosa password ho lifaele tsa Excel.
Karolo ea 2: Mokhoa oa ho tlosa phasewete kapele
Haeba u sa khone ho bula tokomane ea Excel ntle le password, tse latelang ke tse ling tsa likhetho tseo u ka li lekang.
Mokhoa oa 1: Tlosa Password ho Excel File ka Passper bakeng sa Excel
Bakeng sa monyetla o motle oa katleho, o kanna oa batla ho sebelisa lenaneo le matla: Passper bakeng sa Excel . Lena ke lenaneo la ho notlolla phasewete le ka u thusang ho qoba password e butsoeng tokomaneng efe kapa efe ea Excel, esita le mofuta oa morao-rao. E na le palo ea likarolo tse etselitsoeng ho etsa hore phasewete a hlaphoheloe bonolo haholo. Li kenyelletsa tse latelang:
- Lebelo le potlakileng la ho bula phasewete : E na le e 'ngoe ea lebelo ka ho fetisisa la ho notlolla phasewete 'marakeng, e khona ho netefatsa li-password tse ka bang 3,000,000 motsotsoana.
- Monyetla o moholo oa ho khutlisa phasewete - E u fa khetho ea ho khetha ho tsoa mefuteng e 4 ea tlhaselo le bukantswe ea limilione tsa li-password tse sebelisoang khafetsa, ho eketsa menyetla ea ho hlaphoheloa ha password le ho fokotsa haholo nako ea ho hlaphoheloa.
- Ha ho tahlehelo ea data : Ha ho data e tokomaneng ea hau ea Excel e tla angoa ka tsela efe kapa efe ke ts'ebetso ea ho hlaphoheloa.
- Tšireletso ea data : Ha ho hlokahale hore u kenye faele ea hau ho seva sa bona, ka hona, lekunutu la hau la data ke 100% e tšepisitsoeng.
- Ha ho na moeli : Lenaneo le lumellana le mefuta eohle ea Windows le liphetolelo tsa Excel. Ho feta moo, ha ho na moeli ho boholo ba faele.
Ena ke tsela eo u ka sebelisang Passper bakeng sa Excel ho notlolla faele ea Excel e sirelelitsoeng ka password.
Mohato oa 1 : Kenya Passper bakeng sa Excel khomphuteng ea hau ebe u e qala. Ka sehloohong fensetere, tobetsa "hlaphoheloa Passwords".
Mohato oa 2 : Tobetsa konopo ea "+" ho khetha tokomane ea Excel eo u batlang ho e sireletsa. Ha tokomane e ekeletsoa lenaneong, khetha mokhoa oa ho hlasela oo u ka ratang ho o sebelisa ebe o tobetsa "hlaphoheloa." Mokhoa oa tlhaselo oo u o khethang o tla itšetleha ka ho rarahana ha phasewete le hore na u na le maikutlo a hore na e ka ba eng.
Mohato oa 3 : Hang ha u khetha mokhoa oa ho hlasela, tlanya konopo ea "hlaphoheloa" 'me Passper bakeng sa Excel e tla qala hang-hang ho sebetsa ho fumana phasewete. Ka mor'a metsotso e seng mekae, tshebetso tla phethoa 'me u lokela ho bona phasewete skrineng.
U ka sebelisa phasewete e fumanoeng ho bula tokomane e sirelelitsoeng ea Excel hona joale.
Mokhoa oa 2: Tlosa phasewete ho faele ea Excel inthaneteng
Ha ho na tlhoko ea ho kenya software khomphuteng ea hau ho hlakola phasewete e bulang tokomaneng ea hau ea Excel. U ka sebelisa e 'ngoe ea lisebelisoa tse ngata tsa inthanete tse etselitsoeng mosebetsi oo. Ho sebelisa sesebelisoa sa marang-rang ho ka ba hantle bakeng sa hau haeba faele e se na lintlha tsa bohlokoa mme password eo ho buuoang ka eona e fokola haholo. Lisebelisoa tse ngata tsa marang-rang li sebelisa mokhoa oa brute force attack recovery 'me ka hona li sebetsa hantle feela ka 21% ea nako. Ho na le lisebelisoa tse ling tsa marang-rang tse nang le sekhahla sa katleho ea 61%, empa ke lisebelisoa tsa pele, ho bolelang hore u tlameha ho lefa ho li sebelisa.
Empa mohlomong phoso e kholo ea ho sebelisa lisebelisoa tsa inthanete ke taba ea hore u tlameha ho kenya faele ea Excel sethaleng sa inthanete. Sena se beha kotsi ho data e faeleng ea Excel kaha ha u tsebe hore na beng ba sesebelisoa sa inthanete ba tla etsa eng ka tokomane ea hau hang ha password e tlositsoe.
Mathata a mokhoa ona:
- Sekhahla sa katleho e tlase : Sekhahla sa ho hlaphoheloa se tlase haholo, se ka tlase ho 100% sekhahla sa katleho.
- Moeli oa boholo ba faele : Li-unlock tsa li-password tsa Excel tsa Marang-rang li lula li na le moeli ho boholo ba faele. Bakeng sa linotlolo tse ling tsa password, boholo ba faele bo ke ke ba feta 10 MB.
- Lebelo le butle la ho hlaphoheloa : Ha u sebelisa Excel password notlolla inthaneteng, o tlameha ho ba le khokahano ea inthanete e tsitsitseng le e matla. Ho seng joalo, ts'ebetso ea ho hlaphoheloa e tla tsamaea butle kapa e be e tsitsitse.
Karolo ea 3: Tlosa phasewete ea Excel ho etsa liphetoho
Joalokaha re boletse pejana, hape ha ho na monyetla oa ho fumana tokomane ea Excel e ke keng ea fetoloa. Mong'a tokomane a ka beha lithibelo tse thatafalletsang basebelisi ho hlophisa litaba tsa tokomane. Tabeng ena, o ka leka e 'ngoe ea litharollo tse latelang:
Mokhoa oa 1: Sebelisa Passper bakeng sa Excel (100% Katleho Rate)
Ntle le ho hlaphoheloa ha password ea Excel, Passper bakeng sa Excel Hape ke sesebelisoa se setle sa ho notlolla li-spreadsheets/worksheets/workbooks tsa Excel. Ka ho tobetsa hanngoe feela, lithibelo tsohle tsa ho hlophisa le ho fometa li ka tlosoa ka sekhahla sa katleho ea 100%.
Mona ke mokhoa oa ho notlolla spreadsheet/bookbook ea hau ea Excel:
Mohato oa 1 : Bula Passper bakeng sa Excel khomphuteng ea hau ebe u tobetsa "Tlosa Lithibelo."
Mohato oa 2 : Tobetsa "Khetha Faele" ho kenya tokomane lenaneong.
Mohato oa 3 : Hang ha tokomane e kenyelelitsoe, tobetsa "Delete" 'me lenaneo le tla tlosa lithibelo leha e le life ho tokomane ka metsotsoana e 2 feela.
Mokhoa oa 2: Tlosa Li-password tsa Excel ka ho Fetola Keketso ea Faele
Haeba u sebelisa MS Excel 2010 kapa pejana, u ka notlolla tokomane ka ho fetola katoloso ea faele. Ke kamoo o e etsang.
Mohato oa 1 : Qala ka ho etsa kopi ea faele ea Excel e sirelelitsoeng ka password, kahoo u na le kopi haeba ho na le ho hong ho sa tsamaeeng hantle.
Mohato oa 2 : Tobetsa faele ka letsohong le letona ebe u khetha "Rename." Fetola katoloso ya faele ho tloha ho “.csv” kapa “.xls” ho ya ho “.zip”.
Mohato oa 3 : Unzip tse ka hare ho faele ea Zip e sa tsoa etsoa ebe u ea ho "xl\worksheets\". Fumana leqephe la mosebetsi leo u batlang ho le notlolla. Tobetsa ho eona ka ho le letona ebe u khetha khetho ea "Edita" ho bula faele ho Notepad.
Mohato oa 4 : Sebelisa mosebetsi oa "Ctrl + F" ho bula mosebetsi oa ho batla le ho batla "SheetProtection". U batla mola oa mongolo o qalang ka; «
Mohato 5 : Hlakola mola kaofela oa mongolo ebe u boloka faele ebe u e koala. Joale fetola katoloso ea faele ho .csv kapa .xls.
Ha u sa tla hlola u hloka password ha u batla ho fetola kapa ho fetola leqephe la mosebetsi.
Mathata a mokhoa ona:
- Mokhoa ona o sebetsa feela ho Excel 2010 le liphetolelo tsa pejana.
- O ka notlolla leqephe le le leng feela ka nako. Haeba u na le lipampiri tse ngata tse sirelelitsoeng ka password faeleng ea Excel, u tlameha ho pheta mehato e kaholimo bakeng sa leqephe ka leng.
Mokhoa oa 3: Fumana Password ea Excel ka Google Sheets
Google Drive e lokolotse ntjhafatso e ncha ho tšehetsa litokomane tsa MS Office tse sirelelitsoeng ka password. Google Drive e fana ka mokhoa o thata haholo oa ho notlolla tokomane efe kapa efe ea Excel ha u batla ho e fetola. Mehato e latelang e tla u bolella mokhoa oa ho bula faele ea Excel e sirelelitsoeng ka password ho Google Sheets.
Mohato oa 1 : Eya ho Google Drive ho sebatli sefe kapa sefe se komporong ea hau 'me u kene haeba ha u so kene.
Mohato oa 2 : Tobetsa "Ncha" tab ebe u khetha Google Sheets. Haeba u se u kentse faele ea hau ea Excel e notletsoeng ho Drive ea hau, u ka khetha "Open" ho bula faele ka kotloloho. Ho seng joalo, o tlameha ho kenya faele ea hau ka ho tobetsa khetho ea "Import".
Mohato oa 3 : Joale bula tokomane e sirelelitsoeng ea Excel ebe u tobetsa hukung e kaholimo ho le letšehali ho khetha lisele tsohle tse tokomaneng eo.
Mohato oa 4 : Tobetsa "Kopitsa" kapa tobetsa Ctrl + C.
Mohato 5 : Joale tsamaisa lenaneo la hau la MS Excel ebe o tobetsa Ctrl+ V. Lintlha tsohle tse ho phasewete e sirelelitsoeng ea Excel spreadsheet li tla fetisetsoa bukeng ena e ncha ea mosebetsi. Joale u ka fetola tokomane ka tsela efe kapa efe eo u e batlang.
Mathata a mokhoa ona:
- Mokhoa ona o nka nako haeba ho na le maqephe a mangata a notletsoeng tokomaneng ea hau ea Excel.
- Google Sheets e hloka khokahano e tsitsitseng ea Marang-rang ho kenya lifaele. Haeba khokahanyo ea hau ea Marang-rang e fokola kapa faele ea hau ea Excel e le kholo, ts'ebetso ea ho kenya e tla tsamaea butle kapa ea senyeha.
Tsela ea 4. Tlosa Password ea Excel Spreadsheet ka VBA Code
Mokhoa oa ho qetela oo re tla o sheba ke ho sebelisa khoutu ea VBA ho notlolla Excel spreadsheet. Mokhoa ona o tla sebetsa feela ho Excel 2010, 2007, le liphetolelo tsa pejana. Ke habohlokoa ho hlokomela hore mokhoa ona o ka tlosa password feela leqepheng la mosebetsi. Mokhoa oa ho notlolla o rarahane, kahoo mehato e latelang e tla ba molemo.
Mohato oa 1 : Bula phasewete e sirelelitsoeng Excel spreadsheet le MS Excel. Tobetsa "Alt+F11" ho kenya VBA fensetere.
Mohato oa 2 : Tobetsa "Insert" ebe u khetha "Module" ho tsoa likhethong.
Mohato oa 3 : Kenya khoutu e latelang fensetereng e ncha.
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
Mohato oa 4 : Tobetsa F5 ho phethahatsa taelo.
Mohato 5 : Ema hanyane. Lebokose le lecha la puisano le tla hlaha ka password e ka sebelisoang. Click "OK" 'me joale koala VBA fensetere.
Mohato oa 6 : Khutlela ho Excel spreadsheet ea hau e sirelelitsoeng. Joale, u tla fumana hore leqephe la mosebetsi le hlahlojoe.
Mathata a mokhoa ona:
- Haeba ho na le maqephe a mangata a sirelelitsoeng ka password Excel ea hau, u tlameha ho pheta mehato e ka holimo bakeng sa leqephe ka leng la mosebetsi.
Qetello
Ho tlosa phasewete tokomaneng ea Excel ha ho hlokahale hore ho be thata. Ka lebelo la ho hlaphoheloa ka potlako, mekhoa e mengata ea tlhaselo le sekhahla se phahameng sa ho hlaphoheloa, Passper bakeng sa Excel e fana ka khetho e ntle ea ho tlosa password kapele ho tokomane efe kapa efe ea Excel.
![Mokhoa oa ho tlosa phasewete ho Excel VBA Project [Mekhoa e 4]](https://www.passmapa.com/images/desbloquear-proyecto-vba-excel-390x220.png)