Pulihkeun Dokumén sareng Spreadsheets anu teu disimpen, ditimpa, atanapi ruksak¶
Nomer darurat béda-béda dumasar nagara. Kaca ieu nganggo 911, nomer pikeun Amérika Serikat sareng Kanada. Seueur nagara sanés nganggo 112, 999, atanapi nomer sanés. Panggihan nomer pikeun nagara anjeun.
Nutup kontrak Microsoft Word 40 halaman atanapi modél kauangan Excel anu rumit ku ngaklik "Tong Simpen", ningali komputer anjeun kacilakaan sateuacan anjeun pencét Ctrl + S, ngahaja nyimpen hiji template kosong dina file master taun ka tukang, atawa narima dreaded "Word ngalaman kasalahan nyobian muka file" menit dialog saméméh deadline a karasaeun catastrophic. Kusabab aplikasi produktivitas modern nahan éditan aktip dina panyangga RAM anu volatile sareng diréktori pementasan samentawis disumputkeun (AutoRecover .asd, .wbk, .tmp, jeung UnsavedFiles), nyieun gerakan anu salah dina 60 detik kahiji tiasa nyababkeun aplikasi ngabersihkeun file pementasan éta salamina.
Malah nalika a .docx, .xlsx, .pptx, atawa .odt file sabenerna ruksak dina disk, ** téks anjeun sarta nomer spreadsheet ampir pernah musna . XML Open Office Modern (.docx, .xlsx, .pptx) jeung OpenDocument (.odt, .ods) file sabenerna ** baku .zip wadah arsip nahan file XML téks polos (word/document.xml atawa xl/worksheets/sheet1.xml). Sanaos diréktori sentral ZIP luar dipotong ku leungitna kakuatan atanapi tarikan USB flash drive, anjeun tiasa nimba 99 persén prosa sareng rumus anjeun langsung kaluar tina aliran XML atah dina kaayaan lima menit.
Laksanakeun ieu ayeuna¶
- STOP nulis file anyar, masang program recovery, atawa rebooting komputer Anjeun. Lamun hiji aplikasi ngadat atawa anjeun ngaklik "Ulah Simpen", file pementasan samentara (
.asd,.tmp, atawa-$file konci) linggih dina sistem operasi anjeunAppDataatawa/tmpdiréktori ayeuna. Dina Solid-State Drives (SSDs) kalawanTRIMdiaktipkeun, nyimpen file badag atawa masang bloatware "perbaikan dokumen" alat kana drive sarua permanén bakal nol kaluar blok flash unallocated nyekel buffers temp Anjeun dihapus. - ** Upami anjeun ngan ukur nimpa petikan téks kritis di jero dokumen STILL-OPEN sareng pencét
Ctrl + S(Simpen), ULAH nutup jandela, pencétCtrl + Z(Command + Zdina Mac) sababaraha kali.** Dina Microsoft Word, Excel, LibreOffice, Google Docs, sareng Apple Pages, ngaklik "Simpen" nyerat kaayaan ayeuna ka disk tapi TEU mupus tumpukan Undo di-memori salami jandela dokumen tetep kabuka. MencétanCtrl + Z50 atanapi 100 kali bakal mundur saatos nyimpen teu kahaja anjeun sareng malikkeun paragraf anu dihapus, anu teras anjeun tiasa nyalin kana file énggal. - ** Saméméh noél a ruksak
.docx,.xlsx,.pdf, atawa.sqlitefile, duplikat dua kali (Copy 1jeungCopy 2) kana polder anu aman.** Ulah ngajalankeun "Buka sareng Perbaikan" Microsoft Word,zip -FF, atawasqlite3 .recoverlangsung dina hiji-hijina salinan aslina anjeun tina file ruksak. Salawasna dianggo dina duplikat supados upami utilitas perbaikan motong méja anu teu tiasa dibaca, bait atah asli anjeun tetep teu kacekel pikeun ékstraksi forensik anu langkung jero. - ** Pariksa disumputkeun
UnsavedFilesdiréktori di Microsoft Word, Excel, jeung PowerPoint langsung.** Sanajan anjeun sacara eksplisit ngaklik "Ulah Simpen" dina dokumen Kantor anyar atawa dirobah, Microsoft Word modern, Excel, jeung PowerPoint cicingeun nahan salinan AutoRecover..asdsnapshot jero%LOCALAPPDATA%\Microsoft\Office\UnsavedFilessalila opat poé saméméh ngahapus eta. Buka **File> Info> Atur Dokumén> Pulihkeun Dokumén Anu Henteu Disimpen ** (atanapi ** Pulihkeun Buku Kerja Anu Henteu Disimpen ** dina Excel) pikeun langsung nyandak éta. - Upami anjeun ngahaja disimpen dina file anu disimpen dina OneDrive, Google Drive, Dropbox, iCloud Drive, atanapi SharePoint, balikkeun deui via Riwayat Versi Wéb dina 30 detik. Mesin singkronisasi awan henteu nimpa file sacara ngaruksak; unggal waktu
Ctrl + Snyingkronkeun kana awan, server appends snapshot timestamped kana file **Vérsi Riwayat ** (nahan panungtungan 25 nepi ka 500 versi pikeun 30 poé). Klik-katuhu file -> Vérsi Riwayat pikeun mulangkeun menit pasti saméméh kasalahan. - Jaga perspéktif salami kaayaan darurat akademik, hukum, atanapi médis anu setrés luhur. Henteu aya hamparan atanapi skripsi anu leungit anu matak krisis kaséhatan fisik. Upami anjeun nyobian cageur arahan médis kritis atanapi rékaman darurat nalika aya ancaman kasalametan hirup anu aktip, prioritaskeun kasalametan manusa heula sareng nelepon nomer darurat lokal anjeun (911 di Amérika Serikat sareng Kanada, 112 di Uni Éropa, 999 di Inggris, atanapi tingali kami. nomer darurat diréktori).
Entong mayar 'Situs Perbaikan DOCX/XLSX Online' atanapi unggah file hukum, médis, atanapi pajeg rahasia ka portal perbaikan awan pihak katilu
Puluhan situs web predatory pangkat di luhureun mesin pencari ngaku "Ngalereskeun Koruptor Kecap & Excel Payil Online." Seuseueurna situs ieu ngan saukur ngajalankeun open source gratis zip -FF atawa xmllint paréntah dina server maranéhna, némbongkeun Anjeun sawangan kabur tina téks anjeun sorangan, jeung paménta 29 ka 49 dollar dina Bitcoin atawa pangmayaran kartu kiridit pikeun ngundeur file XML, bari panén balik pajeg rahasia Anjeun, kecap akses, atawa kontrak légal dina server asing untrusted. Anjeun tiasa ngalakukeun ékstraksi ZIP/XML anu sami sacara lokal dina komputer anjeun nyalira dina 60 detik gratis nganggo léngkah-léngkah di handap ieu.
Dokumén & spreadsheet recovery triage tangkal kaputusan¶
flowchart TD
Start["Darurat Dokumén: File Henteu Disimpen, Ditimpa, atanapi Korupsi"] --> Scenario{"Kagagalan mana anu kakara lumangsung?"}
Scenario -->|"1. Diklik 'Ulah Simpen' atawa App nabrak Sateuacan Simpen"| UnsavedPath["Lengkah 1: Pariksa File> Info> Atur Dokumén> Pulihkeun Dokumén Anu Henteu Disimpen<br/>Lengkah 2: Salin sadaya file .asd, .xlb, sareng .tmp tina AppData\Local & Roaming\Microsoft\Word/Excel<br/>Lengkah 3: Dina Mac, pariksa folder $TMPDIR/TemporaryItems"]
Scenario -->|"2. Ngahaja Nimpa File sareng Pencét Simpen (Ctrl + S)"| OverwritePath{"Naha Jandéla Dokumén Masih Dibuka?"}
OverwritePath -->|"Sumuhun: Masih Buka"| UndoNow["Pencét Ctrl + Z (Cmd + Z) sababaraha kali -> Salin téks anu pulih ka file énggal -> Simpen Salaku"]
OverwritePath -->|"No: Geus Tutup"| VersionPath["Lengkah 1: Pariksa Riwayat Vérsi Awan (OneDrive, Google Drive, Dropbox, iCloud)<br/>Lengkah 2: Dina Windows, pariksa NTFS Volume Shadow Copies ('Versi Saméméhna' / ShadowExplorer)<br/>Lengkah 3: Dina Mac, pariksa APFS Local Snapshots, Time Machine, atawa 'Balikkeun Ka > Kotektak Sadaya Versi'"]
Scenario -->|"3. File Nolak Buka ('Koropak Korupsi / Eusi Teu Bisa Dibaca')"| CorruptPath{"Naon Jenis File Anu Rusak?"}
CorruptPath -->|"Modern Office (.docx, .xlsx, .pptx) atawa LibreOffice (.odt, .ods)"| ZipXML["1. Duplikat file -> Coba 'Buka sareng Perbaikan' dina Word / Excel atanapi buka di LibreOffice<br/>2. Ganti ngaran salinan jadi .zip -> Jalankeun '7z x' atawa 'zip -FF' -> Extract word/document.xml atawa xl/sharedStrings.xml"]
CorruptPath -->|"Kantor Binér Warisan (.doc, .xls) atanapi PDF (.pdf)"| BinaryFix["Ékstrak string via 'Recover Text from Any File' ATAWA ngalereskeun tabel xref PDF nganggo 'qpdf --decrypt' / 'mutool clean'"]
CorruptPath -->|"SQLite Database (.sqlite, .db) atanapi CSV"| DBFix["Jalankeun 'sqlite3 corrupt.db \".recover\"| sqlite3 fixed.db 'pikeun ngawangun deui kaca B-tangkal"]
Skenario 1: Pulihkeun dokumén anu UNSAVED (Saatos ngaklik "Ulah Simpen" atanapi Kacilakaan Aplikasi)¶
Nalika anjeun damel dina aplikasi Microsoft Word, Excel, PowerPoint, LibreOffice, atanapi Adobe, program éta nyerat jepretan AutoRecover periodik (default unggal 10 menit) sareng panyangga swap samentawis (-WRDxxxx.tmp) kana polder sistem disumputkeun.
Jalur file disumputkeun persis pikeun file anu teu disimpen & AutoRecover dina Windows, macOS, sareng Linux¶
Buka File Explorer, Finder (Cmd + Shift + G), atanapi jandela Terminal sareng pariksa diréktori anu pasti ieu ** langsung sateuacan muka sareng nutup aplikasi sababaraha kali **:
| Aplikasi & OS | Path Diréktori Path Ngandung teu disimpen .asd, .tmp, sareng AutoRecover Payil |
Ekstensi File Pikeun Milarian |
|---|---|---|
| Microsoft Word, Excel & PowerPoint (Windows) | 1. %LOCALAPPDATA%\Microsoft\Office\UnsavedFiles (Koropak dimana anjeun ngaklik "Ulah Simpen")2. %APPDATA%\Microsoft\Word\(atawa \Excel\ / \PowerPoint\)3. %LOCALAPPDATA%\Temp\ |
.asd (Snapshot AutoRecover), .wbk (Cadangan Kecap), .xlb / .xar (Excel AutoRecover), -WRD*.tmp, -WRL*.tmp |
| Microsoft Word, Excel & PowerPoint (macOS) | 1. -/Library/Containers/com.microsoft.Word/Data/Library/Preferences/AutoRecovery(ngaganti Word kalawan Excel atawa Powerpoint)2. ** Sesi Temp Polder **: ngajalankeun open $TMPDIR di Terminal sareng buka TemporaryItems subfolder |
AutoRecovery save of *.docx, .asd, -WRL*.tmp |
| Panulis LibreOffice / Calc / Impress (Windows, macOS, Linux) | Windows: %APPDATA%\LibreOffice\4\user\backup\macOS: -/Library/Application Support/LibreOffice/4/user/backup/Linux: -/.config/libreoffice/4/user/backup/ jeung /tmp/lu* |
.bak, .odt_0.odt, lu*.tmp |
| Apple Pages, Numbers & Keynote (macOS) | 1. -/Library/Containers/com.apple.iWork.Pages/Data/Library/Autosave Information/2. -/Library/Application Support/CloudDocs/session/containers/ |
.pages, .numbers, .key bungkusan bungkusan |
| Notepad ++ & Kode VS (Malah pikeun Tab anu Teu Disimpen Ngaranna) | Notepad++: %APPDATA%\Notepad++\backup\Kode VS (Meunang): %APPDATA%\Code\User\History\ & %APPDATA%\Code\Backups\Kode VS (Mac): -/Library/Application Support/Code/User/History/ |
new 1@2026-..., timestamped JSON / snapshot sajarah téks |
Hiji-paréntah PowerShell & macOS / skrip Linux pikeun panén sadaya file temp Office ayeuna¶
Gantina ngaklik sapuluh polder disumputkeun sacara manual, jalankeun skrip nyalametkeun anu dibaca wungkul ieu pikeun nyalin unggal anu salamet. .asd, .wbk, jeung Kantor .tmp file dirobah dina 48 jam panungtungan kana folder dina Desktop anjeun:
- Dina Windows (Jalankeun dina PowerShell):
$RescueDir = "$env:USERPROFILE\Desktop\Document_Rescue" New-Item -ItemType Directory -Force -Path $RescueDir | Out-Null $SearchPaths = @( "$env:LOCALAPPDATA\Microsoft\Office\UnsavedFiles", "$env:APPDATA\Microsoft\Word", "$env:APPDATA\Microsoft\Excel", "$env:APPDATA\Microsoft\PowerPoint", "$env:LOCALAPPDATA\Temp" ) Get-ChildItem -Path $SearchPaths -Include "*.asd","*.wbk","*.xar","~WRD*.tmp","~WRL*.tmp","*.docx","*.xlsx" -Recurse -Force -ErrorAction SilentlyContinue | Where-Object { $_.LastWriteTime -gt (Get-Date).AddHours(-48) } | ForEach-Object { Copy-Item $_.FullName -Destination (Join-Path $RescueDir ($_.LastWriteTime.ToString("HHmmss_") + $_.Name)) -Force } Write-Host "Copied all candidate recovery files to $RescueDir" - Dina macOS / Linux (Jalankeun di Terminal):
mkdir -p ~/Desktop/Document_Rescue find ~/Library/Containers/com.microsoft.* "$TMPDIR" ~/.config/libreoffice /tmp \ \( -iname "*.asd" -o -iname "*AutoRecovery*" -o -iname "~WR*.tmp" -o -iname "*.bak" \) \ -mtime -2 -exec cp -p {} ~/Desktop/Document_Rescue/ \; 2>/dev/null ls -la ~/Desktop/Document_Rescue/ - ** Kumaha carana muka pulih
.asdatawa-WRLxxxx.tmpfile**: Ulah ganda-klik an.asdfile dina File Explorer (Windows sering ngaku teu tiasa dibuka.asdlangsung). Gantina, buka Microsoft Word -> klik File> Open> Browse -> ganti dropdown tipe file di pojok katuhu handap ka "All Files (*.*)" -> pilih.asdatawa.tmpfile jero AnjeunDocument_Rescuepolder.
Skenario 2: Pulihkeun file OVERWRITTEN (Nalika anjeun simpen dina file anu saé sareng nutup aplikasi)¶
Upami anjeun ngahaja muka hamparan master bulan kamari, ngahapus satengah tab, pencét **Ctrl + S (Simpen) ** tinimbang * Simpen Salaku *, sarta geus ditutup program, panyangga Undo di-memori leungit. Tapi, sistem file modern sareng klien singkronisasi ngajaga blok sajarah ngaliwatan lima mékanisme:
1. Riwayat Versi Cloud Sync (OneDrive, SharePoint, Google Drive, Dropbox, iCloud)¶
Lamun file cicing di jero Anjeun Desktop, Documents, atawa folder awan disingkronkeun ku OneDrive, Dropbox, Google Drive, atawa iCloud:
- Microsoft OneDrive / SharePoint: Klik-katuhu file dina File Explorer (atawa log in onedrive.live.com) -> klik Riwayat versi. Klik tilu titik (...) gigireun timestamp ti saméméh kasalahan anjeun sarta klik Mulangkeun.
- Google Drive (malah pikeun pribumi .docx / .xlsx file disingkronkeun via Drive for Desktop): Klik katuhu file dina drive.google.com -> Inpormasi file> Atur vérsi, atanapi buka dokumén teras pencét Ctrl + Alt + Shift + H pikeun ningali sajarah révisi lengkep.
- Dropbox: Klik-katuhu filena -> Riwayat versi (nahan unggal simpen salila 30 nepi ka 180 poé; sanajan anjeun nimpa 100 payil sakaligus, Dropbox Rewind ngagugulung sakabéh polder deui ka sababaraha menit).
- Apple iCloud Drive & macOS Native Versioning (NSDocument Versi): Dina macOS, buka file anu ditimpa dina Pages, Numbers, Keynote, TextEdit, or Preview teras klik File > Revert To > Browse All Versions... tina bar menu luhur. macOS mertahankeun basis data versi internal SQLite / dokumen chunked (/.DocumentRevisions-V100) dina drive APFS anjeun sanajan anjeun teu make Time Machine.
2. Windows NTFS Volume Shadow Copies (Previous Versions jeung ShadowExplorer)¶
Malah dina lokal C: drive anu henteu disingkronkeun kana awan naon waé, Windows sacara périodik nyiptakeun snapshot blok titik-waktos anu dibaca wungkul tina drive anjeun anu disebut Volume Shadow Copies (VSS) salami titik pamulihan atanapi apdet sistem:
1. Klik-katuhu kana file anu ditimpa (atanapi folder indungna anu nahanana) dina File Explorer -> klik Properties -> tab saméméhna Versi.
2. ** Lamun Previous Versions tab némbongan kosong, ulah eureun di dinya **: Windows 10 jeung 11 remen nyumputkeun snapshots VSS aya dina File Explorer GUI bari jilid kalangkang masih diuk gembleng dina disk.
3. Buka ** Administrator Command Prompt ** sareng pariksa upami aya salinan bayangan:
vssadmin list shadows daptar hiji atawa leuwih HARDDISKVOLUME_SHADOWCopy volume (contona, \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy3), numbu snapshot éta langsung ka polder dina anjeun C: drive ku kituna anjeun tiasa ngotéktak éta sareng nyalin dokumén anu tos ditimpa anjeun:
Buka C:\ShadowRescue\Users\YourName\Documents\ dina File Explorer sareng salin vérsi file anjeun anu gembleng.
3. macOS APFS Lokal Snapshots (tmutil listlocalsnapshots)¶
Sanaos drive cadangan Mesin Time éksternal anjeun parantos dicabut dina pacilingan salami dua minggu, macOS otomatis nyiptakeun **APFS Lokal Snapshots ** langsung dina Mac SSD internal anjeun:
# List all hidden local APFS snapshots stored on your internal Mac SSD
tmutil listlocalsnapshots /
# Mount a local snapshot read-only to extract the pre-overwritten file
mkdir -p /tmp/apfs_rescue
sudo mount_apfs -s com.apple.TimeMachine.2026-10-31-093000.local /System/Volumes/Data /tmp/apfs_rescue
cp "/tmp/apfs_rescue/Users/$USER/Documents/MyContract.docx" ~/Desktop/MyContract_Recovered.docx
Skenario 3: Ngalereskeun KORUPSI .docx, .xlsx, .pptx, jeung .odt file (Metode Ekstraksi Bedah ZIP + XML)¶
Naha dokumén Kantor modern ngaruksak? Dimimitian ku Microsoft Office 2007, .docx, .xlsx, jeung .pptx file (ogé LibreOffice .odt, .ods, jeung .odp file) nyaéta ** sanes file binér monolitik tunggal **. Unggal .docx atawa .xlsx file sabenerna mangrupa ** arsip PKZIP baku ** ngandung tangkal polder jeung file XML UTF-8.
Lamun USB flash drive dicabut colokan tanpa ejecting, pangsa jaringan turun nalika nyimpen, atawa Word ngadat di tengah nulis, ZIP Central Directory Header di tungtung file bakal dipotong, atawa tag XML tunggal dina. word/document.xml gagal nutup. Microsoft Word sareng Excel gaduh parser XML anu ketat pisan: upami hiji bait dina footer ZIP atanapi skéma XML salah, Word nolak muka sadaya dokumén 50 halaman.
Lengkah 1: Coba 3 diwangun-di non-destructive parser overrides munggaran¶
Sok duplikat file anjeun anu rusak (Contract_Copy.docx) sateuacan nguji tilu perbaikan gancang ieu:
- Microsoft Office Built-In "Buka sareng Perbaikan":
- Jalankeun Word, Excel, atanapi PowerPoint -> klik File> Open> Browse (ulah ** henteu ** klik file tina daptar "Recent Files").
- Pencét sakali dina file duplikat anjeun anu rusak pikeun nyorotna.
- Pencét ** panah ka handap leutik (
▼) di sisi katuhu tina[ Open | ▼ ]tombol** di katuhu handap kotak dialog, tur pilih "Buka jeung Perbaikan...". - Dina Excel, upami Perbaikan gagal, malikan deui lengkah sareng pilih "Extract Data" -> "Convert to Values" or "Recover Rumus".
- ** Buka Korupsi
.docx/.xlsxdi jero LibreOffice atanapi Google Docs **: - Panulis LibreOffice sareng Calc (gratis, open-source di
libreoffice.org) nganggo parser XML sareng ZIP anu langkung ngahampura, toleran kana kasalahan tibatan Microsoft Office. Dina kasarna 60 persén kasus dimana Microsoft Word atanapi Excel sagemblengna nampik muka file ruksak, muka éta persis sarua..docxatawa.xlsxfile di jero LibreOffice muka sakabéh dokumén bersih tur ngidinan Anjeun klik **File> Simpen Salaku ** nulis kaluar brand-anyar, spésifikasi-patuh.docxatawa.xlsxberkas. - ** Dina Excel: Rujukan Sél Buku Kerja Rusak tina Buku Kerja Kosong Anyar (Ekstrak Patalina Eksternal)**:
- Lamun hiji ruksak
.xlsxatawa.xlsworkbook ngadat Excel unggal waktos Anjeun nyobian muka éta, anjeun tiasa narik nilai sél atah kaluar tanpa kantos muka file korup: - Buka buku kerja Excel kosong anyar.
- Dina sél
A1, ngetik rujukan rumus éksternalSheet1tina file rusak anjeun: - Pencét
Enter. Excel maca aliran sél BIFF/XML atah kaluar disk tanpa rendering nu corrupt grafik, macros, atawa gaya. Séréd gagang eusian kana kolomAngaliwatanZtur handap 1.000 baris pikeun narik kaluar unggal angka tunggal jeung string téks dina lambar, teras salin sadaya sél jeung ** Témpél Nilai (Ctrl + Alt + V -> Values)**.
Léngkah 2: Métode Ekstraksi ZIP + XML (Ménggalkeun 99% téks / nomer nalika "Buka sareng Perbaikan" gagal)¶
Upami duanana Kantor "Buka sareng Perbaikan" sareng LibreOffice gagal kusabab éta .docx, .xlsx, .pptx, atawa .odt Wadah ZIP dipotong, ekstrak file XML internal langsung:
Anatomi hiji Office Open XML (.docx / .xlsx / .pptx) arsip¶
| Tipe File Luar | Ganti ngaran Extension Ka | File XML Internal Nyepeng Karya Saleresna Anjeun | Naon deui Hirup di jero Arsip |
|---|---|---|---|
Dokumén Kecap (.docx) |
.zip |
word/document.xml (100% téks badan)word/header1.xml, word/footer1.xml, word/footnotes.xml |
word/media/ (Unggal poto anu dipasang, PNG, sareng JPEG dina resolusi asli 100%) |
** Buku Tugas Excel (.xlsx)** |
.zip |
xl/sharedStrings.xml (Sadaya string téks dina workbook)xl/worksheets/sheet1.xml, sheet2.xml (Sadaya nilai numerik, koordinat sél, jeung rumus) |
xl/media/ (Gambar diselapkeun)xl/calcChain.xml (Sering file anu ngaruksak, ngahapus calcChain.xml ngalereskeun seueur rusak .xlsx file) |
PowerPoint Dek (.pptx) |
.zip |
ppt/slides/slide1.xml, slide2.xml, jsb.ppt/notesSlides/notesSlide1.xml (Catatan panyatur) |
ppt/media/ (Sadaya gambar slide, audio, sareng klip video) |
LibreOffice (.odt / .ods) |
.zip |
content.xml (Sadaya téks dokumén, tabel, sareng sél spreadsheet) |
Pictures/ (Sadaya grafik dipasang) |
Terminal / PowerShell persis paréntah pikeun ngawangun deui arsip ZIP sareng ékstrak prosa atah¶
- ** Jieun salinan file anu rusak sareng ganti nami ekstensina janten
.zip** (contona,BrokenThesis.docx->BrokenThesis.zip). - Paksa-ekstrak file XML sareng Media anu masih aya anu teu malire korupsi header ZIP:
- Nganggo 7-Zip (Windows / Linux / macOS) atanapi
zip -FF(macOS / Linux): Ekstraksi ZIP Windows Explorer standar kaluar lamun footer ZIP ruksak, sedengkeun 7-Zip (7z x) jeung Info-ZIP (zip -FF) scan séktor-demi-sektor ti mimiti file sareng nimba unggal file anu utuh sateuacan titik truncation:# On macOS or Linux: Rebuild the damaged ZIP structure and extract everything zip -FF BrokenThesis.zip --out RepairedArchive.zip unzip -q RepairedArchive.zip -d Extracted_Contents/ # Or using 7-Zip (extracts word/document.xml even if the end of the file is missing): 7z x BrokenThesis.zip -oExtracted_Contents/ - ** Gancang-Fix pikeun Excel
.xlsxFile (calcChain.xml&styles.xmldipiceun)**: - Leuwih satengah tina Excel rusak
.xlsxfile gagal pikeun muka ** wungkul ** sababxl/calcChain.xmlatawaxl/styles.xmlgeus ruksak, barixl/worksheets/sheet1.xmljeungxl/sharedStrings.xmlanu 100 persen gembleng. - Di jero
Extracted_Contents/xl/, ngahapuscalcChain.xml, ulang zip eusiExtracted_Contentsdeui kanaFixedWorkbook.xlsx, sareng buka dina Excel (Excel otomatis ngawangun deuicalcChain.xmldina boot). - ** Ékstrak paragraf anu bersih, tiasa dibaca ku manusa tina anu dipotong
word/document.xml(atawacontent.xml)**: - Komo lamun
word/document.xmldipotong satengahna ku pareum listrik, éta mangrupikeun file téks UTF-8 polos dimana unggal paragraf dibungkus ku<w:p>tag sarta unggal téks ngajalankeun aya di jero<w:t>Your text here</w:t>. - Jalankeun paréntah Python hiji-baris ieu (jalanna dina Windows, macOS, sareng Linux tanpa masang nanaon) pikeun ngaleungitkeun sadaya markup XML sareng ngabuang paragraf anjeun anu bersih kana.
Recovered_Prose.txt:python3 -c " import re, html, pathlib raw = pathlib.Path('Extracted_Contents/word/document.xml').read_text(encoding='utf-8', errors='ignore') raw = re.sub(r'</w:p>', '\n\n', raw) text = html.unescape(re.sub(r'<[^>]+>', '', raw)) pathlib.Path('Recovered_Prose.txt').write_text(text, encoding='utf-8') print('Saved clean text to Recovered_Prose.txt') " - ** Dina Windows PowerShell (upami Python teu dipasang)**:
Skenario 4: Pulihkeun PDF anu rusak, warisan .doc/.xls file, sareng database SQLite¶
1. Ngalereskeun Payil PDF Rusak (Damaged xref table / Failed to load PDF document)¶
File PDF nyimpen objék halamanna ti luhur file ka handap, sareng nempatkeun Table Cross-Reference (xref) jeung %%EOF trailer di pisan handap file ** ngabejaan maca PDF offset bait pasti unggal kaca. Mun hiji kantétan email download atawa mindahkeun scanner eureun di 98 persen, éta xref footer leungit jeung Adobe Acrobat nampik muka file, sanajan 98 persén kaca nu diuk katuhu dina file.
- ** Bangun deui PDF xref tabél otomatis ngagunakeun qpdf, mutool (MuPDF), atanapi Ghostscript (gs):
# Method 1: qpdf (scans raw PDF objects and generates a brand-new xref table)
qpdf --ier-warnings BrokenFile.pdf RepairedFile.pdf
# Method 2: MuPDF mutool clean (salvages damaged PDF streams and fonts)
mutool clean -gggg BrokenFile.pdf RepairedFile.pdf
# Method 3: Ghostscript (re-renders surviving pages into a fresh PDF)
gs -o RepairedFile.pdf -sDEVICE=pdfwrite -dPDFSETTINGS=/prepress BrokenFile.pdf
2. Binér Warisan .doc jeung .xls File (Office 97 to 2003 OLE2 Compound Documents)¶
Leuwih kolot .doc jeung .xls file sanes arsip ZIP; aranjeunna nganggo binér Microsoft ** OLE2 Compound File Binary Format **. Pikeun narik téks kaluar tina rusak .doc file:
- Dina Microsoft Word, angkat ka File> Open> Browse, robih jinis file turun di gigireun kotak nami file tina Sadaya Dokumén Kecap ka Recover Text from Any File (*.*), sareng buka .doc berkas.
- Atanapi dina macOS / Linux, jalankeun antiword Broken.doc > rescued.txt atawa strings -n 6 Broken.doc > rescued.txt.
3. Ngalereskeun Databés SQLite Rusak (.sqlite, .db, Sajarah Browser, Aplikasi Akunting, Apple Notes, Quicken, Zotero)¶
Ratusan aplikasi desktop sareng mobile nyimpen data anjeun dina file database SQLite 3 (.sqlite, .db, .sqlite3). Nalika komputer kaleungitan kakuatan dina pertengahan transaksi sareng anjeun nampi Runtime error: database disk image is malformed (11):
1. ** Kahiji: Simpen dina -wal (Tulis-Payun Log) jeung -shm file dina polder anu sami sareng file .sqlite file nalika nyieun salinan cadangan Anjeun.** Mindeng, karya panganyarna Anjeun can disimpen aya di jero database.sqlite-wal nungguan dipariksa.
2. ** Jalankeun SQLite anu diwangun .recover engine ** (diwanohkeun dina SQLite 3.29+, nu nyeken atah 4KB B-tangkal kaca disk sanajan tabel master schema ruksak tur reconstructs database bersih):
sqlite3, lumpat sqlite3 corrupted.db ".dump" | sqlite3 repaired.db)
4. Pulihkeun Google Docs, Google Sheets, sareng Web Browser Form Text (IndexedDB & RAM Cache)¶
Kumaha upami anjeun ngetik laporan anu panjang di jero Google Docs, Notion, Confluence, atanapi kotak téks browser wéb nalika offline (atanapi nalika tab beku sateuacan nyingkronkeun kana awan)?
- Google Docs / Sheets Offline Panyimpenan Lokal (IndexedDB): Nalika anjeun ngetik dina Google Docs atanapi Google Sheets di jero Chrome atanapi Edge, panyungsi anjeun bakal nyimpen cache mutasi offline dina diréktori profil Chrome lokal anjeun (%LOCALAPPDATA%\Google\Chrome\User Data\Default\IndexedDB\https_docs.google.com_0.indexeddb.leveldb). Entong mupus data browsing browser atanapi kaluar tina Chrome. Sambungkeun deui ka Wi-Fi sareng ngantepkeun tab beku kabuka salami 2 menit supados Service Worker latar tukang tiasa nyiram antrian LevelDB ka server Google, atanapi nyalin teks langsung tina layar nganggo Ctrl + A -> Ctrl + C (atanapi mariksa unsur DOM nganggo F12 Alat pamekar -> Elemen tab ->-klik katuhu dina <div class="kix-page"> titik -> Salin> Salin unsur).
- Malikkeun Téks anu Leungit dina Tab Pangotektak anu Ditutup atanapi Direfresh: Upami anjeun ngahaja nutup atanapi nga-refresh formulir wéb (sapertos aplikasi hibah, tikét dukungan, atanapi formulir asupan médis) saatos ngetik sajam, pencét Ctrl + Shift + T(Command + Shift + T dina Mac) pikeun muka deui tab anu ditutup langsung, teras pencét Ctrl + Z di jero kotak téks, atanapi mariksa dump mémori browser sateuacan nutup prosés browser.
Pencegahan: Konpigurasikeun otomatis-simpen dokumén anti peluru supados anjeun moal kaleungitan padamelan deui¶
Luangkeun tilu menit pikeun ngarobih opat setélan ieu dina aplikasi produktivitas anjeun ayeuna:
- Turunkeun interval Microsoft Office AutoRecover tina 10 menit ka 2 menit: Dina Word, Excel, jeung PowerPoint, buka File > Options > Save, robah "Simpen AutoRecover informasi unggal [2] menit", jeung pariksa "Simpen versi AutoRecovered panungtungan lamun kuring nutup tanpa nyimpen" geus dipariksa.
- ** Aktipkeun "Salawasna jieun salinan cadangan" dina Microsoft Word**: Pindah ka File > Options > Advanced > Save terus centang "Sok nyieun salinan cadangan". Unggal waktos Anjeun pencét
Ctrl + SasupReport.docx, Kecap otomatis nyimpen versi saméméhna salakuBackup of Report.wbkdina folder sarua. - ** Hurungkeun Salinan Nyadangkeun Otomatis LibreOffice **: Buka Tools> Options> Load/Save> General and check "Salawasna jieun salinan cadangan" jeung "Simpen informasi AutoRecovery unggal 5 menit".
- Ulah ngédit dokumén kritis langsung dina USB flash drive anu murah anu tiasa dicabut: Salawasna salin file ka SSD internal anjeun (
Documentsfolder dirojong ku a 3-2-1 strategi cadangan), ngalakukeun pagawean Anjeun lokal, sarta nyalin file rengse kana USB thumb drive ngan sanggeus nutup aplikasi tur ngaklik ** "Aman Cabut Hardware / Eject"**.
Patarosan anu sering ditaroskeun¶
I worked on a Word document for five hours that I opened directly from an Outlook or Gmail attachment, clicked "Save", closed it, and now my changes are nowhere to be found. Where did my file go?
When you double-click an attachment inside desktop Microsoft Outlook or a web browser without clicking "Save As" to your Documents folder first, your computer saves the attachment into a hidden, randomized temporary cache folder (`%LOCALAPPDATA%\Microsoft\Windows\INetCache\Content.Outlook\` on Windows, or `~/Library/Containers/com.microsoft.Outlook/Data/Library/Caches/` on macOS). When you hit `Ctrl + S`, Word saves your five hours of edits into that hidden `Content.Outlook` sub-folder. Open Word immediately, check **File > Open > Recent** (or run the PowerShell/Terminal search script in Scenario 1 above to scan `INetCache` and `Temp` for all `.docx` files modified in the last 24 hours) and save a copy to your Desktop.
Why did my Word document turn into pages of squares, gibberish symbols, or `########` signs when I opened it from a USB flash drive?
Two distinct errors cause this symptom: (1) If the file shows solid pages of `########` or `NUL` (zero-byte `0x00`) characters in a hex editor (`HxD`), the operating system pre-allocated the file size on the FAT32/exFAT USB drive, **but the USB stick was unplugged before the write cache flushed the actual data blocks to flash memory**. In that case, inspect the computer where the file was written for surviving `.asd` / `.tmp` files, or run `chkdsk E: /f` on a copy of the USB drive to check `FOUND.000\FILE0000.CHK` orphan clusters. (2) If the file shows random ASCII symbols starting with the letters `PK` at the very top of page 1, your file is completely fine, you simply opened a modern `.docx` ZIP file using Word's "Recover Text from Any File" filter instead of the normal XML parser.
If I rename a corrupted `.docx` or `.xlsx` file to `.zip`, can I rescue the high-resolution photos and charts embedded inside the document?
Yes, and this is one of the fastest benefits of the Office Open XML format. Inside every `.docx`, `.xlsx`, and `.pptx` archive is a subfolder named `word/media/`, `xl/media/`, or `ppt/media/` (or `Pictures/` inside a LibreOffice `.odt` file). Unlike older binary `.doc` files that compressed images into proprietary streams, modern Office files store every inserted photograph, logo, and diagram as an individual, unencrypted `.png`, `.jpeg`, `.svg`, or `.emf` file inside that `media/` subfolder. Extracting the archive with 7-Zip recovers all embedded images at their full native resolution in seconds.
Can I use undelete software like Recuva or PhotoRec to recover an unsaved Word document that was never saved to disk even once?
Yes, provided you stop using the computer immediately. Even if you never pressed `Ctrl + S` on "Document1", Microsoft Word and LibreOffice still write temporary swap and AutoRecover files (`.asd` and `~WRDxxxx.tmp`) to your storage drive every few minutes once the document exceeds the small RAM buffer. However, if you live on a modern SSD with `TRIM` enabled and close the app properly, those deleted temp blocks may be trimmed quickly, so always copy the live `%LOCALAPPDATA%\Microsoft\Office\UnsavedFiles` directory **before** running a full-disk carver. For deleted files that were previously saved, follow our [accidental file deletion and formatted drive recovery](accidental-file-deletion-formatted-drive-and-photo-recovery.md) guide.
Panungtun patali¶
- Ngahapus file teu kahaja, drive formatna, sareng pamulihan poto
- Gagalna hard drive sareng pamulihan data
- Nyadangkeun komputer: strategi 3-2-1 sareng pamulihan musibah
- Ransomware sareng pamulihan malware
- BitLocker, FileVault, sareng konci konci pamulihan enkripsi LUKS
- Diréktori nomer darurat
Sumber dipariksa¶
- Ecma Internasional & ISO / IEC (Internasional): *ECMA-376 / ISO / IEC 29500 Standar: Kantor Open XML File Format (Buka bungkusan Konvénsi ZIP Wadahna jeung WordprocessingML / SpreadsheetML spésifikasi) *.
- OASIS (Organisasi pikeun Kamajuan Standar Inpormasi Terstruktur): Format OpenDocument (ODF) v1.3 Spésifikasi pikeun Aplikasi Kantor (
.odt,.ods,.odpArsitéktur Paket XML). - Microsoft Diajar Dokuméntasi Resmi: Kumaha Word Nyiptakeun sareng Nyageurkeun AutoRecover (
.asd) jeung Samentara (-WRD*.tmp) Payil, sareng Ngarengsekeun Masalah Dokumén Rusak dina Word sareng Excel. - Dokuméntasi Resmi Konsorsium SQLite: *Korupsi Database, Log Tulis-Payun (
-wal), sarta Ngagunakeun.recoverKomando CLI dina File B-Tree Rusak *. - Adobe / ISO 32000-2 Spésifikasi: *Format Dokumén Portabel (PDF 2.0) Rujukan Silang (
xref) Struktur Méja jeung Pamulihan Aliran *.