Qhov yuav tsum tau hloov ib lub rooj nrog HTML txuas ntxiv mus rau Excel hom yuav tshwm sim nyob rau hauv ntau yam. Tej zaum nws yuav tsim nyog hloov cov nplooj ntawv Web no hauv Internet los yog HTML cov ntaub ntawv siv rau zos rau lwm cov kev pab cuam tshwj xeeb. Feem ntau lawv ua qhov kev hloov dua siab tshiab hauv kev caij tsheb npav. Ntawd yog, lawv ua ntej hloov cov lus ntawm HTML rau XLS los yog XLSX, ces txheej txheem lossis hloov nws, thiab mam li hloov nws mus rau cov ntaub ntawv nrog tus qub extension dua ua nws txoj kev ua thawj. Qhov no yog vim lub fact tias nws yog yooj yim dua ua hauj lwm nrog cov ntxhuav hauv Excel. Cia peb kawm seb yuav ua li cas thiaj txhais tau ib qho lus los ntawm HTML mus rau Excel.
Saib kuj: Siv HTML los Lo Lus
HTML rau Excel Hloov Siab Los Soj Ntsuam
HTML hom yog ib hom lus hypertext markup. Cov khoom siv nrog qhov kev txuas ntxiv no feem ntau siv hauv Is Taws Nem (Web pages) zoo li qub. Tab sis feem ntau lawv tuaj yeem siv rau cov kev pabcuam hauv zos, piv txwv li, xws li pab cov ntaub ntawv rau ntau lub program.
Yog hais tias cov lus nug tshwm sim ntawm converting cov ntaub ntawv los ntawm HTML mus rau Excel hom, namely XLS, XLSX, XLSB los yog XLSM, ces ib tug neeg inexperienced tau coj nws lub taub hau. Tab sis qhov tseeb, tsis muaj dab tsi txaus ntshai tsis nyob ntawm no. Hloov tshiab nyob rau hauv niaj hnub versions of Excel nrog cov cuab yeej built-in ntawm qhov kev pab cuam yog yooj yim heev thiab feem ntau kuj raug. Tsis tas li ntawd, peb tuaj yeem hais tias tus txheej txheem nws tus kheej yog intuitive. Txawm li cas los, hauv cov ntawv nyuaj, koj tuaj yeem siv cov kev pabcuam thib peb rau kev hloov dua siab tshiab. Cia saib cov kev xaiv ntau yam rau kev hloov HTML mus rau Excel.
Method 1: siv cov kev pabcuam thib peb
Tam sim no cia siab rau kev siv cov kev pabcuam thib peb hloov cov ntaub ntawv ntawm HTML mus rau Excel. Qhov zoo ntawm qhov kev xaiv no yog tias cov kev pabcuam tshwjxeeb muaj peev xwm tivthaiv nrog hloov cov khoom tseem ceeb heev. Qhov tsis zoo yog qhov feem coob ntawm lawv raug them. Tsis tas li ntawd, thaum lub sij hawm yuav luag txhua qhov kev xaiv tsim nyog muaj cov lus Askiv tsis hais lus Askiv. Cia peb xav txog qhov kev siv ntawm kev ua haujlwm nyob rau hauv ib qho ntawm cov kev pabcuam zoo tshaj plaws rau kev ua haujlwm saum toj no - Abex HTML rau Excel Converter.
Download tau Abex HTML rau Excel Converter
- Tom qab Abex HTML rau Excel Converter installer twb raug downloaded, tso nws los ntawm double-clicking nws nrog cov laug nas khawm. Lub installer txais tos npo. Ndliv lub khawm "Tom ntej" ("Tom ntej").
- Tom qab qhov no, lub qhov rais qhib nrog daim ntawv cog lus tso cai. Yuav kom pom zoo nrog nws, koj yuav tsum muab tus tes hloov hauv txoj haujlwm "Kuv lees txais qhov kev pom zoo" thiab nyem rau ntawm lub pob "Tom ntej".
- Tom qab ntawd, lub qhov rais qhib nyob rau hauv uas nws qhia nyob qhov twg raws nraim qhov kev pab cuam yuav tsum ntsia. Yog tias koj xav tau, koj tuaj yeem hloov lub npe, tab sis nws tsis pom zoo kom ua qhov no tsis tas muaj kev xav tau tshwj xeeb. Xwb ces nias lub khawm. "Tom ntej".
- Daim phiaj tom ntej no qhia lub npe ntawm qhov kev zov me nyuam tso tawm rau hauv daim pib tshuab raj. Ntawm no, ib yam nkaus thiab, koj tuaj yeem nyem rau ntawm "Next" khawm.
- Tom qab qhov rais pom thaj chaw dej taws ntawm lub desktop (enabled los ntawm lub neej ua ke) thiab ntawm lub vas xaj sai los ntawm khij lub checkboxes. Peb muab cov chaw no raws li peb nyiam thiab nias rau ntawm lub pob. "Tom ntej".
- Tom qab ntawd, qhib qhov rais, uas nthuav qhia tag nrho cov ntaub ntawv hais txog tag nrho cov kev teeb tsa qhov kev teeb tsa uas tus neeg siv ua ntej. Yog hais tias tus neeg siv tsis txaus siab rau ib yam dab tsi, nws tuaj yeem nias ntawm lub pob. "Rov qab" thiab ua kom tsim nyog kho kom haum. Yog hais tias nws pom zoo nrog txhua yam, ces pib lub installation, nias lub pob "Nruab".
- Nws muaj cov txheej txheem siv hluav taws xob.
- Tom qab qhov tiav, lub qhov rais qhib hauv qhov nws tau tshaj tawm. Yog hais tias tus neeg siv xav kom pib qhov kev pab cuam tam sim ntawd, ces nws yuav tsum xyuas kom meej txog "Launch Abex HTML rau Excel Converter" zuam lawm. Txwv tsis pub, koj yuav tsum tshem nws. Kom tawm lub qhov rais nruab, nyem rau ntawm lub pob. "Suav".
- Nws yog ib qho tseem ceeb kom paub hais tias ua ntej yuav pib Launch Abex HTML rau Excel Converter, tsis muaj teeb meem li cas nws yog ua manually los yog tam sim ntawd tom qab kev txhim kho daim ntawv thov, koj yuav tsum kaw thiab kaw tag nrho cov kev pab cuam ntawm Microsoft Office suite. Yog tias koj tsis ua qhov no, ces thaum koj sim qhib Abex HTML rau Excel Converter, lub qhov rai yuav qhib, qhia koj tias koj xav tau txoj kev ua no. Yog tias koj mus ua haujlwm nrog lub chaw ua haujlwm, koj yuav tsum nias rau ntawm no khawm ntawm qhov rai no. "Muaj". Yog tias tib lub sij hawm rau cov ntaub ntawv chaw ua hauj lwm qhib, ces qhov chaw ua hauj lwm hauv lawv yuav raug yuam ua tiav, thiab tag nrho cov ntaub ntawv uas tau txais kev cawmdim poob.
- Tom qab ntawd lub qhov rais sau npe yuav pib. Yog tias koj tau txais tus yuam sij rau npe, ces tom teb koj yuav tsum nkag mus rau nws tus xov tooj thiab koj lub npe (koj tuaj yeem siv kev cai), thiab ces nias lub pob "Sau npe". Yog tias koj tsis tau yuav tus yuam sij tseem tsis tau thiab xav sim seb qhov kev txiav tawm-down version ntawm daim ntawv thov, ces qhov no tsuas yog nias lub khawm "Rov qab qhia rau kuv tom qab".
- Tom qab ua tiav cov kauj ruam saum toj no, lub Abex HTML los yog Excel hloov qhov rais pib ncaj qha. Ntxiv rau cov ntaub ntawv HTML rau kev hloov dua siab tshiab, nias qhov khawm. "Ntxiv cov ntaub ntawv".
- Tom qab ntawd, qhib qhov rais ntxiv. Nyob rau hauv nws koj yuav tsum mus rau pawg twg qhov khoom uas tau npaj rau kev hloov dua siab tshiab nyob hauv. Tom qab ntawd koj yuav tsum xaiv lawv. Qhov zoo ntawm qhov txujci li HTML txheem los hloov dua siab tshiab rau Excel yog tias koj tuaj yeem xaiv thiab hloov ntau yam khoom ib zaug. Tom qab cov ntaub ntawv raug xaiv, nias ntawm lub pob "Qhib".
- Cov khoom uas tau xaiv yuav muab tso rau hauv lub qhov hluav taws xob lub qhov rais. Tom qab ntawd, nyem rau ntawm daim teb sab nraud kom xaiv tau ib qho ntawm peb hom Excel uas koj tuaj yeem hloov cov ntaub ntawv:
- Xls (neej ntawd);
- Xlsx;
- XLSM (nrog kev them nyiaj yug macro).
Kev xaiv.
- Tom qab ntawd mus rau qhov chaw nyob thaiv "Qhov chaw tawm" ("Tshaj Tawm"). Ntawm no koj yuav tsum qhia meej meej qhov chaw uas cov khoom hloov dua siab tshiab yuav raug cawm dim. Yog tias koj muab tus tes hloov hauv chaw "Tseg cov ntaub ntawv (s) hauv qhov chaw ceev", ces lub rooj yuav tau txais kev cawmdim nyob rau hauv tib lub directory qhov twg yog qhov hauv HTML hom. Yog tias koj xav khaws cov ntaub ntawv rau hauv ib phau ntawv tais tseg, ces rau qhov koj yuav tsum tsiv mus rau txoj haujlwm "Kho dua". Nyob rau hauv cov ntaub ntawv no, ua ntej, cov khoom yuav raug cawm hauv daim nplaub tshev "Tshaj tawm"uas nyob rau hauv lem yog nyob rau hauv hauv paus hauv phau ntawv ntawm lub disk C.
Yog tias koj xav qhia qhov chaw kom tseg qhov khoom, koj yuav tsum nias ntawm khawm nyob rau ntawm sab xis ntawm qhov chaw nyob.
- Tom qab ntawd, lub qhov rais qhib nrog cov txheej txheem ntawm cov folders. Koj yuav tsum tsiv mus rau lub npe uas koj xav muab ib qho chaw tseg cia. Ces nyem rau ntawm lub pob. "OK".
- Tom qab ntawd, koj tuaj yeem ncaj qha mus rau txoj kev hloov dua tshiab. Ua li no, nyem qhov khawm ntawm sab saum toj vaj huam sib luag. "Hloov siab".
- Ces txoj kev hloov dua siab tshiab yuav tau ua tiav. Tom qab tiav, lub qhov rais qhib me me yuav qhib, qhia koj txog qhov no, thiab cia li pib tso Qhov rai Explorer nyob rau hauv cov ntaub ntawv uas hloov cov ntaub ntawv Excel. Tam sim no koj tuaj yeem nqa lwm yam ntxiv nrog lawv.
Tiam sis thov nco ntsoov tias yog tias koj siv cov dawb hauv kev siv hluav taws xob, tsuas yog ib qho ntawm daim ntawv hloov dua siab tshiab.
Txoj kev 2: Hloov siv cov qauv txheem Excel
Nws kuj yog qhov yooj yim los hloov cov ntaub ntawv HTML rau txhua hom Excel siv cov txheej txheem txheem ntawm daim ntawv thov no.
- Khiav Excel thiab mus rau lub tab "Cov Ntaub Ntawv".
- Hauv qhov rais qhib, nyem rau ntawm lub npe "Qhib".
- Tom qab qhov no, qhib qhov rai qhib qhov rais. Koj yuav tsum mus rau ntawm qhov chaw nyob qhov twg cov ntaub ntawv HTML nyob hauv uas yuav tsum tau hloov dua siab tshiab. Hauv qhov no, ib qho ntawm cov lus hauv qab no yuav tsum muab teev cia rau hauv cov ntaub ntawv hom ntawm qhov rai no:
- Tag nrho cov ntaub ntawv Excel;
- Tag nrho cov ntaub ntawv;
- Tag nrho cov nplooj ntawv web.
Tsuas yog nyob rau hauv cov ntaub ntawv no cov ntaub ntawv peb xav tau yuav muab tso rau hauv lub qhov rais. Tom qab ntawd koj yuav tsum xaiv nws thiab nias rau ntawm lub pob. "Qhib".
- Tom qab ntawd, cov lus hauv HTML hom yuav muab tso rau ntawm daim ntawv Excel. Tab sis qhov no tsis yog txhua yam. Peb yuav tsum tau khaws cov ntaub ntawv sau ua ke. Ua li no, nyem rau ntawm daim duab nyob rau hauv daim ntawv ntawm lub diskette nyob rau hauv sab laug sab laug ntawm lub qhov rais.
- Lub qhov rais qhib nyob rau hauv uas nws hais tias ib daim ntawv uas twb muaj lawm yuav muaj nta incompatible nrog rau hom ntawm lub vev xaib. Peb nias lub khawm "Tsis muaj".
- Tom qab ntawd, qhib qhov rais qhib qhov rais. Mus rau ntawm qhov chaw uas peb xav tso nws. Tom qab ntawd, yog tias koj xav, hloov lub npe ntawm daim ntawv hauv lub tshav pob "Filename", txawm tias nws tuaj yeem sab laug tam sim no. Tom ntej no, nias ntawm daim teb "Cov Ntaub Ntawv Siv" thiab xaiv ib qho ntawm Excel cov hom ntaub ntawv:
- Xlsx;
- Xls;
- Xlsb;
- Xlsm.
Thaum tag nrho cov nqis saum toj no ua tiav, nias ntawm lub pob. "Txuag".
- Tom qab ntawd, cov ntaub ntawv yuav raug cawm nrog qhov kev xaiv ncua.
Tseem muaj lwm txoj hau kev los mus rau qhov rais tseg.
- Txav mus rau tab "Cov Ntaub Ntawv".
- Mus rau ntawm lub qhov rais tshiab, nyem qhov khoom ntawm sab laug ntsug tshuab raj "Tseg Rau".
- Tom qab ntawd, daim ntawv cim tseg tau qhib qhov rais, thiab tag nrho cov kev nqis tes ua ntxiv yog ua raws li tib txoj kev raws li tau piav nyob rau hauv lub dhau los.
Raws li koj tau pom, nws yooj yim los hloov cov ntaub ntawv los ntawm HTML mus rau ib qho ntawm Excel cov qauv siv cov txheej txheem txheem ntawm qhov kev qhia no. Tab sis cov neeg siv uas xav tau cov haujlwm ntxiv, piv txwv, los tsim cov khoom loj hauv cov lus qhia hauv cov kev taw qhia, yuav qhia tau los yuav ib qho ntawm cov nqi hluav taws xob tshwj xeeb.
