Nws tsis pub leejtwg paub tias Excel thiab 1C cov kev pab cuam tshwj xeeb tshaj yog cov neeg ua haujlwm hauv cov neeg ua haujlwm, xws li cov neeg koom nrog kev lag luam thiab nyiaj txiag. Yog li, ntau zaus nws yog tsim nyog yuav pauv cov ntaub ntawv ntawm cov ntawv sau npe. Tab sis, hmoov tsis, tsis yog txhua tus neeg siv paub ua li cas kom sai. Cia peb kawm saib yuav ua li cas muab cov ntaub ntawv xa tawm ntawm 1C mus rau Excel.
Xa cov ntaub ntawv los ntawm 1C mus rau Excel
Yog tias ntsig txog cov ntaub ntawv los ntawm Excel mus rau 1C yog qhov nyuaj, tab sis tsuas yog siv cov kev pabcuam ntawm cov neeg sab nrauv, ces qhov rov qab, namely, downloading ntawm 1C mus rau Excel, yog txheej txheem yoojyim. Nws tuaj yeem ua tau yooj yim siv cov cuab yeej built-in ntawm cov kev pabcuam saum toj no, thiab qhov no tuaj yeem ua ntau txoj hauv kev, nyob ntawm seb tus neeg siv xav pauv. Xav seb yuav ua li cas ua nrog qhov kev piv txwv nyob rau hauv 1C version 8.3.
Txoj kev cai 1: Luam Cell Txheem
Ib cov ntaub ntawv yog muaj nyob hauv xovtooj 1C. Nws tuaj yeem raug xa mus rau Excel los ntawm txoj kev luam qauv li niaj zaus.
- Xaiv lub xovtooj ntawm 1C, cov ntsiab lus uas koj xav luam. Nias rau ntawm nws nrog txoj kev nas khawm. Hauv cov ntawv qhia zaub mov, xaiv cov khoom "Daim qauv". Koj kuj tuaj yeem siv txoj kev dav dav uas ua haujlwm hauv feem ntau cov kev pabcuam khiav tawm ntawm qhov rais: cia li xaiv tus txheem ntawm lub xovtooj thiab ntaus lub ntsiab ua ke ntawm cov keyboard Ctrl + C.
- Qhib ntawv VOJVOOS los yog ib daim ntawv uas koj xav kom muab cov ntsiab lus. Nias lub pob nyem khawm thiab hauv cov ntawv qhia zaub mov uas tshwm nyob rau hauv kev xaiv kev xaiv, xaiv qhov khoom "Tseg ntawv tsuas"uas yog xwm txheej nyob rau hauv daim ntawv ntawm lub cim nyob rau hauv daim ntawv ntawm ib tug loj tsab ntawv "IB TUG".
Xwb, koj tuaj yeem ua qhov no tom qab xaiv lub xov tooj ntawm tes, ua hauv tab "Tsev"nyem rau ntawm lub cim Muab tshuaj txhuamuas yog nyob rau ntawm daim kab xev hauv kev thaiv "Ntawv Teev Npe".
Koj tseem tuaj yeem siv txoj kev cai thiab sau cov keyboard shortcut rau ntawm tus keyboard Ctrl + V tom qab lub xov tooj ntawm tes yog tseem ceeb.
Tus txheem ntawm tes 1C yuav muab tso rau hauv Excel.
Method 2: Muab cov ntawv sau rau hauv phau ntawv Excel uas twb muaj lawm
Tab sis qhov saum toj no yog tsim rau koj yog tias koj xav hloov ntaub ntawv los ntawm ib lub xov tooj. Thaum koj xav hloov ib daim ntawv teev tag nrho, koj yuav tsum siv lwm txoj kev, vim luam ib lub caij yuav siv sij hawm ntau.
- Qhib tej npe, phau ntawv journal lossis directory hauv 1C. Ndliv lub khawm "Txhua Yam"uas yuav tsum tau muaj nyob rau saum toj ntawm cov ntaub ntawv ua tiav. Cov ntawv qhia pib. Xaiv cov khoom hauv nws "Daim Ntawv Teev Npe".
- Ib lub thawv me me qhib opens. Ntawm no koj tuaj yeem tsim qee qhov chaw.
Teb "Tsim tawm mus" muaj ob lub ntsiab lus:
- Cov ntawv pov thawj;
- Cov ntawv sau.
Qhov kev xaiv thawj yog nruab ntawm lub neej ua ntej. Rau cov ntaub ntawv hloov mus rau Excel, nws yog xwb haum, yog li ntawm no peb tsis hloov dab tsi.
Hauv kev thaiv "Qhia kab" Koj tuaj yeem qhia meej txog txhua kab ntawm daim ntawv teev npe koj xav hloov mus rau Excel. Yog tias koj yuav rho tawm tag nrho cov ntaub ntawv, ces qhov chaw no kuj tsis yog kov. Yog hais tias koj xav siv hloov tsis muaj kem los sis ntau kab, ces tsis pom cov ntsiab lus coj.
Tom qab qhov ua tiav tiav, nias ntawm lub pob. "OK".
- Tom qab ntawd daim ntawv teev lus qhia hauv daim ntawv sau tawm. Yog tias koj xav hloov nws mus rau cov ntaub ntawv npaj ua Excel, ces cia li xaiv tag nrho cov ntaub ntawv nyob hauv nws nrog tus cursor thaum tuav cov laug nas khawm, ces nias qhov kev xaiv nrog txoj cai nas khawm thiab xaiv cov khoom nyob rau hauv lub tshuab raj qhib "Daim qauv". Koj kuj tuaj yeem siv lub sijhawm kub kub xws li hauv txoj kev ntsuas yav dhau los. Ctrl + C.
- Qhib ntawv Microsoft Excel thiab xaiv sab saum toj ntawm lub xovtooj ntawm qhov ntau ntawm cov ntaub ntawv yuav muab tso rau. Ces nyem rau ntawm lub pob Muab tshuaj txhuam nyob rau ntawm txoj kab hauv qhov tab "Tsev" los yog ntaus ib ntu Ctrl + V.
Daim ntawv sau rau hauv daim ntawv.
Method 3: Tsim ib phau ntawv tshiab Excel nrog ib daim ntawv teev
Ntxiv thiab, daim ntawv los ntawm txoj haujlwm 1C tuaj yeem tsim tawm rau cov ntaub ntawv Excel tshiab.
- Peb nqa tawm tag nrho cov kauj ruam uas tau hais nyob rau hauv txoj kev dhau los ua ntej qhov tsim ntawm daim ntawv teev npe nyob rau hauv 1C nyob rau hauv ib tug tabular version inclusive. Tom qab ntawd, nyem rau ntawm daim ntawv qhia khawm, uas nyob rau sab saum toj ntawm lub qhov rais hauv daim ntawv ntawm ib daim duab peb sab sau rau hauv lub voj voog txiv kab ntxwv. Nyob rau hauv cov ntawv qhia zaub mov pib, mus rau cov khoom "Cov Ntaub Ntawv" thiab "Txuag Raws Li ...".
Txawm tias yooj yim los hloov qhov kev hloov los txhaj ntawm lub pob "Txuag"uas zoo li ib lub tshuab floppy thiab nyob rau hauv 1C toolbox ntawm lub qhov kawg ntawm lub qhov rais. Tab sis qhov feature no tsuas muaj rau cov neeg siv uas siv qhov kev pab cuam version 8.3. Nyob rau hauv versions dhau los, tsuas yog yav dhau los version siv tau.
Tsis tas li ntawd nyob rau hauv txhua qhov kev siv ntawm qhov kev zov me nyuam los pib lub txuag qhov rais, koj tuaj yeem nias qhov ua ke tseem ceeb Ctrl + S.
- Cov ntaub ntawv tawm qhov rais pib. Mus rau qhov directory uas peb npaj yuav khaws tseg rau hauv phau ntawv, yog tias qhov chaw tsis txaus siab tsis txaus siab. Hauv teb "Cov Ntaub Ntawv Siv" qhov nqi pheej yig yog "Cov ntaub ntawv hauv daim ntawv (* .mxl)". Nws tsis nplua peb, yog li ntawm daim ntawv teev npe cia, xaiv qhov khoom "Cov ntawv Excel (* .xls)" los yog "Excel 2007 tsab ntawv khom nqi - ... (* .xlsx)". Ntxiv thiab, yog tias koj xav, koj tuaj yeem xaiv cov qauv qub qub - "Excel 95 Sheet" los yog "Excel 97 Sheet". Tom qab txuag cov teebmeem lawm, nyem rau ntawm lub pob. "Txuag".
Tag nrho daim ntawv yuav tau txais kev cawmdim raws li phau ntawv cais.
Txoj kev 4: Luam kab kev los ntawm daim ntawv teev lus 1C rau Excel
Muaj qee kis thaum uas tsim nyog yuav tsum tau xa tawm tsis tag nrho daim ntawv teev npe, tab sis tsuas yog tus kheej cov kab lossis ntau yam ntawm cov ntaub ntawv. Qhov kev xaiv no kuj yog tag nrho paub nrog kev pab los ntawm cov cuab yeej built-in.
- Xaiv kab lossis ntau yam ntawm cov ntaub ntawv hauv daim ntawv. Ua li no, puag tus khawm Ua haujlwm thiab nias lub pob nyem khawm ntawm cov kab uas koj xav rhais. Peb nias lub khawm "Txhua Yam". Hauv daim ntawv qhia zaub mov, xaiv qhov khoom "Sau cov npe ...".
- Lub qhov tso zis qhib qhov rai pib. Cov chaw nyob hauv nws tau ua nyob rau hauv tib txoj kev raws li nyob rau hauv ob txoj kev dhau los. Tsuas yog tias koj yuav tsum kos rau lub thawv "Xaiv Tau Xwb". Tom qab ntawd, nyem rau ntawm lub pob "OK".
- Raws li koj tau pom, daim ntawv teev cov kev xaiv ntawm cov kab ntawv xaiv tau pom. Tom ntej no peb yuav tsum ua cov kauj ruam tib yam nkaus li hauv Txoj kev 2 lossis hauv Txoj Cai 3nyob ntawm seb peb puas yuav ntxiv cov npe rau cov ntaub ntawv Excel uas twb muaj lawm los tsim cov ntaub ntawv tshiab.
Method 5: Txuag cov ntaub ntawv hauv Excel hom
Nyob rau hauv Excel, qee zaus koj yuav tsum tseg tsis tau tsuas yog npe, tab sis kuj muaj cov ntaub ntawv tsim hauv 1C (txib, nqe lus, thiab lwm yam). Qhov no yog vim lub fact tias rau ntau cov neeg siv nws yog yooj yim los hloov cov ntaub ntawv hauv Excel. Tsis tas li ntawd, hauv Excel, koj tuaj yeem tshem tawm cov ntaub ntawv tiav thiab, luam tawm ib daim ntawv pov thawj, siv nws, yog tias tsim nyog, raws li ib daim ntawv rau kev ua ntawv filling.
- Nyob rau hauv 1C, nyob rau hauv daim ntawv ntawm tsim cov ntaub ntawv muaj ib qho luam khawm. Rau nws nyob rau hauv cov duab hauv daim duab ntawm lub tshuab luam ntawv. Tom qab cov ntaub ntawv tsim nyog tau raug ntaus nkag rau hauv daim ntawv thiab nws tau txais kev cawmdim, nyem rau ntawm daim ntawv no.
- Ib daim ntawv rau luam ntawv qhib. Tiam sis peb, raws li peb nco ntsoov, tsis xav luam daim ntawv, tab sis hloov mus rau Excel. Qhov yooj yim hauv version 1C 8.3 ua li no los ntawm nias lub khawm "Txuag" nyob rau hauv daim ntawv ntawm ib lub tshuab floppy.
Rau cov versions ua ntej siv lub sijhawm kub tuav. Ctrl + S los yog nias lub tshuab raj khawm hauv daim ntawv ntawm ib daim duab peb sab hauv lub qhov rais, mus rau cov khoom "Cov Ntaub Ntawv" thiab "Txuag".
- Lub qhov rais qhib qhov rais qhib. Raws li nyob rau hauv txoj kev dhau los, nws yog ib qho tsim nyog los qhia txog qhov chaw ntawm cov ntaub ntawv tseg. Hauv teb "Cov Ntaub Ntawv Siv" hais kom meej ib qho ntawm Excel cov ntaub ntawv. Tsis txhob hnov qab muab lub npe ntawm daim ntawv hauv lub tshav pob "Filename". Tom qab ua tag nrho cov nqis nias ntawm lub pob "Txuag".
Cov ntaub ntawv yuav raug cawm nyob rau hauv Excel hom. Cov ntaub ntawv no tam sim no tau qhib rau hauv qhov kev pab cuam no, thiab kev ua haujlwm ntxiv yav tas los hauv nws.
Raws li koj tau pom, cov ntaub ntawv xa tawm ntawm 1C mus rau Excel tsis tsim teeb meem. Koj tsuas yog xav paub txog qhov kev ua ntawm kev nqis tes, vim, hmoov tsis, nws tsis yog intuitive rau tag nrho cov neeg siv. Siv cov cuab yeej built-in 1C thiab Excel, koj tuaj yeem luam cov txheej txheem ntawm lub hlwb, cov npe thiab cov ranges ntawm thawj daim ntawv thov mus rau lub thib ob, thiab tseem khaws npe thiab cov ntaub ntawv rau lwm cov phau ntawv. Muaj ntau txoj kev cawm siav thiab yuav kom tus neeg siv los nrhiav txoj cai rau nws qhov teeb meem no, tsis tas yuav tsum tau siv txhua qhov los siv qhov kev pabcuam thib peb los yog siv cov txheej txheem ntawm kev ua haujlwm.
