Kutsitsa deta kuchokera ku pulogalamu ya 1C kupita ku buku la ntchito la Excel

Si chinsinsi kuti pakati pa ogwira ntchito muofesi, makamaka iwo omwe ali pantchito yokhazikika ndi magawo azachuma, Excel ndi 1C ndi otchuka kwambiri. Chifukwa chake, nthawi zambiri ndikofunikira kusinthana pakati pa izi. Koma, mwatsoka, si onse ogwiritsa ntchito omwe amadziwa momwe angachitire izi mwachangu. Tiyeni tiwone momwe mungasungire deta kuchokera ku 1C kupita ku chikalata cha Excel.

Kutsegula zambiri kuchokera ku 1C kupita ku Excel

Ngati kutsitsa deta kuchokera ku Excel kupita ku 1C ndi njira yovuta kwambiri, yomwe ingathe kujambulidwa kokha mothandizidwa ndi mayankho ena, ndiye kuti njira yosinthira, yomwe ndi kutsitsa kuchokera ku 1C mpaka Excel, ndizosavuta kuchita. Itha kuchitika mosavuta pogwiritsa ntchito zida zomwe zili pamwambapa, ndipo zitha kuchitidwa m'njira zingapo, kutengera zomwe wogwiritsa ntchito amafunika kusamutsa. Tiyeni tiwone momwe angachitire izi ndi zitsanzo zenizeni mu mtundu wa 1C 8.3.

Njira 1: kukopera zomwe zili mu khungu

Gawo limodzi la data lili mu cell 1C. Itha kusamutsidwira ku Excel pogwiritsa ntchito njira yanthawi zonse.

1. Sankhani khungu mu 1C, zomwe mukufuna kutengera. Timadulira pomwepo ndi batani la mbewa. Pazosankha zofanizira, sankhani Copy. Mutha kugwiritsanso ntchito njira yofikira paliponse yomwe imagwira ntchito pamapulogalamu ambiri omwe akukhudzidwa ndi Windows: ingosankha zomwe zili mu foniyo ndikusindikiza mawonekedwe ofunika pa kiyibodi Ctrl + C.



2. Tsegulani pepala lopanda kanthu la Excel kapena chikalata chomwe mukufuna kuyika zomwe zili. Timadina kumanja ndikusintha menyu omwe amawoneka, pazosankha zoyika, sankhani "Sungani zolemba zokha", chomwe chikuwonetsedwa ngati chithunzi pachithunzi cha zilembo zazikulu "A".

   

   M'malo mwake, mutha kusankha foni mutasankhidwa pa tabu "Pofikira"dinani pachizindikiro Ikaniili pa tepi mu block Clipboard.

   

   Mutha kugwiritsanso ntchito njira yachilengedwe ndikulemba njira yaying'ono pa kiyibodi Ctrl + V khungu litasankhidwa.

Zomwe zili mu cell 1C zidzayikidwa mu Excel.

Njira 2: ikani mndandanda mu buku lakale la Excel

Koma njira yomwe ili pamwambapa ndiyoyenera kokha ngati muyenera kusamutsa deta kuchokera mu foni imodzi. Mukafuna kusamutsa mndandanda wonse, muyenera kugwiritsa ntchito njira ina, chifukwa kukopera chinthu chimodzi kumatenga nthawi yambiri.

1. Timatsegula mndandanda uliwonse, magazini kapena chikwatu mu 1C. Dinani batani "Zochita zonse", yomwe iyenera kukhala pamwamba pamndandanda wakonzedwa. Zosankha zayambitsidwa. Sankhani zomwe zili mmenemo "Mndandanda".



