Gupakira kuva Excel muri 1c: Amabwiriza y'akazi

Bumaze kuva kera, gahunda izwi cyane mubacunga, abategura, abahanga mu bukungu ni bogex 1C. Ntabwo ifite uburyo butandukanye gusa kubikorwa bitandukanye, ahubwo ifite no kumenyekanisha ibipimo bishinzwe ibaruramari mu bihugu byinshi byisi. Ibigo byinshi kandi byinshi byimurirwa kubibazwa muriyi gahunda. Ariko inzira yo kohereza amakuru intoki kuva kuri porogaramu zishinzwe ibaruramari muri 1C nisomo rirerire kandi rirambiranye, riba. Niba uruganda rwanditswe ukoresheje Excel, uburyo bwo kwimura burashobora kwihuta.

Kwimura amakuru kuva Excel kugeza 1C

Kwimura amakuru muri Excel muri 1c birasabwa mugihe cyambere cyo gukorana niyi gahunda. Rimwe na rimwe, birakenewe kubikenewe mugihe, mugihe cyibikorwa, ugomba gushyira urutonde mubitabo byo gutunganya igitabo. Kurugero, niba ukeneye kohereza urutonde cyangwa ibicuruzwa mububiko bwa interineti. Mugihe urutonde ari gito, noneho barashobora guterwa intoki, ariko niki nakora niba hari ibintu amagana? Kugirango wihutishe inzira, urashobora kwitabaza ibintu bimwe byiyongera.

Ubwoko bwinyandiko zose zikwiye gukuramo byikora:

• Urutonde rwizina;
• Urutonde rwa bagenzi babo;
• Urutonde rwibiciro;
• Urutonde rwamateka;
• Amakuru yerekeye kugura cyangwa kugurisha, nibindi

Kera, twakagombye kumenya ko muri 1C nta bikoresho byubatswe bikwemerera kohereza amakuru kuva Excel. Kuri izo ntego, ugomba guhuza bootloader yo hanze, ni dosiye muburyo bwa epf.

Gutegura amakuru

Tuzakenera gutegura amakuru kumeza ya Excel ubwayo.

1. Urutonde urwo arirwo rwose rwuzuye muri 1c rugomba kuba ruhuriweho rimwe. Ntushobora gukuramo niba hari ubwoko bwinshi bwamakuru mu nkingi imwe cyangwa selile, kurugero, izina ryumuntu na numero ya terefone. Muri uru rubanza, inyandiko ebyiri zigomba gutandukanywa muburyo butandukanye.



2. Ntabwo yemerewe kugira selile no mumitwe. Ibi birashobora kuganisha kubisubizo bitari byo mugihe cyohereza amakuru. Kubwibyo, niba selile zahujwe zirahari, zigomba kugabanwa.



