Kev xa cov ntaub ntawv ntawm 1C program rau Excel workbook

Nws tsis pub leejtwg paub tias ntawm cov neeg ua haujlwm hauv chaw ua haujlwm, tshwj xeeb cov neeg ua haujlwm nyob hauv kev hais daws thiab nyiaj txiag, Excel thiab 1C tshwj xeeb tshaj yog. Yog li no, ntau zaus nws yog qhov yuav tsum tau hloov xov xwm nruab nrab ntawm cov ntawv thov no. Tab sis, hmoov tsis, tsis yog txhua tus neeg siv yuav tsum paub ua sai sai no. Cia peb kawm seb yuav ua li cas upload cov ntaub ntawv ntawm 1C rau ib daim ntawv Excel.

Kev xa cov ntaub ntawv ntawm 1C txog Excel

Yog hais tias rub tawm cov ntaub ntawv los ntawm Excel rau 1C yog qhov txheej txheem nyuaj, uas tuaj yeem siv lub tshuab ua haujlwm nkaus xwb nrog kev pab ntawm thib peb cov kev daws teeb meem, tom qab ntawd cov txheej txheem thim rov qab, hu ua unloading los ntawm 1C rau Excel, yog qhov kev hloov pauv yooj yim. Nws tuaj yeem ua tau yooj yim siv cov cuab yeej tsim ntawm cov kev pab cuam saum toj no, thiab qhov no tuaj yeem ua tiav ntau txoj hauv kev, nyob ntawm seb tus neeg siv yuav tsum hloov mus. Cia peb pom yuav ua li cas ua li no nrog cov piv txwv nyob hauv 1C version 8.3.

Txoj Kev 1: luam tawm cov xov tooj ntawm tes

Ib chav ntsuas ntawm cov ntaub ntawv muaj nyob hauv cell 1C. Nws tuaj yeem pauv mus rau Excel siv tus qauv daim qauv li niaj zaus.

1. Xaiv lub xov tooj ntawm 1C, cov ntsiab lus uas koj xav luam. Peb nyem rau nws nrog txoj khawm nas. Hauv cov ntsiab lus teb ntawv qhia zaub mov, xaiv LuamCov. Koj tseem tuaj yeem siv tus txheej txheem thoob ntiaj teb uas ua haujlwm nyob rau hauv feem ntau cov haujlwm uas khiav ntawm Windows: tsuas yog xaiv cov ntsiab lus ntawm lub xov tooj thiab ntaus tus tseem ceeb ua ke ntawm cov keyboard Ctrl + C.



2. Qhib ib daim ntawv dawb hauv Excel los yog ntawv qhov chaw uas koj xav kom lo cov ntawv. Peb muaj txoj cai nyem thiab hauv cov ntawv qhia zaub mov uas tshwm nyob rau hauv qhov kev xaiv nkag los xaiv "Tseg tsuas ntawv", uas tau piav qhia txog daim duab pictogram hauv tsab ntawv ntawm tsab ntawv loj "A".

   

   Hloov chaw, koj tuaj yeem xaiv lub cell tom qab raug xaiv hauv lub tab "Tsev"nyem rau ntawm qhov icon Muab tshuaj txhuamnyob rau ntawm daim kab xev hauv block Ntawv Los Teev Cia.

   

   Koj tseem tuaj yeem siv txoj kev siv thoob ntiaj teb thiab ntaus tus cim lus luv ntawm cov keyboard Ctrl + V tom qab ntawm tes tau xaiv.

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

Txoj Kev 2: ntxig rau npe rau hauv Excel phau ntawv uas twb muaj lawm

Tab sis cov qauv txheej txheem saum toj no tsuas yog haum yog tias koj xav tau hloov ntaub ntawv los ntawm ib lub cell. Thaum koj xav kom hloov tag nrho cov npe, koj yuav tsum siv tus txheej txheem sib txawv, vim tias kev luam theej ntawm ib yam khoom yuav siv sijhawm ntau.

1. Peb qhib txhua daim npe, cov ntawv xov xwm lossis cov npe hauv 1C. Nyem rau feem khawm "Txhua yam kev ua", uas yuav tsum tau nyob rau sab saum toj ntawm cov txheej txheem cov ntaub ntawv. Cov zaub mov xa tawm. Xaiv cov khoom hauv nws "Sau".



