Thaum ua hauj lwm nrog cov ntaub ntawv Excel, tsis muaj cov ntaub ntawv tsuas yog thaum koj xav tau tus duab rau hauv ib daim ntawv, tiam sis tseem nrawm nrawm qhov twg ntawm daim duab, ntawm qhov tsis yog, yuav tsum tau muab rho tawm hauv phau ntawv. Yuav ua kom tiav lub hom phiaj, muaj ob txoj kev. Txhua ntawm lawv yog qhov tseem ceeb tshaj plaws hauv qee yam. Cia saib xyuas txhua yam ntawm lawv kom koj tuaj yeem txiav txim xyuas seb cov kev xaiv twg yog qhov zoo tshaj plaws nyob rau hauv cov ntaub ntawv.
Saib kuj: Yuav ua li cas extract duab los ntawm Microsoft Word ntawv
Extract Images
Lub ntsiab qauv rau kev xaiv ib hom kev yog qhov tseeb seb koj xav kom rub tawm ib tus duab tib los yog ua kom muaj kev tawm suab loj heev. Nyob hauv rooj plaub thawj zaug, koj tuaj yeem txaus siab rau cov luam ntawv luam tawm, tab sis hauv ob koj yuav tsum tau thov cov txheej txheem hloov tshiab kom tsis txhob muab cov sij hawm xa rov qab txhua daim duab cais.
Txoj Cai 1: Luam
Tab sis, ua ntej ntawm tag nrho cov, peb tseem xav txog kev rho tawm cov duab los ntawm cov ntaub ntawv uas siv hom qauv.
- Yuav kom luam tau cov duab, ua ntej txhua yam koj xav tau los xaiv nws. Ua li no, nyem rau ntawm nws ib zaug nrog rau nas khawm. Tom qab ntawd peb txoj cai-nias ntawm kev xaiv, yog li hu lub ntsiab lus teb cov ntawv qhia. Hauv daim ntawv uas tshwm sim, xaiv qhov khoom "Daim qauv".
Koj tuaj yeem tau tom qab xaiv cov duab mus rau lub tab "Tsev". Muaj nyob rau hauv daim kab xev hauv lub nras cov cuab yeej "Ntawv Teev Npe" nyem rau ntawm lub cim "Daim qauv".
Nws muaj kev xaiv thib peb hauv, tom qab xaiv, koj yuav tsum tau nias ib qho tseem ceeb ua ke Ctrl + C.
- Tom qab ntawd, khiav cov duab editor. Koj tuaj yeem, piv txwv, siv cov txheej txheem txheej txheem Ximuas yog ua rau hauv qhov rais. Peb ua ib qho ntxig rau hauv qhov kev pab cuam no hauv ib qho ntawm cov hauv kev uas muaj nyob hauv. Nyob rau hauv feem ntau cov kev xaiv, koj siv tau lub txoj kev universal thiab ntaus lub ntsiab ua ke Ctrl + V. Nyob rau hauv Ximdua li no, koj tuaj yeem nias ntawm khawm Muab tshuaj txhuamnyob rau ntawm daim kab xev hauv lub nras cov cuab yeej "Ntawv Teev Npe".
- Tom qab ntawd, daim duab yuav muab tso rau hauv cov duab editor thiab tuaj yeem tau txais kev cawmdim raws li cov ntaub ntawv uas muaj nyob rau hauv qhov kev xaiv.
Qhov zoo ntawm qhov no yog qhov uas koj tus kheej tuaj yeem xaiv cov hom ntaub ntawv uas txuag tau daim duab, los ntawm cov kev xaiv txhawb kev xaiv cov duab xaiv.
Txoj kev 2: Txim duab Extraction
Tab sis, ntawm chav kawm, yog tias muaj ntau tshaj li ib lub teb los sis txawm ntau pua dluab, thiab tag nrho cov ntawm lawv yuav tsum tau muab rho tawm, ces tus qauv saum no zoo nkaus li tsis zoo. Rau cov hom phiaj, nws tseem tau hloov cov ntaub ntawv Excel rau HTML. Hauv qhov no, tag nrho cov dluab yuav tau txais kev cawm dim rau hauv ib phau ntawv tais tseg rau ntawm lub hard disk ntawm lub computer.
- Qhib ib daim ntawv Excel uas muaj duab. Mus rau lub tab "Cov Ntaub Ntawv".
- Nyob rau hauv lub qhov rais qhib, nyem qhov khoom "Tseg Rau"uas yog nyob rau hauv nws sab laug.
- Tom qab qhov kev txiav txim no pib pib khaws cia daim ntawv qhia tseg. Peb yuav tsum tau mus rau hauv phau ntawv ntawm lub hard disk uas peb xav kom muaj ib phau ntawv nrog cov duab. Teb "Filename" tuaj yeem tsis tau hloov tsis tau, txij li peb lub hom phiaj nws tsis tseem ceeb. Tab sis nyob hauv daim teb "Cov Ntaub Ntawv Siv" yuav tsum xaiv qhov muaj nqis "Lub Webpage (* .htm; * .html)". Tom qab teeb tsa saum toj no, nyem rau ntawm lub pob "Txuag".
- Tej zaum, lub thawv ntawv yuav tshwm sim, qhia rau koj paub tias cov ntaub ntawv yuav muaj kev qhia tsis txaus. "Qhov Web Page", thiab lawv yuav poob thaum lub sij hawm hloov siab los ntseeg. Peb yuav tsum pom zoo los txhaj ntawm lub pob. "OK", txij li lub hom phiaj ntawm tib leeg yog los muab cov duab.
- Tom qab no qhib Qhov rai Explorer lossis lwm tus neeg saib xyuas cov ntaub ntawv thiab mus rau hauv qhov chaw koj khaws tseg cov ntawv. Hauv phau ntawv no yuav tsum muaj ib daim nplaub tshev uas muaj lub npe ntawm daim ntawv. Cov ntawv qhia no muaj cov duab. Mus rau nws.
- Raws li koj tau pom, cov duab uas nyob hauv Excel daim ntawv raug nthuav tawm hauv daim nplaub tshev no yog cais cov ntaub ntawv. Tam sim no koj tuaj yeem ua tib lub tswv yim nrog lawv raws li nrog cov dluab zoo tib yam.
Kev thaij duab los ntawm Excel cov ntaub ntawv tsis yog ib qho nyuaj li nws pom thaum xub thawj siab. Qhov no yuav ua tau los ntawm kev luam cov duab, los yog los ntawm kev khaws cov ntaub ntawv ua ib qhov web page uas siv cov cuab yeej ntawm Excel.
