Gupakurura amakuru kuva 1c muri Excel: Uburyo bwakazi

Ntabwo rwihishwa ko mubakozi bo mu biro, byumwihariko abakora ibicuruzwa byo gutura hamwe nubukungu, porogaramu za Excel na 1C zirakunzwe cyane. Kubwibyo, akenshi ni nkenerwa guhana amakuru hagati yibi bikorwa. Ariko, ikibabaje, ntabwo abakoresha bose bazi kubikora vuba. Reka tumenye uburyo bwo kohereza amakuru kuva 1c kugeza Excel Inyandiko.

Kohereza amakuru kuva 1c muri Excel

Niba amakuru yishyurwa muri 1C nuburyo bugoye, urashobora kwikora gusa kubisubizo bya gatatu, noneho inzira nyabagendwa, ni ukuvuga ko ipakurura 1c kuri Excel ibikorwa byoroshye. Birashobora kugerwaho byoroshye ukoresheje ibikoresho byubatswe-kubikoresho byavuzwe haruguru, kandi urashobora kubikora muburyo butandukanye, ukurikije ibyo umukoresha agomba kwimurwa. Reba uburyo bikorwa ku ngero zihariye muri 1c verisiyo 8.3.

Uburyo 1: Gukoporora ibikubiyemo

Igice kimwe cyamakuru gikubiye muri kall ka 1c. Irashobora kwimurirwa kugirango birusheho gukoporora.

1. Turagaragaza selile muri 1c, ibikubiyemo ushaka gukoporora. Kanda kuri Iburyo bwimbeba. Muri menu, hitamo ikintu "kopi". Urashobora kandi gukoresha uburyo rusange ukora muri gahunda nyinshi zikora kuri Windows OS: Hitamo gusa ibiri muri kasho hanyuma wandike urufunguzo rwo guhuza Ctrl + C.



2. Fungura urutonde rwuzuye rwa Excel cyangwa inyandiko ukeneye kwinjizamo ibirimo. Hamwe na buto yimbeba iburyo no muri menu igaragara mubice byinjiza, hitamo "kubika inyandiko gusa" ikintu, cyerekanwe muburyo bwa pictografiya "a".

   

   Ahubwo, ibikorwa birashobora gukoreshwa nyuma yo guhitamo tax mugihe muri tab "murugo", kanda kuri "Shyiramo", uherereye kuri kaseti muri clip chilg.

   

   Urashobora kandi gukoresha inzira rusange no guhamagara CTRL + V urufunguzo kuri clavier nyuma yuko selile igaragazwa.

Ibiri mu Kagari ka 1c bizashyirwaho muri Excel.

Uburyo 2: Kwinjiza urutonde mubitabo bihari

Ariko uburyo bwavuzwe haruguru buzakwira hose niba ukeneye kohereza amakuru kuva muri selire imwe. Mugihe ukeneye kwimura urutonde rwose, ugomba gukoresha ubundi buryo, kuko gukoporora ikintu kimwe kizafata umwanya munini.

1. Fungura urutonde urwo arirwo rwose, igitabo cyangwa igitabo cyerekanwe muri 1c. Kanda kuri buto ya "Ibikorwa byose", bigomba kuba hejuru yamakuru array itunganywa. Ibikubiyemo byatangiye. Hitamo muri yo ikintu "cyerekana urutonde".



2. Idirishya risohoka. Hano urashobora gukora igenamiterere.

   Umwanya "Erekana B" ufite indangagaciro ebyiri:

   • Inyandiko y'imbotike;
   • Inyandiko.

   Mburabuzi nuburyo bwa mbere. Kumuboherereza amakuru kuri Excel, birakwiriye, kugirango hano ntacyo duhinduye.

   Muri "kwerekana abavuga" blok, urashobora kwerekana abavuga kurutonde ushaka guhindura neza. Niba ugiye gusohoza amakuru yose, nawe ntukora kuri iyi miterere. Niba ushaka gukora guhinduka nta nkingi cyangwa inkingi nyinshi, hanyuma ukureho amatiku mubintu bihuye.

   Nyuma yigenamiterere rirangiye, kanda kuri buto "OK".



3. Noneho urutonde rwerekanwe muburyo bwa tangabuto. Niba ushaka kohereza kuri dosiye yiteguye neza, hitamo gusa amakuru yose hamwe na indanga hamwe na buto yimbeba yibumoso, hanyuma ukande kuri buto yimbeba iburyo hanyuma uhitemo ikintu cyafunguye. Urashobora kandi gukoresha guhuza urufunguzo rushyushye Ctrl + s.



4. Gufungura Microsoft Urupapuro rwa Microsoft hanyuma uhitemo urwego rwo hejuru rwibanze aho amakuru azacirwamo. Noneho kanda kuri buto ya "Paste" kuri kaseti muri tab ya tab cyangwa wandike CTRL + V Ingano.

Urutonde rwinjijwe mu nyandiko.

Uburyo 3: Gukora igitabo gishya cyurutonde hamwe nurutonde

Kandi, urutonde rwa gahunda ya 1c rushobora guhita rugaragara muri dosiye nshya ya Excel.