2. Ib lub npe me me qhib. Ntawm no koj tuaj yeem ua qee qhov kev teeb tsa.

   Tus teb "Tawm rau" muaj ob lub ntsiab lus:

   • Daim ntawv teev cov ntaub ntawv;
   • Ntawv ntawv.

   Thawj qhov kev xaiv tau teeb tsa los ntawm lub neej ntawd. Nws tsuas yog haum rau kev xa cov ntaub ntawv rau Excel, yog li ntawm no peb tsis hloov dab tsi.

   Ntawm kev thaiv Cov ntawv txhua Koj tuaj yeem qhia lub sijhawm twg los ntawm daim ntawv koj xav hloov mus rau Excel. Yog tias koj yuav hloov xa tag nrho cov ntaub ntawv, tom qab ntawd peb tsis chwv qhov teeb tsa no ib qho twg. Yog tias koj xav hloov dua siab tshiab tsis muaj qee kem lossis ob peb kem, ces kos cov khoom tsis raug.

   Tom qab kev teeb tsa ua tiav, nyem rau ntawm lub pob "OK".



3. Tom qab ntawd daim ntawv yog tshwm hauv tabular daim. Yog tias koj xav hloov nws mus rau Excel cov ntawv tiav, tsuas yog xaiv txhua cov ntaub ntawv hauv nws nrog tus cursor thaum tuav khawm sab laug, ces nyem rau xaiv nrog khawm nas thiab xaiv cov khoom hauv cov ntawv qhia uas qhib LuamCov. Koj tuaj yeem siv cov nqaij ntses sib xyaw ua ke nrog txoj hauv kev ib yam li hauv hom dhau los Ctrl + C.



4. Qhib cov Microsoft Excel ntawv thiab xaiv lub sab laug sab sauv ntawm cov ntau yam uas cov ntaub ntawv yuav ntsaws. Nyem ntawd tag khawm Muab tshuaj txhuam ntawm txoj hlua xov hauv lub tab "Tsev" lossis ntaus ntawv hla Ctrl + V.

Daim ntawv yog ntxig rau hauv daim ntawv.

Txoj Kev 3: tsim ib phau ntawv ua haujlwm Excel tshiab nrog rau cov npe

Tsis tas li ntawd, cov npe los ntawm 1C program yuav tuaj yeem tshwm sim tam sim ntawd hauv Excel qhov tshiab.

1. Peb nqa tawm tag nrho cov kauj ruam uas tau qhia nyob rau hauv hom dhau los ua ntej tsim cov ntawv teev npe hauv 1C hauv cov tabular version suav. Tom qab ntawd, nyem rau ntawm daim ntawv qhia zaub mov khawm, uas yog nyob rau sab saum toj ntawm lub qhov rais hauv daim ntawv ntawm ib daim duab peb sab sau rau hauv lub voj voos kab ntxwv. Hauv cov ntawv qhia zaub mov uas qhib, mus txog cov khoom Cov ntaub ntawv thiab "Tseg Raws Li ...".

   

   Nws yooj yim dua rau kev hloov pauv los ntawm nias lub khawm Txuag, uas muaj daim foos diskette thiab muaj nyob hauv lub cuab yeej 1C ntawm qhov rais kawg. Tab sis cov caij nyoog zoo li no tsuas yog muaj rau cov neeg siv siv qhov program program 8.3Cov. Hauv cov qauv ua ntej, tsuas yog siv dhau los thiaj siv tau.

   

   Tsis tas li ntawd, nyob rau hauv txhua qhov kev hloov kho ntawm lub program, koj tuaj yeem nias qhov tseem ceeb ua ke kom qhib lub qhov rai txuag Ctrl + S.

2. Lub txuag cov ntaub ntawv qhov rai pib. Peb mus rau phau ntawv qhia txoj hauv kev uas peb npaj yuav khaws phau ntawv yog tias qhov chaw nyob tsis haum. Hauv dab teb Hom Ntawv tus nqi neej ntawd "Cov ntaub ntawv tab (* .mxl)"Cov. Qhov no tsis haum rau peb, yog li ntawd, los ntawm daim ntawv teev cia, xaiv cov khoom "Daim ntawv ua haujlwm Excel (* .xls)" lossis "Daim ntawv ua haujlwm Excel 2007 - ... (* .xlsx)"Cov. Tsis tas li, yog tias koj xav tau, koj tuaj yeem xaiv cov qub qub - Excel 95 Ntawv lossis "Excel 97 daim ntawv"Cov. Tom qab kev txuag chaw tau ua, nyem rau ntawm lub pob Txuag.

Daim ntawv teev tag nrho yuav raug muab khaws cia ua ib phau ntawv cais.

Txoj Kev 4: luam tawm ntau ntawm ib daim ntawv 1C hauv Excel

Muaj qee lub sijhawm koj yuav tsum hloov mus rau tsis yog tag nrho cov npe, tab sis tsuas yog cov kab ib leeg lossis ntau cov ntaub ntawv. Qhov kev xaiv no kuj ua tau nrog kev pab ntawm cov cuab yeej built-in.

