Cov tsos mob:

Thaum qhib kev txhim kho los yog tsis zoo Excel XLSX ntawv nrog Microsoft Excel, koj pom cov lus yuam kev li nram no:

Excel pom cov ntsiab lus tsis nyeem tawm hauv. Koj puas xav rov qab teev cov ntsiab lus hauv phau ntawv no? Yog tias koj ntseeg lub hauv paus ntawm phau ntawv no, nyem Yes.

qhov twg filename.xlsx yog lub npe ntawm cov ntawv tsis ncaj los yog tsis zoo hauv Excel.

Hauv qab no yog piv txwv screenshot ntawm cov lus yuam kev:

Excel pom cov ntsiab lus tsis nyeem

Yog tias koj xaiv "Yog", tom qab ntawv Excel yuav sim kho kho cov ntawv Excel. Muaj ob qho xwm txheej, hauv qab no:

1. Excel tsis tuaj yeem kho cov ntawv.

Hauv qhov xwm txheej ntawd, nws yuav ua rau pom cov lus hauv qab no yuam kev:

Excel tsis tuaj yeem qhib cov ntaub ntawv 'filename.xlsx' vim tias cov file format lossis file extension tsis siv tau. Txheeb xyuas tias cov ntawv tsis tau tawg thiab hais tias cov ntawv txuas ntxiv tau raws li cov qauv ntawm cov ntawv.

qhov twg filename.xlsx yog lub npe ntawm cov ntawv tsis ncaj los yog tsis zoo hauv Excel.

Hauv qab no yog qhov screenshot ntawm cov lus yuam kev:

mus zoo-tsis tau-qhib-tus-cov ntawv

2. Excel tuaj yeem kho cov ntawv.

Hauv qhov xwm txheej ntawd, nws yuav qhia cov lus hauv qab no:

Excel tau tuaj yeem qhib cov ntawv los ntawm kev kho lossis tshem tawm cov ntsiab lus tsis txaus ntseeg.

nrog rau cov ntsiab lus raug kho lossis raug tshem tawm hauv qab cov lus.

Hauv qab no yog piv txwv qauv ntawm cov lus:

Excel tau tuaj yeem qhib cov ntawv los ntawm kev kho lossis tshem tawm cov ntsiab lus tsis txaus ntseeg.

Tom qab koj nyem "Kaw" khawm, Excel yuav qhib cov ntawv ruaj khov. Muaj ob qho xwm txheej:

Qee cov ntaub ntawv khaws cia hauv cov ntawv ruaj ruaj, tab sis ntau cov ntaub ntawv yog lost tom qab kev kho / rov qab ua tiav.
Tsis muaj cov ntaub ntawv tiag tiag muaj nyob rau hauv cov ntaub ntawv ruaj ruaj tom qab kev tsim kho / rov ua haujlwm.

Thaum qhib cov ntaub ntawv Excel los ua tsis zoo nrog Microsoft Excel, koj tseem yuav pom cov lus yuam kev zoo ib yam:

Cov ntaub ntawv ua tsis tau zoo thiab tsis tuaj yeem qhib. Txhawm rau sim thiab kho nws, siv qhib thiab Kho qhov hais kom ua nyob rau hauv Qhib Qhib lub thawv, thiab xaiv "Extract Data" thaum hais kom sai.

Hauv qab no yog piv txwv screenshot ntawm cov lus yuam kev:

Excel tau tuaj yeem qhib cov ntawv los ntawm kev kho lossis tshem tawm cov ntsiab lus tsis txaus ntseeg.

Yog tias koj xaiv "OK", ces Excel yuav sim kho kho Excel cov ntawv tsis raug thiab muab cov lus hauv qab no:

Tau tshawb pom qhov tsis raug nyob hauv 'filename.xls,' tab sis Microsoft Office Excel tau qhib cov ntaub ntawv los ntawm kev kho cov npe hauv qab no. Khaw cov ntawv cia los ua cov kev kho no tas mus li.

qhov twg filename.xls yog qhov tsis ncaj XLS cov ntaub ntawv uas raug kho.

Thiab qhov kho kom zoo dua yuav raug teev hauv qab cov lus.

Hauv qab no yog piv txwv qauv ntawm cov lus:

raug-tau-kuaj pom

Tom qab koj nyem "Kaw" khawm, Excel yuav qhib cov ntawv ruaj khov. Txawm li cas los xij, ntau cov ntaub ntawv yog lost tom qab kev kho / rov qab ua tiav.

Nqe Lus Qhia Tshwj Xeeb:

Thaum koj cov ntaub ntawv Excel tsis ncaj thiab qee qhov chaw tsis raug paub los ntawm Excel, tom qab ntawv Excel yuav tshaj tawm cov lus qhia yuam kev no thiab sim kho nws. Txawm li cas los xij, vim muaj qhov txwv rov qab muaj peev xwm ntawm Excel, tom qab kev tsim kho / rov ua dua, tsis muaj cov ntaub ntawv tiag tiag yuav rov qab tau lossis cov ntaub ntawv ntau yuav lost.

tshuaj:

Koj tuaj yeem siv tau DataNumen Excel Repair kom rov zoo Excel cov ntaub ntawv tsis zoo, uas yuav rov qab ua cov ntaub ntawv ntau dua Excel.

Qauv Daim Ntawv 1:

Corrupt XLS cov ntaub ntawv: Yuam Kev4.xlsx

Nrog Excel cov built-in kho muaj nuj nqi, Excel tsis kho cov ntawv.

nrog DataNumen Excel Repair: 100% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev4_fixed.xls

Qauv Daim Ntawv 2:

Corrupt XLS cov ntaub ntawv: Yuam Kev3_1.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 0% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 61% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev3_1_fixed.xls

Qauv Daim Ntawv 3:

Corrupt XLS cov ntaub ntawv: Yuam Kev3_2.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 0% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 36% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev3_2_fixed.xls

Qauv Daim Ntawv 4:

Corrupt XLS cov ntaub ntawv: Yuam Kev3_4.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 0% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 16.7% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev3_4_fixed.xls

Qauv Daim Ntawv 5:

Corrupt XLS cov ntaub ntawv: Yuam Kev3_5.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 0% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 95% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev3_5_fixed.xls

Qauv Daim Ntawv 6:

Corrupt XLS cov ntaub ntawv: Yuam Kev3_7.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 0% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 5% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev3_7_fixed.xls

Qauv Daim Ntawv 7:

Corrupt XLSX cov ntaub ntawv: Yuam Kev2_1.xlsx

Nrog Excel cov kev kho hauv kev ua haujlwm, 50% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 89% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev2_1_fixed.xls

Qauv Daim Ntawv 8:

Corrupt XLS cov ntaub ntawv: Yuam Kev Lawm2_2.xls

Nrog Excel cov kev kho hauv kev ua haujlwm, 50% cov ntaub ntawv ntawm tes tuaj yeem rov qab tau.

nrog DataNumen Excel Repair: 100% cov ntaub ntawv tuaj yeem rov qab tau.

Cov ntaub ntawv tsau los ntawm DataNumen Excel Repair: Yuam Kev2_2_fixed.xlsx

References: