Unloading cov ntaub ntawv los ntawm 1c hauv Excel: 5 Txoj Kev Ua Haujlwm

Nws tsis yog qhov tsis pub lwm tus neeg ua haujlwm, tshwj xeeb cov neeg ua haujlwm, tshwj xeeb cov neeg nyob hauv qhov kev sib hais haum thiab nyiaj txiag ib qho, cov kev pabcuam nyiaj txiag, nrov tshwj xeeb. Yog li ntawd, nws yog feem ntau tsim nyog los sib pauv cov ntaub ntawv ntawm cov ntawv thov no. Tab sis, hmoov tsis, tsis yog txhua tus neeg siv paub yuav ua li cas ua kom sai. Cia peb nrhiav kom tau upload cov ntaub ntawv los ntawm 1C rau cov ntaub ntawv Excel.

Upload cov ntaub ntawv los ntawm 1c hauv Excel

Yog tias cov ntaub ntawv thauj khoom los ntawm Excel hauv cov txheej txheem sib txawv, koj tuaj yeem siv cov txheej txheem rov qab, yog qhov tsis muaj peev xwm ntawm 1c mus rau cov kev ua tau yooj yim yog qhov yooj yim ntawm kev ua. Nws tuaj yeem yooj yim siv cov cuab yeej built-in ntawm cov kev pab saum toj no, thiab koj tuaj yeem ua qhov no hauv ob peb txoj kev, nyob ntawm seb tus neeg siv yuav tsum tau pauv. Xav seb nws tau ua li cas rau cov piv txwv hauv 1c version 8.3.

Txoj Kev 1: Luam theej Cov Ntsiab Lus Cell

Ib chav ntawm cov ntaub ntawv muaj nyob hauv 1C cell. Nws tuaj yeem hloov pauv mus kom zoo los ntawm txoj kev ntsuas tas li.

1. Peb qhia txog lub xovtooj ntawm 1C, cov ntsiab lus uas koj xav kom luam. Nyem rau ntawm nws txoj cai nas. Hauv cov ntsiab lus ntsiab lus, xaiv cov "Luam" khoom. Koj tseem tuaj yeem siv lub universal txoj kev uas ua nyob rau hauv feem ntau cov kev pab cuam khiav ntawm Windows OS: Tsuas xaiv cov ntsiab lus ntawm Cell thiab ntaus cov ntsiab lus tseem ceeb ntawm CTRL + C Keyboard.



2. Qhib cov npe dawb paug ntawm Excel lossis daim ntawv uas koj yuav tsum tau ntxig cov ntsiab lus. Nrog tus nas nas khawm thiab nyob rau hauv cov ntawv qhia zaub mov uas pom nyob rau hauv daim ntawv ntawm cov pictogram nyob rau hauv daim ntawv ntawm ib tsab ntawv loj "a".

   

   Hloov chaw, kev nqis tes ua tuaj yeem siv tom qab xaiv lub xov tooj thaum nyob hauv "Lub Tsev" tab, nyem rau ntawm "icon, uas nyob ntawm daim kab xev hauv daim ntawv cia.

   

   Koj tseem tuaj yeem siv txoj kev thoob ntiaj teb thiab hu rau CTRL + V yuam sij ntawm cov keyboard tom qab lub cell tseem ceeb.

Cov ntsiab lus ntawm 1C cell yuav muab tso rau hauv Excel.

Txoj Kev 2: Tso cov npe nyob rau hauv phau ntawv uas twb muaj lawm

Tab sis cov qauv saum toj no yuav tsuas yog sib haum yog tias koj yuav tsum tau hloov cov ntaub ntawv los ntawm ib lub cell. Thaum koj yuav tsum tau hloov chaw ntawm tag nrho cov npe, koj yuav tsum siv lwm txoj kev, vim hais tias luam tawm ib qho yuav siv sijhawm ntau.

1. Qhib cov npe, nkag lossis phau ntawv siv hauv 1C. Nyem rau ntawm "txhua yam ua" khawm, uas yuav tsum nyob rau sab saum toj ntawm cov ntaub ntawv array tau ua tiav. Cov zaub mov yog pib. Xaiv rau hauv nws cov khoom "tso tawm".



