Kulemba deta kuchokera ku 1C kupita ku Excel

Si chinsinsi kuti mapulogalamu a Excel ndi 1C ali otchuka kwambiri pakati pa ogwira ntchito kuntchito, makamaka omwe akugwira nawo ntchito komanso ndalama. Choncho, nthawi zambiri ndikofunikira kusinthanitsa deta pakati pa ntchitoyi. Koma, mwatsoka, sikuti ogwiritsa ntchito onse amadziwa momwe angachitire mwamsanga. Tiyeni tiwone momwe tingathere deta kuchokera ku 1C ku kafukufuku wa Excel.

Kutumiza uthenga kuchokera ku 1C kupita ku Excel

Ngati kulumikiza deta kuchokera ku Excel kupita ku 1C ndi njira yovuta kwambiri, yomwe ingakhale yokha pokhapokha ndi kuthandizidwa ndi njira zotsatila chipani, ndiye kuti kulumikiza kuchokera ku 1C kupita ku Excel, ndi ntchito yosavuta. Zingagwiritsidwe ntchito mosavuta pogwiritsa ntchito zida zowonongeka za mapulogalamuwa, ndipo izi zikhoza kuchitika m'njira zingapo, malinga ndi zomwe wogwiritsa ntchito akufunikira kusintha. Lingalirani momwe mungachitire izi ndi zitsanzo zenizeni mu 1C version 8.3.

Njira 1: Koperani Mkati Mkati

Chigawo chimodzi cha deta chili mu selo 1C. Ikhoza kusamutsidwa ku Excel ndi njira yowonetsera yosinthika.

1. Sankhani selo mu 1C, zomwe mukufuna kuti muzitsatire. Dinani pa ilo ndi batani lamanja la mouse. Mu menyu yachidule, sankhani chinthucho "Kopani". Mungagwiritsenso ntchito njira yonse yomwe imagwira ntchito m'mapulogalamu ambiri akuyendetsa pa Windows Ctrl + C.



2. Tsegulani pepala losawoneka lopanda kanthu kapena chikalata chomwe mukufuna kufalitsa zomwe zili. Dinani botani lamanja la mouse ndi mndandanda wazomwe zikupezeka pazomwe mungapeze, sankhani chinthucho "Sungani malemba okha"yomwe ikuwonetsedwa ngati mawonekedwe a chilembo chachikulu "A".

   

   M'malo mwake, mungathe kuchita izi mutasankha selo, pokhala pa tab "Kunyumba"dinani pazithunzi Sakanizanizomwe ziri pa tepi mu chipika "Zokongoletsera".

   

   Mukhozanso kugwiritsa ntchito njira ya chilengedwe chonse ndikusintha njira yachinsinsi pa kambokosi Ctrl + V selo litayikidwa.

Zomwe zili mu selo 1C zidzalowetsedwa ku Excel.

Njira 2: Sakanizani mndandanda mu bukhu la Excel lomwe liripo kale

Koma njira yomwe ili pamwambayi ndi yoyenera pokhapokha ngati mukufuna kutumiza deta kuchokera ku selo limodzi. Pamene mukufuna kutumiza mndandanda wonse, muyenera kugwiritsa ntchito njira ina, chifukwa kukopera chinthu chimodzi panthawi kungatenge nthawi yochuluka.

1. Tsegulani mndandanda uliwonse, magazini kapena zolemba mu 1C. Dinani pa batani "Zochita Zonse"zomwe ziyenera kukhazikitsidwa pamwamba pa deta yosinthidwa. Menyu imayamba. Sankhani chinthu mmenemo "Onetsani List".