1. Turakora iyo ntambwe zose zasobanuwe muburyo bwambere mbere yo gukora urutonde muri 1c muburyo bwa pular burimo. Nyuma yibyo, twongeyeho kurubuga rwo guhamagara, ruherereye hejuru yidirishya muburyo bwa mpandeshatu ryanditse mu ruziga rwa orange. Muri menu iyobora menu, unyuze muri "dosiye" na "kuzigama nka ...".

   

   Ntabwo byoroshye gukora inzibacyuho ukanze buto "Kubika", ifite floppy kureba kandi iherereye muri 1C ibikoresho bya 1C hejuru yidirishya. Ariko ubu buryo burahari gusa kubakoresha bakoresha verisiyo 8.3 Gahunda. Muri verisiyo kare, urashobora gukoresha gusa amahitamo yabanjirije.

   

   Kandi muri verisiyo iyo ari yo yose ya porogaramu yo gutangiza idirishya riteka, urashobora gukanda urufunguzo rwa CTRL +.

2. Idirishya ryo kuzigama dosiye ritangira. Jya mububiko duteganya kubika igitabo niba aho bitanyuzwe n'ahantu hasanzwe. Muburyo bwa dosiye, isanzwe ni "Inyandiko ya Drabbook (* .Mxl)". Ntabwo biduhuza, nuko uhitamo kurutonde rwamanutse "Excel (* .xls) urupapuro cyangwa" Excel 2007 urupapuro rwa "... (* .xlsx)." Niba ubishaka, urashobora guhitamo imiterere ishaje cyane - "Excel 95" cyangwa "Excel 97 urupapuro". Nyuma yo kubika igenamiterere bikozwe, kanda kuri buto "Kubika".

Urutonde rwose ruzakizwa nigitabo cyihariye.

Uburyo 4: Gukoporora intera kuva kumurongo wa 1c kuri excel

Hariho ibibazo mugihe ukeneye kwimura urutonde rwose, ariko umurongo kugiti cyawe cyangwa amakuru. Ihitamo rizanagirana na hamwe ibikoresho byubatswe.

1. Hitamo imirongo cyangwa urutonde rwamakuru kurutonde. Kugirango ukore ibi, clamp buto ya shift hanyuma ukande buto yimbeba yibumoso kumirongo kugirango yimurwe. Kanda ahanditse "ibikorwa byose". Muri menu igaragara, hitamo "kwerekana urutonde ..." ikintu.



2. Urutonde rwo gusohoka rwashyizwe ahagaragara. Igenamiterere muri ryo ryakozwe muburyo bumwe nkuko muburyo bubiri bwabanjirije. Umunyamuryango wonyine ni uko ukeneye kwinjizamo amatiku kubyerekeye "ibipimo byeguriwe" wenyine. Nyuma yibyo, kanda kuri buto "OK".



3. Nkuko mubibona, urutonde rugizwe numurongo watoranijwe. Byongeye, tuzakenera gukora neza ibikorwa bimwe nko muburyo bwa 2 cyangwa muburyo bwa 3, ukurikije niba tugiye kongeramo urutonde rwigitabo cyitwa Excel cyangwa gukora inyandiko nshya.

Uburyo 5: Kuzigama inyandiko muburyo butandukanye

Muri Excel, rimwe na rimwe ugomba kuzigama ntabwo ari urutonde gusa, ahubwo waremye mu nyandiko za 1c (konti, amabwiriza yo kwishyura hejuru, nibindi). Ibi biterwa nuko kubakoresha benshi guhindura inyandiko biroroshye muri Excel. Mubyongeyeho, urashobora gusiba amakuru yuzuye muri Excel kandi, gucapa inyandiko, koresha nibiba ngombwa nkuburyo bwo kuzuza intoki.

1. Muri 1C muburyo bwo gukora inyandiko iyo ari yo yose hari buto yo gucapa. Irimo igishushanyo muburyo bwishusho ya printer. Nyuma yinyandiko yinjiye mu nyandiko kandi irakijijwe, kanda kuri iki gishushanyo.



2. Ifishi y'icapa irakinguye. Ariko twe, nkuko tubyibuka, ugomba gucapa inyandiko, ahubwo ugomba kuyihindura kuba indashyikirwa. Inzira yoroshye muri verisiyo ya 1c 8.3 ikorwa ukanze kuri buto "Kubika" muburyo bwa disiki ya disiki.

   

   Kumyandiko mikuru, dukoresha guhuza urufunguzo rushyushye Ctrl + s cyangwa ukanda buto yo gusohora muburyo bwa mpandeshatu yahinduwe hejuru yidirishya, dukurikiza dosiye "na" gukiza ".



3. Idirishya ryo kuzigama inyandiko rifungura. Nko muburyo bwambere, bukeneye kwerekana aho dosiye yabitswe. Muburyo bwa dosiye, ugomba kwerekana kimwe muri format ya excel. Ntiwibagirwe gutanga izina ryinyandiko muri "izina rya dosiye". Nyuma yo gukora igenamiterere ryose, kanda buto "Kubika".

Inyandiko izakizwa muburyo bwa exel. Iyi dosiye irashobora gufungurwa muriyi gahunda, kandi no gukomeza kubitunganya bimaze kubamo.

Nkuko mubibona, gupakurura amakuru kuva 1c muburyo bwiza ntabwo bigoye. Nibyiza kumenya gusa algorithm yibikorwa gusa, kuva, ikibabaje, ntabwo byumvikane neza kubakoresha bose. Gukoresha ibikoresho byubatswe 1c kandi Excel, urashobora gukoporora ibirigo bya selile, urutonde kandi ruva mubisabwa bwa mbere kugeza ku wa kabiri, kimwe no kubika urutonde hamwe ninyandiko mubitabo bitandukanye. Amahitamo yo kubungabunga ni menshi kandi kuburyo umukoresha ashobora kubona akwiriye uko ibintu bimeze, nta mpamvu yo kwitabaza ikoreshwa rya software ya gatatu cyangwa gukoresha ingamba zifatika.