2. Ib qho chaw tso zis me me qhib. Ntawm no koj tuaj yeem ua qee qhov chaw.

   Qhov "tso tawm B" Field muaj ob qhov txiaj ntsig:

   • Daim ntawv taban;
   • Cov ntawv sau.

   Lub neej ntawd yog thawj qhov kev xaiv. Rau kev hloov cov ntaub ntawv mus rau Excel, nws tsuas yog tsim nyog, yog li ntawm no peb tsis hloov dab tsi.

   Hauv "cov neeg hais lus" thaiv, koj tuaj yeem hais kom meej uas cov neeg hais lus los ntawm cov npe uas koj xav tau txhais kom zoo. Yog tias koj tab tom yuav nqa tawm txhua cov ntaub ntawv, koj kuj tsis tau kov cov chaw no. Yog tias koj xav hloov dua siab tshiab tsis muaj ib nrab kab lossis ob peb kab ntawv, tom qab ntawd tshem tawm tus zuam los ntawm cov khoom sib xws.

   Tom qab cov chaw tiav tiav, nyem rau ntawm "OK" khawm.



3. Tom qab ntawd cov npe tau tshwm sim hauv daim ntawv tabla. Yog tias koj xav hloov nws mus rau cov ntaub ntawv npaj kom txhij, tsuas yog xaiv tag nrho cov ntaub ntawv nrog khawm nas laug thiab xaiv cov "luam" khoom hauv cov zaub mov qhib. Koj tseem tuaj yeem siv cov kev sib txuas ntawm cov yuam sij kub ctrl + s.



4. Qhib Microsoft Excel daim ntawv thiab xaiv cov ntawv sab saud sab sauv ntawm cov khoom uas cov ntaub ntawv yuav muab tso. Tom qab ntawd nyem rau "khawm" ntawm daim kab xev hauv tsev tab lossis ntaus Ctrl + V Ntsiab yuam kev sib xyaw.

Cov npe tau muab tso rau hauv cov ntawv.

Txoj Kev 3: Tsim Phau Ntawv Qhia Tshiab Nrog Cov Npe

Tsis tas li, cov npe ntawm 1C txoj haujlwm tuaj yeem tso tawm tam sim hauv cov ntaub ntawv Excel tshiab.

1. Peb ua tiav txhua cov kauj ruam uas tau teev nyob rau hauv cov txheej txheem dhau los ua ntej tsim cov npe hauv 1c hauv ib qho kev kawm tab. Tom qab ntawd, peb nyem rau ntawm daim ntawv qhia zaub mov hu, uas yog nyob rau sab saum toj ntawm lub qhov rais hauv daim duab ntawm lub voj voog ntawm lub voj voog. Hauv cov ntawv qhia zaub mov khiav zaub mov, ua ntu zus mus los ntawm cov "ntaub ntawv" thiab "txuag li ...".

   

   Nws yog qhov yooj yim dua ua rau kev hloov los ntawm nias ntawm "Tseg" khawm, uas muaj qhov muag muag muag thiab yog nyob rau sab saum toj ntawm lub qhov rais. Tab sis cov kev xaiv no tsuas muaj rau cov neeg siv tsuas yog siv cov ntawv 8.3 program. Hauv cov ntawv ua ntej lawm, koj tsuas tuaj yeem siv cov kev xaiv yav dhau los.

   

   Tsis tas li ntawd nyob rau hauv ib qho versions ntawm cov program los pib lub qhov rai cawm, koj tuaj yeem nyem CTRL + S qhov tseem ceeb ua ke.

2. Cov ntaub ntawv txuag qhov rai pib. Mus rau phau ntawv teev npe hauv uas peb npaj kom txuag phau ntawv yog tias qhov chaw tsis txaus siab nrog lub neej ntawd. Hauv cov ntaub ntawv hom teb, lub neej ntawd yog "phau ntawv teev ntawv (* .MXL)". Nws tsis haum rau peb, yog li koj xaiv los ntawm daim ntawv teev cia "Excel (* .xls) daim ntawv lossis" Excel 2007 daim ntawv "... (* .xlsx)." Yog tias koj xav tau, koj tuaj yeem xaiv cov qauv qub heev - "Excel 95" lossis "Excel 97 daim ntawv". Tom qab txuag chaw yog tsim tawm, nyem rau ntawm "Tseg" khawm.

Tag nrho cov npe yuav tau txais kev cawmdim los ntawm ib phau ntawv cais.

Txoj kev 4: Luam theej tawm cov kab ntawm 1C teev kom Excel

Muaj cov xwm txheej thaum koj xav tau kev hloov pauv tsis yog tag nrho cov npe, tab sis tsuas yog cov npoo lossis cov ntaub ntawv ntau. Qhov kev xaiv no tseem yuav tag nrho nrog cov cuab yeej built-in.