2. Bokosi laling'ono limatseguka. Apa mutha kusintha zina.

   Mundawo "Zotsatira kwa" ili ndi matanthauzo awiri:

   • Chikalata chofalitsira;
   • Chikalata cholemba.

   Njira yoyamba imakhazikitsidwa ndi kusakhazikika. Ndizoyenera kusamutsa deta ku Excel, ndiye kuti pano sitisintha kalikonse.

   Mu block Onetsani Zambiri Mutha kutchulagawo liti pamndandanda womwe mukufuna kusintha kukhala Excel. Ngati mukusamutsa data yonse, ndiye kuti sitikhudza izi. Ngati mukufuna kutembenuza popanda mzere kapena mizati ingapo, ndiye kuti simumayimitsa zinthu zomwe zikugwirizana.

   Zosintha zikamalizidwa, dinani batani "Zabwino".



3. Kenako mndandanda umawonetsedwa mu mawonekedwe a tabular. Ngati mukufuna kusamutsira ku fayilo ya Excel yongomaliza, ingosankha chidziwitso chonse chomwe chili nacho ndi thumba pomwe muli ndi batani lakumanzere, ndiye dinani kusankha ndi batani la mbewa ndikusankha chinthucho menyu omwe akutsegula Copy. Mutha kugwiritsa ntchito kuphatikiza kwa hotkey chimodzimodzi ndi momwe munapangira njira yapita Ctrl + C.



4. Tsegulani pepala la Microsoft Excel ndikusankha khungu lamanzere lakumanzere komwe idathayo idzaikemo. Kenako dinani batani Ikani pa riboni pa tabu "Pofikira" kapena lembani njira yachidule Ctrl + V.

Mndandanda umayikidwa mu chikalatacho.

Njira 3: pangani buku latsopano la Excel ndi mndandanda

Komanso mndandanda kuchokera ku pulogalamu ya 1C ukhoza kuwonetsedwa mufayilo yatsopano ya Excel.

1. Timagwira zonse zomwe zidafotokozedwera mu njira yamberi tisanapangire mndandanda mu 1C mwanjira yokhazikika. Pambuyo pake, dinani batani la menyu, lomwe lili kumtunda kwa zenera mu mawonekedwe a makona atatu omwe amalembedwa mu mabwalo a lalanje. Pazosankha zomwe zimatseguka, pitani pazinthuzo Fayilo ndi "Sungani Monga ...".

   

   Ndiosavuta kwambiri kusintha ndikudina batani Sungani, yomwe ili ndi mawonekedwe a diskette ndipo ili m'bokosi la chida 1C pamwambamwamba pawindo. Koma mwayi woterewu umapezeka kwa okhawo omwe amagwiritsa ntchito pulogalamuyo 8.3. M'mitundu yakale, ndi mtundu wakale wokha womwe ungagwiritsidwe ntchito.

   

   Komanso, mumitundu yonse yam pulogalamuyi, mutha akanikizire kuphatikiza kiyi kuti mukakhazikitse zenera lopulumutsa Ctrl + S.

2. Zenera lopulumutsa limayamba. Timapita kumalo osungira omwe tikukonzekera kupulumutsira bukuli ngati malo osakwanira sagwirizana. M'munda Mtundu wa Fayilo mtengo wokhazikika "Chikalata cha Tabular (* .mxl)". Izi sizikugwirizana, chifukwa chake, kuchokera mndandanda wotsika, sankhani chinthucho "Excel worksetet (* .xls)" kapena "Phukusi lolemba la Excel 2007 - ... (* .xlsx)". Komanso, ngati mukufuna, mutha kusankha mitundu yakale kwambiri - Mapepala a Excel 95 kapena Tsamba la "Excel 97". Zosungidwa zisungidwe zitapangidwa, dinani batani Sungani.

Mndandanda wonse udzapulumutsidwa ngati buku losiyana.

Njira 4: koperani masanjidwe osiyanasiyana kuchokera pamndandanda wa 1C ku Excel

Pali nthawi zina pamene muyenera kusamutsa mndandanda wonse, koma mzere umodzi kapena zingapo. Njirayi ndiyothekanso kutha kugwiritsa ntchito zida zopangidwa.