2. Bokosi laling'ono limatsegula. Pano mungathe kupanga zina.

   Munda "Chotsatira kwa" ali ndi matanthauzo awiri:

   • Chiwonetsero chazithunzi;
   • Chilemba cholemba.

   Njira yoyamba imayikidwa ndi chosasintha. Kuti mutumize deta ku Excel, ndi yabwino, kotero apa sitisintha chilichonse.

   Mu chipika "Onetsani zikhomo" Mukhoza kufotokoza ndondomeko ziti zomwe mwasintha kuti mutembenuzire ku Excel. Ngati mutumiza deta yonse, ndiye kuti izi sizidakhudzidwe. Ngati mukufuna kutembenuza popanda ndondomeko iliyonse kapena ndondomeko zingapo, ndiye musasinthe zinthu zomwe zikugwirizana.

   Pambuyo pokonzekera mapulogalamuwa, dinani pa batani. "Chabwino".



3. Ndiye mndandanda umasonyezedwa mu mawonekedwe apamwamba. Ngati mukufuna kulitumiza ku fayilo ya Excel yokonzedwa bwino, mungosankha deta yonse mmenemo ndi chithunzithunzi pamene mukugwira batani lamanzere, kenako dinani pakasankhidwe ndi batani lamanja la mouse ndipo sankhani chinthucho kumtundu wotsegulidwa "Kopani". Mukhozanso kugwiritsa ntchito makina otentha monga njira yapitayi. Ctrl + C.



4. Tsegulani pepala la Microsoft Excel ndipo sankhani selo lakumanzere lakumtunda kumene deta idzalowetsedwe. Kenaka dinani pa batani Sakanizani pa kaboni mu tab "Kunyumba" kapena kujambula njira yothetsera Ctrl + V.

Mndandandawo umalowetsedwamo muzolengeza.

Njira 3: Pangani buku latsopano la Excel ndi mndandanda

Ndiponso, mndandanda wochokera pa pulogalamu ya 1C ikhoza kutulutsidwa nthawi yomweyo ku fayilo yatsopano ya Excel.

1. Timachita masitepe onse omwe adasonyezedwa mu njira yapitayo musanayambe kulembedwa mndandanda mu 1C muwuniyumu yowonjezera. Pambuyo pake, dinani pakani la menyu, lomwe liri pamwamba pawindo pa mawonekedwe a katatu katatu kolembedwa muzunguliro lalanje. Poyambitsa menyu, pitani ku zinthu "Foni" ndi "Sungani Monga ...".

   

   Ngakhalenso zosavuta kupanga kusintha mwa kuwonekera pa batani Sungani "zomwe zimawoneka ngati disppy disk ndipo ili mu bokosi la bokosi la 1C pamwamba pawindo. Koma gawo ili likupezeka kwa ogwiritsa ntchito omwe akugwiritsa ntchito pulogalamuyi 8.3. Mumasulidwe oyambirira, Baibulo loyambirira lokha lingagwiritsidwe ntchito.

   

   Komanso muyeso iliyonse ya pulogalamuyi kuti muyambe kupulumutsa mawindo, mukhoza kusindikiza kuphatikiza Ctrl + S.

2. Fayilo yosungira mafayilo likuyamba. Pitani ku zolemba zomwe tikukonzekera kusunga bukhulo, ngati malo osasinthika sakukhutitsidwa. Kumunda "Fayilo Fayilo" mtengo wosasintha ndi "Ndandanda yamaphunziro (* .mxl)". Izo sizikugwirizana ndi ife, chotero kuchokera mundandanda wotsika pansi, sankhani chinthucho "Pulogalamu yamtundu (* .xls)" kapena "Pulogalamu ya Excel 2007 - ... (* .xlsx)". Komanso ngati mukufuna, mungasankhe maonekedwe akale kwambiri - "Tsamba la Excel 95" kapena "Pulogalamu 97". Pambuyo popanga zosintha, dinani pa batani. Sungani ".

Mndandanda wonsewo udzapulumutsidwa ngati buku losiyana.

Njira 4: Lembani zosiyana kuchokera ku 1C mndandanda ku Excel

Pali milandu pamene kuli kofunikira kusamutsa mndandanda wonse, koma mzere umodzi kapena deta yambiri. Njirayi ikuwonetseratu bwino ndi chithandizo cha zipangizo zomangidwira.