1. Xaiv cov hlua lossis ntau cov ntaub ntawv hauv cov npe. Txhawm rau ua qhov no, clamp lub kaw khawm thiab nyem rau sab laug nas khawm ntawm cov kab kom pauv. Nyem rau ntawm "txhua yam" khawm ". Hauv cov ntawv qhia uas tshwm, xaiv cov "Displist cov npe ..." khoom.



2. Cov npe tso zis lub qhov rais tau ua tiav. Cov chaw nyob hauv nws yog tsim nyob rau hauv tib txoj kev raws li nyob rau hauv ob txoj kev dhau los. Tsuas yog Nua tshuaj yog tias koj yuav tsum tau nruab ib tus zuam txog qhov "tsuas yog muab fij rau" parameter. Tom qab ntawd, nyem rau ntawm "OK" khawm.



3. Raws li koj tuaj yeem pom, ib daim ntawv teev npe tshwj xeeb ntawm cov kab xaiv tau muab los. Ntxiv mus, peb yuav tsum tau ua qhov zoo ib yam li hauv txoj kev 2 lossis hauv seb peb yuav tau ntxiv cov npe rau ib phau ntawv uas twb muaj lawm lossis tsim cov ntaub ntawv tshiab.

Txoj kev 5: Txuag cov ntaub ntawv hauv cov qauv zoo

Nyob rau hauv Excel, qee zaum koj yuav tsum khaws tsis tsuas yog cov npe, tab sis kuj tseem tsim hauv 1C cov ntaub ntawv (cov nyiaj, nyiaj ua haujlwm them nyiaj, thiab lwm yam). Qhov no yog vim qhov tseeb uas rau ntau tus neeg siv los kho cov ntawv yog yooj yim dua hauv kev ua tau zoo. Ib qho ntxiv, koj tuaj yeem rho tawm cov ntaub ntawv ua tiav hauv Excel thiab, luam ntawv rau daim ntawv, siv nws yog tias tsim nyog raws li daim foos.

1. Hauv 1C nyob rau hauv daim ntawv ntawm kev tsim cov ntaub ntawv twg muaj lub khawm luam tawm. Nws muaj ib lub cim nyob rau hauv daim ntawv ntawm cov duab ntawm lub tshuab luam ntawv. Tom qab daim ntawv nkag mus rau hauv daim ntawv thiab nws tau txais kev cawmdim, nyem rau ntawm lub cim no.



2. Daim ntawv luam tawm qhib. Tab sis peb, raws li peb nco ntsoov, koj yuav tsum luam tawm ib daim ntawv, tab sis kom hloov nws mus rau Excel. Qhov yooj yim hauv version 1C 8.3 tau ua los ntawm txhaj rau ntawm "Tseg" khawm nyob rau hauv daim ntawv ntawm lub floppy disk.

   

   Rau cov lej ua ntej lawm



3. Ib daim ntawv teev txuag qhov rai qhib. Raws li nyob rau hauv cov kev dhau los dhau los, nws yuav tsum tau qhia txog qhov chaw nyob ntawm cov ntaub ntawv khaws cia. Hauv cov ntaub ntawv hom teb, koj yuav tsum sau ib qho ntawm cov qauv zoo. Tsis txhob hnov ​​qab muab lub npe ntawm daim ntawv hauv "Cov ntaub ntawv npe" teb. Tom qab ua txhua qhov chaw, nyem rau "txuag" khawm.

Cov ntaub ntawv yuav raug cawm dim hauv Exel hom. Cov ntaub ntawv no tuaj yeem qhib rau hauv txoj haujlwm no, thiab ua txuas ntxiv nws yog twb tau nyob hauv nws.

Raws li koj tuaj yeem pom, cov ntaub ntawv xa tawm ntawm 1C hauv hom ntawv Excel tsis yog qhov nyuaj. Nws yog ib qho tsim nyog yuav tsum paub tsuas yog cov algorithm ntawm kev ua, txij li, hmoov tsis, nws tsis tau nkag siab rau txhua tus neeg siv. Siv cov cuab yeej ua 1C thiab Excel, koj tuaj yeem luam cov ntsiab lus ntawm cov cell, cov npe thiab cov ntawv sau ua cov npe thiab cov ntaub ntawv mus rau lwm phau ntawv. Kev xaiv kev txuag yog ntau heev thiab yog li tus neeg siv tuaj yeem pom kom haum rau nws cov software thib peb lossis siv cov kev sib txuas ua ke ntawm kev ua.