3. Niba imbonerahamwe yinyuma ikozwe byoroshye kandi isobanutse, udashyize mubikorwa tekinoroji yihanganye (macros, ibitekerezo, ibitekerezo, ibitekerezo, ibitekerezo, bizafasha kugwiza ibibazo kubindi ntambwe.



4. Witondere kuzana izina ryindangagaciro zose kumiterere imwe. Nta cyerekezo kitemewe, nk'urugero, ikilo cyerekanwe n'inyandiko zitandukanye: "KG", "Kilogram", "Kg.". Porogaramu izabasobanukirwa nkindangagaciro zitandukanye, ugomba rero guhitamo uburyo bumwe, kandi ahasigaye birakosorwa munsi yikigereranyo.



5. Witondere kugira ibiranga bidasanzwe. Ibiri mu nkingi iyo ari yo yose birashobora gukinirwa mu ruhare rwabo, bitagusubirwamo muyindi mirongo: umubare w'imisoro ku giti cye, ingingo, n'ibindi. Niba nta nkingi mumeza ihari ifite agaciro gahari, urashobora kongeramo inkingi no kubyara umubare woroshye. Ibi birakenewe kugirango gahunda imenye amakuru muri buri murongo ukundi, kandi ntabwo "uhujwe".



6. Abashinzwe dosiye nziza cyane ntibakorana nuburyo bwa XlSX, ariko gusa hamwe na XLS. Kubwibyo, niba inyandiko yacu ifite kwagura XLSX, noneho niyo nkenerwa kuyihindura. Kugirango ukore ibi, jya kuri tab "dosiye" hanyuma ukande kuri buto "Kubika nka".

   

   Idirishya rikize. Imiterere isanzwe ya XLSX izagaragara muri "dosiye ya dosiye". Turabihindura kuri "Igitabo Excel 97-2003" hanyuma ukande kuri buto "Kubika".

   

   Nyuma yibyo, inyandiko izakizwa muburyo bwifuzwa.

Usibye ibyo bikorwa byisi yose kugirango utegure amakuru mugitabo cya Excel, uzakenera kuzana inyandiko bijyanye nibisabwa bootloader, ariko tuzabiganiraho hepfo.

Guhuza bootloader yo hanze

Huza bootloader yo hanze hamwe no kwagura EPF kumugereka 1c irashobora kuba nka mbere yo gutegura dosiye ya Excel na nyuma. Ikintu nyamukuru nugutangira inzira yo gukora ibikuramo byombi ibihe byitegura byakemutse.

Hano hari ibinini byinshi byo hanze kuri 1c, biremwa nabateza imbere batandukanye. Tuzasuzuma urugero dukoresheje igikoresho cyo gutunganya amakuru "gukuramo amakuru kuva inyandiko ya tangabuto" kuri verisiyo ya 1c 8.3.

1. Nyuma ya dosiye muburyo bwa EPF yakuweho kandi bwabitswe kuri disiki ikomeye ya mudasobwa, itangiza gahunda ya 1C. Niba dosiye ya EPF yuzuye mububiko, igomba kuva aho. Kumwanya wo hejuru wa horizontal, kanda buto ikora menu. Muri verisiyo ya 1c 8.3, hatangwa muburyo bwa clangle triangle byanditse mumuzenguruko wa orange, inguni. Kurutonde rugaragara, runyuze muri "dosiye" na "fungura".



2. Idosiye ifunguye idirishya ritangira. Jya mububiko bwaho, turagaragaza icyo kintu hanyuma ukande kuri buto "fungura".



3. Nyuma yibyo, bootloader izatangira muri 1c.

Gukuramo Gutunganya "Gukuramo amakuru kuva kumeza inyandiko"

Gupakira amakuru

Imwe mubana nyamukuru hamwe nibikorwa 1c ni urutonde rwibicuruzwa na serivisi. Kubwibyo, kugirango dusobanure uburyo bwo gupakira muri Excel, tuzibanda kurugero rwo guhererekanya ubu bwoko bwamakuru.

1. Garuka mu idirishya ritunganya. Kubera ko tuzapakira urutonde rwibicuruzwa, hanyuma muri "gupakira", guhinduranya bigomba guhagarara mumwanya "ububiko". Ariko, irashyizweho cyane kubisanzwe. Ugomba kubihindura gusa mugihe ugiye kwimura undi bwoko bwamakuru: Igice cya tatular cyangwa igitabo cyamakuru. Ibikurikira, mu murima "Reba Ububiko" ukanze kuri buto aho akadomo kerekanwe. Urutonde ruto rufungura. Muri yo, dukwiye guhitamo ikintu "impfu".



2. Nyuma yibyo, umukoresha ahita ashyira imirima gahunda ikoresha muri ubu buryo bwububiko. Birakenewe guhita menya ko bidakenewe kuzuza imirima yose.



3. Noneho ongera ufungure inyandiko ya Excel. Niba izina ryinkingi zayo ritandukanye nizina ryimirima ya 1c, ikubiyemo ingirakamaro, ugomba guhindura izina muri Excele kugirango uhuze rwose. Niba hari inkingi mumeza itarimo ibisambanyi mububiko, bigomba kuvaho. Ku bitureba, inkingi nk'izo ni "umubare" n "" igiciro ". Igomba kandi kongerwaho ko gahunda yinkingi yinkingi mu nyandiko igomba guhura cyane nukuri hamwe no gutunganya. Niba ku nkingi zimwe zerekanwa muri bootloader udafite amakuru, noneho inkingi zirashobora gusigara irimo ubusa, ariko umubare wizo nkingi aho amakuru agomba guhuriranya. Kugirango woroshye kandi umuvuduko wo guhindura, urashobora gukoresha ikintu cyihariye cya Excel kugirango wimure vuba inkingi ahantu.

   Nyuma yibi bikorwa byakozwe, kanda ahanditse "Kubika", uhagarariwe nka Pictografiya yerekana disiki ya disiki mugice cyo hejuru cyishyamba. Noneho funga dosiye ukanze kuri buto isanzwe yo gufunga.



4. Garuka mu idirishya rya 1C. Kanda kuri buto "fungura", bigaragazwa nkububiko bwumuhondo.



5. Idosiye ifunguye idirishya ritangira. Jya mububiko aho inyandiko ya Excel iherereye, dukeneye. Idosiye isanzwe yerekana switch igenewe kwagura MXL. Kugirango werekane dosiye ukeneye, birasabwa kutondekanya kumwanya "urupapuro rwa Excel". Nyuma yibyo, tugenera inyandiko igendanwa hanyuma ukande buto "Gufungura".



6. Nyuma yibyo, ibirimo birakingurwa mumurongo. Kugenzura ukuri kwuzuza amakuru, kanda ahanditse "Kuzuza".



7. Nkuko mubibona, igikoresho cyo kuzuza kitubwira ko amakosa atabonetse.



8. Noneho twimukira muri tab "igenamiterere". Mu "shakisha" dushyiramo akamenyetso ku murongo amazina yose yinjiye mu bubiko bwa Nomenclavelutions bizaba byihariye. Akenshi kubwibi gukoresha imirima "cyangwa" izina ". Ni ngombwa kubikora mugihe wongeyeho imyanya mishya kurutonde, amakuru ntiyashyizeho.



9. Nyuma yamakuru yose akozwe nigenamiterere bikozwe, urashobora kujya gukuramo amakuru mu buryo butaziguye mububiko. Kugirango ukore ibi, kanda kurinditse "gukuramo amakuru".



10. Inzira ya boot irakorwa. Nyuma yo kurangiza, urashobora kujya mububiko bwa Nomen kandi urebe neza ko amakuru yose akenewe yongeyeho.

Isomo: Nigute ushobora guhindura inkingi ahantu muri excel

Twakurikiranye inzira yo kongera amakuru mububiko bwa Nomenclation muri gahunda 1C 8.3. Kubindi bitabo ninyandiko, gukuramo bizakorwa ku ihame rimwe, ariko hamwe na nugence umukoresha azashobora kumva yigenga. Twabibutsa kandi ko abakora imyitozo yabandi bantu bashobora gutuma ibintu bitandukanye bikomeza, ariko inzira zose zituma amakuru akuramo amakuru ava kuri dosiye ujya mu idirishya kugeza kuri 1C Ububikoshingiro.