Tau ntev lub sij hawm twb tau 1C daim ntawv thov los ua qhov kev kawm nrov tshaj plaws ntawm cov neeg teev nyiaj txiag, cov phiaj xwm, kev lag luam thiab cov tswj hwm. Nws tsis tsuas yog muaj ntau lub tswv yim tsim rau ntau yam kev ua, tab sis kuj tseem muaj hauv zos raws li cov qauv kev teev tseg hauv ntau lub tebchaws hauv ntiaj teb. Muaj ntau thiab ntau dua kev lag luam tau hloov mus rau qhov kev suav hauv cov haujlwm tshwj xeeb no. Tab sis cov txheej txheem ntawm kev hloov cov ntaub ntawv manually los ntawm lwm cov kev pabcuam nyiaj txiag mus rau 1C yog cov haujlwm ntev thiab tsis txawv, uas siv sijhawm ntau. Yog tias lub tuam txhab khaws cov ntaub ntawv siv Excel, cov txheej txheem hloov tsheb tuaj yeem hloov kho tau sai thiab ceev.
Cov ntaub ntawv hloov tsheb ntawm Excel mus rau 1C
Hloov cov ntaub ntawv los ntawm Excel rau 1C yog tsis tas yuav tsum ua haujlwm thaum pib thawj zaug ntawm kev ua haujlwm nrog qhov program no. Qee lub sij hawm qhov xav tau tshwm sim rau qhov no, thaum nyob rau hauv chav kawm ntawm kev ua si koj yuav tsum nkag mus rau qee cov npe khaws cia rau hauv phau ntawv lub tshuab processor. Piv txwv li, yog tias koj xav hloov cov npe lossis cov xaj los ntawm cov khw hauv online. Thaum rooj plaub thaum cov npe me, tom qab ntawd tuaj yeem tsav hauv manually, tab sis dab tsi yog tias lawv muaj ntau pua khoom? Txhawm rau txhawm rau ua kom sai sai, koj tuaj yeem hloov mus rau qee cov nta ntxiv.
Yuav luag txhua hom ntaub ntawv uas haum rau kev thauj khoom tsis siv neeg:
- Daim ntawv teev cov khoom;
- Cov npe ntawm cov neeg koom tes;
- Daim ntawv teev nqi;
- Daim ntawv teev cov xaj;
- Cov ntaub ntawv hais txog kev yuav khoom lossis muag khoom, thiab lwm yam.
Nws yuav tsum raug sau tseg tam sim ntawd hauv 1C tsis muaj cov cuab yeej tsim los uas yuav ua rau koj hloov ntaub ntawv ntawm Excel. Rau cov laj thawj no, koj yuav tsum tau txuas rau sab nraud bootloader, uas yog cov ntawv ntim hauv hom epf.
Kev npaj cov ntaub ntawv
Peb yuav xav tau los npaj cov ntaub ntawv hauv Excel daim phiaj nws tus kheej.
- Txhua cov npe teev hauv 1C yuav tsum tau teeb tsa zoo tib yam. Koj tsis tuaj yeem rub tawm yog tias muaj ntau hom ntaub ntawv hauv ib kem lossis xov tooj ntawm tes, piv txwv li, ib tus neeg lub npe thiab naj npawb xov tooj. Hauv qhov no, xws li cov ntaub ntawv luam tawm yuav tsum tau muab faib ua cov kab sib txawv.
- Cov hlwb ua ke tsis raug tso cai, txawm tias nyob hauv headers. Qhov no tuaj yeem ua rau tsis muaj tseeb thaum hloov cov ntaub ntawv. Yog li ntawd, yog tias cov kab sib xyaw ua ke yog muaj, lawv yuav tsum cais tawm.
- Yog tias koj ua lub hauv paus ntawm cov ntaub ntawv yooj yooj yim thiab ncaj ncaj li sai tau tsis tas siv cov thev naus laus zis sib txawv (macros, qauv, cov lus pom, cov ntawv sau cia, cov ntsiab lus ntxiv, thiab lwm yam), qhov no yuav pab tau ntau kawg nkaus tiv thaiv teeb meem hauv cov kauj ruam txuas ntxiv ntawm qhov hloov.
- Nco ntsoov nqa lub npe ntawm txhua qhov ntau rau ib hom. Nws tsis raug tso cai kom muaj qauv, piv txwv li, ib phaus uas pom los ntawm kev nkag txawv: kg, "phaus", "kg."Cov. Qhov kev zov me nyuam yuav nkag siab lawv raws li cov txiaj ntsig sib txawv, yog li koj xav tau xaiv ib qho kev xaiv kaw, thiab kho qhov seem rau cov qauv no.
- Yuav tsum muaj cov cim ntawm tus kheej. Lub luag haujlwm yuav raug ntaus los ntawm cov ntsiab lus ntawm kem twg uas tsis tau rov ua dua ntawm lwm kab: ib tus lej se, tus lej lej, thiab lwm yam. Yog tias cov lus uas twb muaj lawm tsis muaj kem nrog tus nqi zoo sib xws, tom qab ntawd koj tuaj yeem ntxiv ib kem ntxiv thiab ua tus lej yooj yim nyob rau ntawd. Qhov no yog qhov tsim nyog kom qhov kev zov me nyuam tuaj yeem txheeb xyuas cov ntaub ntawv hauv txhua kab nyias, thiab tsis "sib koom ua ke" lawv ua ke.
- Yuav luag txhua tus tuav ntaub ntawv Excel tsis ua haujlwm nrog hom ntawv xlsx, tab sis tsuas yog nrog hom ntawv xlsCov. Yog li ntawd, yog tias peb daim ntawv muaj qhov txuas ntxiv xlsx, tom qab ntawd koj yuav tsum hloov nws. Ua li no, mus rau ntawm lub tab Cov ntaub ntawv thiab nias rau pob Txuag Raws Li.
Lub qhov rais qhib. Hauv dab teb Hom Ntawv daim ntawv yuav tau teev tseg los ntawm lub neej ntawd xlsxCov. Hloov nws mus rau "Excel Phau Ntawv 97-2003" thiab nias rau pob Txuag.
Tom qab ntawv, daim ntawv yuav raug cawm dim rau hauv hom ntawv uas xav tau.
Ntxiv rau cov kev ua thoob ntiaj teb no rau kev npaj cov ntaub ntawv hauv Excel phau ntawv, nws tseem yuav tsum nqa cov ntawv hauv kab ntawv nrog cov tseev kom muaj ntawm cov kev cai tshwj xeeb, uas peb yuav siv, tab sis peb yuav tham txog qhov no me ntsis tom qab.
Txuas ib lub thoob sab nraud
Txuas ib lub bootloader sab nraud nrog qhov txuas ntxiv epf rau daim ntawv thov 1C yog ua tau, ob qho tag nrho ua ntej npaj ntawm Excel ntawv, thiab tom qab. Qhov loj tshaj plaws yog tias ob qho ntawm cov kev npaj no yuav tsum raug daws los ntawm pib txheej txheem download.
Muaj ntau ob peb Excel sab nrauv rooj ua haujlwm rau 1C, uas yog tsim los ntawm ntau tus tsim. Peb yuav txiav txim siab tawm piv txwv uas yog siv cov cuab yeej siv rau kev ua cov ntaub ntawv "Chaw thau cov ntaub ntawv los ntawm daim ntawv nthuav qhia" rau version 1C 8.3.
- Tom qab cov ntaub ntawv nyob rau hauv hom epf rub tawm thiab khaws cia rau ntawm lub hard drive ntawm lub computer, khiav qhov program 1C. Yog tias ntaub ntawv epf ntim rau hauv qhov chaw khaws ntawv, nws yuav tsum xub tau muab rho tawm los ntawm qhov ntawd. Nyob rau sab saud kab rov tav ntawm daim ntawv thov, nyem rau ntawm lub pob uas pib xaiv cov ntawv qhia zaub mov. Hauv tshooj 1C 8.3 nws tau nthuav tawm raws li daim duab peb sab sau rau hauv lub voj voog txiv kab ntxwv, tig ntxeev tiaj. Hauv cov npe uas tshwm, mus hla cov khoom Cov ntaub ntawv thiab "Qhib".
- Cov ntaub ntawv qhib qhov rai pib. Mus rau hauv phau ntawv teev npe ntawm nws qhov chaw nyob, xaiv qhov khoom ntawd thiab nyem rau ntawm lub pob "Qhib".
- Tom qab ntawd, tus thauj khoom yuav pib rau 1C.
Rub tawm ua "Chaw thau khoom los ntawm cov ntaub ntawv xa cov ntawv"
Cov ntaub ntawv thauj khoom
Ib qho ntawm cov ntawv pov thawj tseem ceeb uas 1C ua haujlwm nrog yog cov npe ntawm ntau yam khoom muag thiab kev pabcuam. Yog li ntawd, txhawm rau piav qhia cov txheej txheem thauj khoom los ntawm Excel, cia peb nyob ntawm qhov piv txwv ntawm kev hloov cov ntaub ntawv no tshwj xeeb.
- Peb rov qab mus rau qhov txheej txheem ua haujlwm. Txij li thaum peb yuav thauj cov khoom lag luam, hauv parameter "Rub tawm mus" tus tes hloov yuav tsum nyob hauv qhov chaw "Ua tim khawv"Cov. Txawm li cas los xij, nws yog li ntawd ntsia los ntawm neej ntawd. Koj yuav tsum hloov nws tsuas yog thaum koj npaj siab hloov lwm yam ntaub ntawv: seem tabular lossis cov ntaub ntawv sau npe. Ntxiv nyob rau hauv lub teb "Cov lus qhia saib" Nyem rau ntawm lub pob uas qhia ellipsis. Daim ntawv teev npe cia kom qhib. Hauv nws peb yuav tsum xaiv "Npe Nom Hes".
- Tom qab ntawv, tus tuav haujlwm cia li npaj rau cov chaw uas qhov kev zov me nyuam siv nyob hauv hom ntawv no. Nws yuav tsum raug sau tseg tam sim ntawd nws tsis tas yuav sau rau hauv txhua daim teb.
- Tam sim no rov qhib portable Excel ntawv. Yog tias lub npe ntawm nws cov kem txawv ntawm lub npe ntawm cov liaj hauv 1C phau ntawv, uas muaj cov khoom coj, tom qab ntawd koj yuav tsum hloov cov npe no hauv Excel kom cov npe tag nrho sib luag. Yog tias muaj cov kem nyob rau hauv lub rooj rau cov uas tsis muaj cov analogues hauv cov lus qhia, ces lawv yuav tsum tau muab tshem tawm. Hauv peb li, cov kem li ntawd "Kom muaj nuj nqis" thiab "Nqe"Cov. Nws tseem yuav tsum tau hais ntxiv tias qhov kev txiav txim ntawm kab ntawv hauv daim ntawv yuav tsum nruj me ntsis cov uas nthuav tawm hauv kev coj ua. Yog tias rau qee cov kem uas tau tshwm hauv lub bootloader, koj tsis muaj cov ntaub ntawv, tom qab ntawd cov kem no tuaj yeem tso rau sab hauv, tab sis tus lej ntawm cov kem uas cov ntaub ntawv nyob yuav tsum zoo ib yam. Txhawm rau kom yooj yim thiab ceev ntawm kev kho, koj tuaj yeem siv tus Excel tshwj xeeb kom nrawm rau kem txhua qhov chaw.
Tom qab cov yeeb yam no tau ua tiav, nyem rau ntawm lub cim Txuag, uas yog nthuav tawm raws li lub cim piav qhia txog ib lub ntsej muag tsaws rau sab saud sab laug ntawm lub qhov rais. Tom qab ntawd kaw cov ntaub ntawv los ntawm nyem rau ntawm tus qauv khawm khawm.
- Peb rov qab mus rau 1C ua cov qhov rai. Nyem rau feem khawm "Qhib", uas yog pom tias yog daim nplaub tshev daj.
- Cov ntaub ntawv qhib qhov rai pib. Peb mus rau phau ntawv teev npe qhov twg Excel ntawv peb xav tau yog nyob. Lub neej ntawd ua ntaub ntawv thov hloov chaw tau teeb tsa txuas ntxiv mxlCov. Txhawm rau txhawm rau qhia cov ntaub ntawv peb xav tau, nws yuav tsum tau rov npaj Daim ntawv ua haujlwm ExcelCov. Tom qab ntawv, xaiv daim ntawv ntim cia thiab nyem rau ntawm lub pob "Qhib".
- Tom qab ntawd, cov ntsiab lus raug qhib hauv phau ntawv tuav. Txhawm rau kuaj xyuas qhov tseeb ntawm kev sau cov ntaub ntawv, nyem rau ntawm lub pob "Sau tswj".
- Raws li koj tuaj yeem pom, lub cuab yeej puv tswj tau qhia rau peb tias tsis pom muaj qhov yuam kev.
- Tam sim no tsiv mus nyob rau tab "Teeb"Cov. Hauv Nrhiav Lub thawv muab zuam rau hauv kab uas yuav yog qhov tshwj xeeb rau txhua yam khoom npe hauv cov npe nomenclature. Feem ntau, cov teb tau siv rau qhov no. "Tshooj" lossis "Npe"Cov. Qhov no yuav tsum ua tiav yog li thaum ntxiv cov haujlwm tshiab rau daim ntawv, cov ntaub ntawv tsis suav nrog.
- Tom qab tag nrho cov ntaub ntawv nkag mus thiab cov chaw tiav lawm, koj tuaj yeem npaj mus rau txoj kev thauj khoom ncaj qha rau hauv cov ntawv. Ua li no, nyem rau ntawm cov tsiaj ntawv "Rub cov ntaub ntawv".
- Txheej txheem rub tawm nyob rau hauv kev kawm. Tom qab nws ua tiav, koj tuaj yeem mus rau hauv cov npe ntawm npe thiab nco ntsoov tias txhua cov ntaub ntawv tsim nyog muaj nyob rau ntawd.
Tshooj: Yuav ua li cas thiaj pauv txhua nyob hauv Excel
Peb tau ua raws li tus txheej txheem ntxiv rau cov ntaub ntawv rau cov npe nomenclature hauv 1C 8.3. Rau lwm cov ntawv sau npe thiab cov ntawv sau cia, kev rub tawm yuav ua raws tib qho ntsiab cai, tab sis nrog qee qhov nuances uas tus neeg siv tau tuaj yeem xam ntawm lawv tus kheej. Nws tseem yuav tsum tau sau tseg tias cov txheej txheem yuav txawv rau cov neeg sab nraud sib txawv, tab sis txoj kev dav dav tseem zoo ib yam rau txhua tus neeg: ua ntej, tus neeg nqa khoom xa cov ntaub ntawv los ntawm cov ntaub ntawv mus rau lub qhov rai uas tau muab kho, thiab tsuas yog tom qab ntawd nws ntxiv ncaj qha rau 1C chaw khaws ntaub ntawv.