1. Xaiv cov kab lossis ntau cov ntaub ntawv hauv kab. Ua li no, tuav lub pob nyem Ua haujlwm thiab sab laug-nyem rau ntawm kab uas koj xav hloov. Nyem rau feem khawm "Txhua yam kev ua"Cov. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv "Sau ...".



2. Daim ntawv teev cov zis qhov rai pib. Cov chaw hauv nws tau tsim nyob hauv tib txoj kev ib yam li hauv ob txoj kev dhau los. Tus caveat tsuas yog tias koj yuav tsum tau khij lub npov nyob ib sab ntawm qhov ntsuas Tsuas XaivCov. Tom qab ntawv, nyem rau ntawm lub pob "OK".



3. Raws li koj tuaj yeem pom, ib daim ntawv teev npe nrog tshwj xeeb ntawm xaiv kab yog tso tawm. Tom ntej no, peb yuav tsum tau ua qhov kev coj ua zoo ib yam li hauv Txoj Kev 2 lossis hauv Txoj Kev 3, nyob ntawm seb peb puas yuav ntxiv cov npe rau ib phau ntawv Excel uas twb muaj lawm lossis tsim daim ntawv tshiab.

Txoj Kev 5: Khaws cov ntaub ntawv hauv Excel hom

Hauv Excel, qee zaum nws yuav tsum tau txuag tsis yog tsuas yog cov npe, tab sis kuj muaj cov ntaub ntawv tsim hauv 1C (cov txhab nyiaj, cov ntawv them nyiaj, kev them nyiaj xaj, thiab lwm yam). Qhov no yog vim muaj qhov tseeb tias rau ntau tus neeg siv kho cov ntaub ntawv yooj yim dua hauv Excel. Tsis tas li ntawd, hauv Excel, koj tuaj yeem lwv cov ntaub ntawv tiav thiab, uas tau luam tawm daim ntawv, siv nws yog tias tsim nyog ua daim ntawv rau phau ntawv sau.

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



2. Ib daim foos rau kev luam ntawv qhib. Tab sis peb, raws li peb nco, tsis tas yuav luam daim ntawv, tab sis hloov nws mus rau Excel. Yooj yim tshaj plaws hauv version 1C 8.3 ua qhov no los txhaj rau lub pob Txuag nyob rau hauv daim ntawv ntawm diskette.

   

   Rau cov qauv ua ntej peb siv los ua ke nrog hotkey Ctrl + S lossis los ntawm txhaj rau lub tshuab raj khawm hauv daim ntawv ntawm ib qho tsis sib haum ntawm sab saum toj ntawm lub qhov rais, peb mus dhau cov khoom Cov ntaub ntawv thiab Txuag.



3. Cov ntawv khaws tseg ntawm lub qhov rais qhib. Raws li nyob rau hauv txoj kev dhau los, koj yuav tsum qhia kom meej qhov chaw ntawm cov ntawv khaws tseg hauv nws. Hauv dab teb Hom Ntawv Koj yuav tsum tau qhia ib qho ntawm Excel hom. Tsis txhob hnov ​​qab sau npe cov ntawv hauv daim teb "Cov ntaub ntawv npe"Cov. Tom qab ua tiav kev teeb tsa txhua yam, nyem rau ntawm lub pob Txuag.

Cov ntawv yuav raug cawm hauv Excel hom ntawv. Cov ntaub ntawv tam sim no tuaj yeem qhib hauv cov program no, thiab nqa tawm nws cov kev coj ua ntxiv hauv nws.

Raws li koj tuaj yeem pom, kev xa cov ntaub ntawv los ntawm 1C rau Excel hom tsis yog qhov nyuaj. Koj tsuas yog yuav tsum paub txog lub algorithm ntawm kev ua, vim, hmoov tsis, tsis yog rau txhua tus neeg siv nws yog kev paub. Siv cov cuab yeej ua tau 1C thiab Excel, koj tuaj yeem luam cov ntsiab lus ntawm cov hlwb, cov npe thiab kab lus los ntawm thawj daim ntawv thov mus rau qhov thib ob, ntxiv rau khaws cov npe thiab cov ntawv sau hauv phau ntawv cais. Muaj ntau txoj kev xaiv rau txuag, thiab nyob rau hauv kev txiav txim rau tus neeg siv kom nrhiav tau txoj hauv kev rau nws qhov xwm txheej, tsis tas yuav tsum muaj txoj hauv kev los siv cov software thib peb lossis siv cov kev sib txuas ua ke.