Hom Ntawv Cov Ntawv Sau Csv siv los ntawm ntau lub koos pij tawj los sib pauv cov ntaub ntawv ntawm ib leeg. Nws yuav zoo li tias hauv Excel koj tuaj yeem tso tawm cov ntawv zoo li no nrog cov txheej txheem nyem ob npaug ntawm nws nrog sab laug nas khawm, tab sis nyob deb ntawm qhov ib txwm muaj qhov no cov ntaub ntawv raug tso tawm kom raug. Yog lawm, muaj lwm txoj hauv kev los saib cov ntaub ntawv hauv ib daim ntawv. CsvCov. Thov peb cov neeg no yuav ua tau li cas?
Qhib Cov Ntaub Ntawv CSV
Hom lub npe Csv yog cov lus luv ntawm lub npe "Comma-Separated Values", uas txhais ua lus Lavxias ua "comma cais qhov tseem ceeb." Tseeb, nyob rau hauv cov ntaub ntawv no commas ua raws li kev cais tawm, txawm hais tias hauv Lavxias phau ntawv, tsis zoo li hauv lus Askiv, nws tseem niaj hnub siv cov cim suab.
Thaum ntshuam cov ntaub ntawv Csv Hauv Excel, qhov teeb meem tiag tiag yog qhov encoding. Feem ntau, cov ntaub ntawv nyob rau hauv uas Cyrillic tam sim no tau pib nrog cov ntawv sau nrog "plaub hau nkhaus", uas yog, cim tsis txaus ntseeg. Ib qho ntxiv, qhov teeb meem ntawm kev sib cais tsis sib xws yog qhov teeb meem zoo. Ua ntej tshaj, qhov no siv rau cov xwm txheej thaum peb sim qhib daim ntawv ua nyob hauv qee qhov kev pabcuam lus Askiv, Excel, tau txais kev pom zoo los ua cov neeg hais lus Lavxias. Tseeb, nyob rau hauv cov peev txheej, lub separator yog comma, thiab Lavxias-hais lus Excel paub txog cov khoom siv hauv qhov tsis zoo no. Yog li, ib qho txiaj ntsig tsis raug yog rov tau txais dua. Peb yuav qhia koj kom daws cov teeb meem no thaum qhib cov ntaub ntawv.
Txoj Kev 1: Qhib cov ntawv ib txwm
Tab sis ua ntej, peb yuav tsom mus rau qhov kev xaiv thaum ntawv Csv tsim nyob rau hauv hom lus Lavxias-npaj thiab npaj rau hauv qhib hauv Excel yam tsis muaj kev ntxias ntxiv ntawm cov ncauj lus.
Yog tias Excel twb tau nruab los qhib cov ntaub ntawv Csv hauv koj lub computer los ntawm lub neej ntawd, hauv qhov no, tsuas yog nyem rau ntawm cov ntaub ntawv los ntawm ob npaug nias tus laug nas khawm, thiab nws yuav qhib hauv Excel. Yog tias qhov kev sib txuas tseem tsis tau tsim, ces hauv qhov no, koj yuav tsum tau ua ib tug xov tooj ntawm kev siv ntxiv.
- Nyob hauv Qhov rai Explorer hauv cov npe chaw uas cov ntaub ntawv nyob, nyem rau nws. Lub ntsiab lus teb ntawv qhia yog tsim los. Xaiv cov khoom hauv nws Qhib nrogCov. Yog tias daim ntawv qhib ntxiv muaj cov npe "Microsoft Office", nyem rau nws. Tom qab ntawv, daim ntawv yuav cia li khiav ntawm koj qhov Piv txwv Excel. Tab sis, yog tias koj tsis pom cov khoom no, ces nyem rau ntawm txoj haujlwm "Xaiv program".
- Qhov kev xaiv xaiv qhov rai qhib. Ntawm no, dua, yog tias nyob hauv lub block Cov Kev Kawm uas Pom Zoo koj yuav pom lub npe "Microsoft Office"tom qab ntawd xaiv nws thiab nyem rau ntawm lub pob "OK"Cov. Tab sis ua ntej ntawd, yog tias koj xav tau cov ntaub ntawv Csv yeej ib txwm qhib txais qhov tseeb hauv Excel thaum koj nias ob npaug ntawm lub npe ntawm qhov program, tom qab ntawd nco ntsoov tias tom ntej ntawm qhov ntsuas "Siv qhov program xaiv rau txhua cov ntaub ntawv ntawm hom no" muaj ib lub cim ntaus cim.
Yog tias cov npe "Microsoft Office" hauv qhov kev xaiv xaiv qhov rai koj tsis pom, tom qab ntawd nias lub pob lus "Ntsuam xyuas ...".
- Tom qab ntawv, Explorer lub qhov rais yuav qhib rau hauv cov ntawv teev npe uas cov programs tau nruab rau koj lub khoos phis tawm. Cov haujlwm no feem ntau hu ua "Cov Ntaub Ntawv Cov Ntaub Ntawv" thiab nws nyob hauv lub hauv paus ntawm lub disk CCov. Koj yuav tsum mus rau Explorer ntawm chaw nyob nram qab no:
C: Program Files Microsoft Office Office№Qhov twg hloov ntawm cov cim "№" yuav tsum yog tus naj npawb version ntawm Microsoft chav suite tau nruab rau hauv koj lub khoos phis tawm. Raws li txoj cai, muaj tsuas yog tib lub chaw khaws ntawv, yog li xaiv cov npe Chaw Haujlwmtxawm li cas los xij suav tseem. Tsiv mus rau cov kev taw qhia tau teev tseg, nrhiav ib daim ntawv hu ua KEV ZOO lossis "EXCEL.EXE"Cov. Qhov thib ob daim ntawv ntawm kev tso npe yuav yog tias koj tau suav nrog txuas ntxiv mappings nyob rau hauv Qhov rai ExplorerCov. Tshaj tawm cov ntaub ntawv no thiab nyem rau ntawm lub pob. "Qhib ...".
- Tom qab qhov program no "Microsoft Excel" yuav ntxiv rau qhov kev xaiv qhov rai, uas peb tau tham txog ua ntej. Koj tsuas yog yuav tsum tau xaiv lub npe uas koj xav tau, taug qab lub xub ntiag ntawm qhov ntsuas ze ntawm lub ntsiab lus ntawm kev khi rau cov hom ntaub ntawv (yog tias koj xav tau tas li qhib cov ntaub ntawv Csv hauv Excel) thiab nyem rau ntawm lub pob "OK".
Tom qab ntawv, cov ntsiab lus ntawm cov ntawv Csv yuav qhib rau hauv Excel. Tab sis hom no haum nkaus xwb yog tias tsis muaj teeb meem hauv cheeb tsam los yog nrog cov zaub ntawm Cyrillic niam ntawv. Ntxiv rau, raws li peb pom, peb yuav tau ua qee cov kev kho ntawm daim ntawv: txij li cov ntaub ntawv tsis ib txwm haum rau hauv cov xov tooj ntawm tes tam sim no, lawv yuav tsum nthuav dav.
Txoj Kev 2: siv Phau Ntawv Sau Dab Tsi
Koj tuaj yeem ntshuam cov ntaub ntawv los ntawm CSV cov hom ntawv sau uas siv los ua qhov Excel ua hu ua Cov ntawv luam qhia.
- Khiav qhov kev pab cuam Excel thiab mus rau hauv lub tab "Cov ntaub ntawv"Cov. Ntawm txoj hlua rau ntawm pob khawm "Tau cov ntaub ntawv sab nraud" nias rau lub pob hu ua "Los ntawm cov ntawv nyeem".
- Lub qhov rais rau kev xa cov ntawv sau pib. Peb tsiv mus rau qhov chaw nyob ntawm cov ntawv xaib ua CVSCov. Xaiv nws lub npe thiab nyem rau ntawm pob "Ntshuam"nyob rau hauv qab ntawm lub qhov rais.
- Qhov rai qhib kom ua huaj Cov ntawv mastersCov. Hauv cov chaw thaiv Cov Qauv Ntaub Ntawv tus tes hloov yuav tsum nyob hauv qhov chaw Sib caisCov. Txhawm rau kom paub tseeb tias cov ntsiab lus ntawm cov ntawv xaiv raug tso tawm kom raug, tshwj xeeb tshaj yog tias nws muaj Cyrillic, them nyiaj rau thaj teb "Cov hom ntaub ntawv" teeb mus Unicode (UTF-8)Cov. Txwv tsis pub, koj yuav tsum nruab nws tus kheej. Tom qab txhua qhov kev teeb tsa saum toj saud, nyem rau lub pob "Tom ntej".
- Tom qab ntawd lub qhov rais thib ob qhib. Cov ntawv mastersCov. Ntawm no nws yog qhov tseem ceeb heev los txiav txim siab uas yog lub cim cais tawm hauv koj daim ntawv. Hauv peb qhov teeb meem no, lub luag haujlwm no yog ua si los ntawm lub suab semicolon, txij li daim ntawv yog lus Lavxias-hais lus hauv zos thiab hauv ib cheeb tsam tshwj xeeb rau cov software hauv tebchaws. Yog li ntawd, nyob hauv cov chaw txwv "Tus yam ntxwv cais yog" peb kos lub thawv SemicolonCov. Tab sis yog tias koj import cov ntaub ntawv CVS, uas tau kho kom zoo rau cov qauv lus Askiv, thiab raws li kev cais tawm hauv nws yog qhov sau, ces koj yuav tsum kos lub thawv CommaCov. Tom qab cov cuab yeej saum toj saud tau ua, nyem rau ntawm lub pob "Tom ntej".
- Thib peb lub qhov rais qhib Cov ntawv mastersCov. Raws li txoj cai, tsis muaj lwm yam ntxiv rau hauv nws. Muaj qhov zam tau tsuas yog yog ib ntawm cov ntawv teev nyob rau hauv cov ntaub ntawv nyob rau hauv daim ntawv ntawm hnub tim. Hauv qhov no, koj yuav tsum khij kab ntawv no rau hauv qab ntawm lub qhov rais, thiab tus tes hloov qhov hauv thaiv Kem Qhia Cov Qauv Ntaub Ntawv teeb tsa chaw Hnub TimCov. Tab sis feem ntau ntawm rooj plaub feem ntau, lub neej ntawd chaw rau hom ntawv uas tau teeb tsa yog qhov txaus "General"Cov. Yog li koj tuaj yeem nias lub pob xwb Ua li cas nyob hauv qab ntawm lub qhov rais.
- Tom qab ntawd, lub qhov rais me me rau kev ntshuam cov ntaub ntawv qhib. Nws yuav tsum qhia qhov sib koom ua ke ntawm sab saud ntawm lub nras ntawm thaj chaw uas cov ntaub ntawv hauv yuav nyob. Qhov no tuaj yeem ua tiav los ntawm kev muab tus cursor tso rau hauv lub tshav pob qhov rai, thiab tom qab ntawd nyem nyem rau ntawm cov xov tooj sib piv hauv cov ntawv. Tom qab ntawd, nws qhov chaw tswj xyuas yuav tsum nkag mus rau hauv qhov chaw. Koj tuaj yeem nias lub pob nyem "OK".
- Tom qab ntawv, cov ntsiab lus ntawm cov ntaub ntawv Csv yuav tsum tau muab cov ntawv xa mus ua ib daim ntawv zoo. Ntxiv mus, raws li peb tuaj yeem pom, nws tau ua kom pom tseeb dua li thaum siv Txoj Kev 1Cov. Hauv tshwj xeeb, tsis muaj cov xaim xoom yuav tsum nthuav dav ntxiv.
Tshooj: Yuav ua li cas hloov hloov encoding hauv Excel
Txoj Kev 3: qhib los ntawm cov File tab
Tseem muaj txoj hauv kev los qhib daim ntawv. Csv los ntawm cov tab Cov ntaub ntawv Cov kev pab cuam Excel.
- Tua tawm Excel thiab txav mus rau ntawm lub tab Cov ntaub ntawvCov. Nyem rau ntawm yam khoom ntawd "Qhib"nyob rau sab laug ntawm lub qhov rais.
- Qhov rai pib Neeg xyuas pibCov. Koj yuav tsum tsiv mus rau cov ntawv ntawm lub hard drive ntawm lub PC lossis rau hauv xov xwm uas tshem tau nyob rau hauv uas daim ntawv ntawm kev txaus siab rau peb yog nyob CsvCov. Tom qab ntawd, koj yuav tsum rov ua dua daim ntawv hom hloov chaw nyob rau hauv lub qhov rai mus rau txoj haujlwm "Txhua cov ntaub ntawv"Cov. Tsuas yog hauv cov ntaub ntawv no daim ntawv Csv yuav qhia hauv qhov rai vim nws tsis yog Excel daim ntawv tseem ceeb. Tom qab lub npe ntawm daim ntawv no tso tawm, xaiv nws thiab nyem rau ntawm lub pob "Qhib" nyob hauv qab ntawm lub qhov rais.
- Tom qab ntawd, lub qhov rai yuav pib Cov ntawv mastersCov. Tag nrho cov kev nqis tes ua ntxiv tau ua raws li cov txheej txheem ib yam nkaus hauv Txoj Kev 2.
Raws li koj tuaj yeem pom, txawm tias qee qhov teeb meem nrog qhib cov ntawv qhib cov ntaub ntawv Csv hauv Excel, koj tseem tuaj yeem daws lawv. Ua qhov no, siv lub cuab tam Excel ua hu ua Cov ntawv luam qhiaCov. Txawm hais tias, rau ntau rooj plaub, nws yog qhov txaus los siv cov qauv txheej txheem ntawm kev qhib cov ntaub ntawv los ntawm ob npaug nias tus laug nas khawm ntawm nws lub npe.