1. Sankhani mizere kapena mtundu wambiri wa mndandanda. Kuti muchite izi, gwiritsani batani Shift ndikudina kumanzere pamizere yomwe mukufuna kusamutsa. Dinani batani "Zochita zonse". Pazosankha zomwe zimapezeka, sankhani "Mndandanda ...".



2. Zenera lotulutsa limayamba. Zokonda mmenemo zimapangidwa mofananamo ndi njira ziwiri zapitazo. Chopata chokhacho ndikuti muyenera kuyang'ana bokosi pafupi ndi paramu Kusankhidwa Kokha. Pambuyo pake, dinani batani "Zabwino".



3. Monga mukuwonera, mndandanda wokhala ndi mizere yosankhidwa ukuwonetsedwa. Chotsatira, tifunika kuchita chimodzimodzi monga in Njira 2 kapena mkati Njira 3, kutengera ngati tiziwonjezera mndandanda kubukhu lomwe likulembedwapo la Excel kapena pangani chikalata chatsopano.

Njira 5: Sungani zikalata mu mtundu wa Excel

Ku Excel, nthawi zina ndikofunikira kuti musasunge mindandanda yokha, komanso zolembedwa zopangidwa mu 1C (maakaunti, ma invoice, ndalama zolipirira, ndi zina zambiri). Izi ndichifukwa choti kwa owerenga ambiri kusintha chikalata ndikosavuta ku Excel. Kuphatikiza apo, mu Excel, mutha kufufuta zonse zomwe mwamaliza ndipo mutasindikiza chikalatacho, chigwiritseni ntchito ngati kuli kofunikira ngati fomu yodzazira.

1. Mu 1C, mwanjira yopanga chikalata chilichonse, pali batani losindikiza. Pali chithunzi mu mawonekedwe a chithunzi chosindikizira nacho. Pambuyo pazofunikira zofunika zidalowetsedwa mu chikalatacho ndikusungidwa, dinani patsamba ili.



2. Fomu yosindikiza imatsegulidwa. Koma ife, monga tikukumbukira, sitifunikira kusindikiza chikalatacho, koma kusinthidwa kukhala Excel. Chosavuta kwambiri mu mtundu 1C 8.3 chitani izi podina batani Sungani mu mawonekedwe a diskette.

   

   Mwa mitundu yakale timagwiritsa ntchito kuphatikiza kwa hotkey Ctrl + S kapena ndikudina batani la menyu mu mawonekedwe a kanema wosaloweka pamwamba pazenera, timadutsa zinthuzo Fayilo ndi Sungani.



3. Tsamba la chikalata chopulumutsa likutsegulidwa. Monga momwe m'mbuyomu, muyenera kufotokozera komwe fayilo yomwe idasungidwamo. M'munda Mtundu wa Fayilo Muyenera kutchula mtundu wina wa mawonekedwe a Excel. Musaiwale kutchula chikalatacho mundawo "Fayilo dzina". Mukamaliza kukonza zosintha zonse, dinani batani Sungani.

Chikalatachi chidzasungidwa mu mtundu wa Excel. Fayiloyi itha kutsegulidwa mu pulogalamu iyi, ndikuchita momwemo kale.

Monga mukuwonera, kuyika zidziwitso kuchokera ku 1C kupita ku Excel mtundu sikovuta. Mukungofunika kudziwa mayendedwe amachitidwe, chifukwa, mwatsoka, si kwa onse ogwiritsa ntchito mwachilengedwe. Pogwiritsa ntchito zida zopangidwa mu 1C ndi Excel, mutha kukopera zomwe zili m'maselo, mindandanda, komanso kuchokera pazoyambira koyamba mpaka zachiwiri, komanso sungani mindandanda ndi zikalata kuti mulekanitse mabuku. Pali zosankha zambiri zosungira, kuti wogwiritsa ntchito apeze yoyenera pamkhalidwe wake, palibe chifukwa chogwiritsa ntchito mapulogalamu ena kapena kugwiritsa ntchito zinthu zovuta.