1. Sankhani mizere kapena mndandanda wa deta m'ndandanda. Kuti muchite izi, sungani batani Shift ndipo dinani batani lamanzere pamzere umene mukufuna kupita. Timakanikiza batani "Zochita Zonse". Mu menyu imene ikuwonekera, sankhani chinthucho "Onetsani mndandanda ...".



2. Mndandanda wamndandanda wowonjezera wayamba Zokonzera mmenemo zimapangidwa mofanana ndi njira ziwiri zapitazo. Gulu lokhalo ndilofunika kuti muwone bokosi "Kusankhidwa Kokha". Pambuyo pake, dinani pa batani "Chabwino".



3. Monga momwe mukuonera, mndandanda umene umangokhala mzere wokhawokha umasulidwa. Kenaka tikuyenera kuchita ndondomeko yomweyo Njira 2 kapena Njira 3malingana ndi kuti tionjezera mndandanda ku buku la Excel lomwe lilipo kapena pangani chikalata chatsopano.

Njira 5: Sungani zikalata mu Excel format

Mu Excel, nthawizina mumafunika kusunga mndandanda chabe, komanso malemba opangidwa mu 1C (mavoti, mavoti, ndi zina zotero). Izi zikuchitika chifukwa chakuti ogwiritsa ambiri ndizosavuta kusintha chikalata ku Excel. Kuonjezerapo, mu Excel, mukhoza kuchotsa deta yomaliza ndipo, mutasindikiza chikalata, gwiritsani ntchito, ngati kuli koyenera, ngati mawonekedwe a kudzazidwa.

1. Mu 1C, mwa mawonekedwe opanga chilemba chirichonse pali batani yosindikiza. Pa iyo ilipo pictogram mu mawonekedwe a fano la wosindikiza. Pambuyo pa deta yoyenera yalowa mu chikalata ndipo yasungidwa, dinani pazithunzi izi.



2. Fomu yosindikiza imatsegula. Koma ife, monga tikukumbukira, sitiyenera kusindikiza chikalatacho, koma timasintha ku Excel. Chophweka mu Version 1C 8.3 Chitani izi mwa kukanikiza batani Sungani " mu mawonekedwe a floppy disk.

   

   Kwa Mabaibulo oyambirira amagwiritsa ntchito makina otentha. Ctrl + S kapena powonjezera bulu la menyu mu mawonekedwe a katatu yosandulika kumtunda kwazenera, pitani ku zinthu "Foni" ndi Sungani ".



3. Fayilo lolemba mawonekedwe limatsegula. Monga momwe zinalili kale, ndikofunikira kufotokoza malo a fayilo yosungidwa. Kumunda "Fayilo Fayilo" tchulani chimodzi mwa maofomu a Excel. Musaiwale kupereka dzina la chikalata pamunda "Firimu". Pambuyo pokonza zonsezi dinani pa batani Sungani ".

Chidziwitsocho chidzapulumutsidwa mu Excel format. Fayiloyi tsopano ikhoza kutsegulidwa mu pulojekitiyi, ndipo kupititsa patsogolo kuli kale.

Monga mukuonera, kusungitsa uthenga kuchokera ku 1C mpaka Excel sikungabweretse mavuto. Mukufunikira kudziwa kokha ndondomeko ya ntchito, chifukwa, mwatsoka, sizowoneka bwino kwa ogwiritsa ntchito onse. Pogwiritsira ntchito zida zowonongeka 1C ndi Excel, mukhoza kufotokoza zomwe zili m'maselo, mndandanda ndi mndandanda kuchokera pa ntchito yoyamba mpaka yachiwiri, komanso kusunga mndandanda ndi zolembedwa m'mabuku osiyanasiyana. Pali njira zambiri zopulumutsira komanso kuti wogwiritsa ntchitoyo apeze zoyenera pazochitika zake, palibe chifukwa chofunira kugwiritsa ntchito mapulogalamu a chipani chachitatu kapena kugwiritsa ntchito zovuta zofanana.