Ana sauke bayanai daga shirin 1C zuwa littafin aiki na Excel

Ba asirin ba ne cewa tsakanin ma'aikatan ofis, musamman waɗanda suke aiki a cikin sasantawa da sassan kuɗi, Excel da 1C sun shahara sosai. Saboda haka, a mafi yawan lokuta wajibi ne don musayar bayanai tsakanin waɗannan aikace-aikacen. Amma, da rashin alheri, ba duk masu amfani ba ne suka san yadda ake yin wannan da sauri. Bari mu gano yadda za a loda bayanai daga 1C zuwa takaddar Excel.

Ana saukar da bayani daga 1C zuwa Excel

Idan zazzage bayanai daga Excel zuwa 1C tsari ne mai rikitarwa, wanda za'a iya sarrafa kansa kawai tare da taimakon hanyoyin na uku, sannan tsarin juyawa, shine zazzagewa daga 1C zuwa Excel, tsari ne mai sauƙin aiki. Ana iya aiwatar da shi sauƙin amfani da kayan aikin ginannun shirye-shiryen da ke sama, kuma ana iya yin wannan ta hanyoyi da yawa, gwargwadon abin da mai amfani ya buƙaci canja wurin. Bari mu ga yadda ake yin wannan tare da takamaiman misalai a cikin sigar 1C 8.3.

Hanyar 1: kwafe abinda ke ciki

Rukunin bayanai guda ɗaya yana cikin sel 1C. Ana iya tura shi zuwa Excel ta amfani da hanyar kwafin da aka saba.

1. Zaɓi sel a cikin 1C, abin da kake son kwafa. Mun danna shi tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu, zaɓi Kwafa. Hakanan zaka iya amfani da hanyar duniya wanda ke aiki a yawancin shirye-shiryen da ke gudana akan Windows: kawai zaɓi abubuwan da ke cikin tantanin kuma danna maɓallin maɓalli a kan maballin. Ctrl + C.



2. Bude takarda Excel ko blank inda kake son liƙa abubuwan da ke ciki. Mun danna-dama da cikin menu na mahallin da ke bayyana, a cikin zaɓin shigar, zaɓi "Ajiye rubutu kawai", wanda aka nuna a cikin hanyar hoton hoto a cikin hanyar babban harafi "A".

   

   Madadin haka, zaku iya zaɓar sel bayan an zaɓe ku a cikin shafin "Gida"danna alamar Mannalocated a kan tef a cikin toshe Clipboard.

   

   Hakanan zaka iya amfani da hanyar duniya kuma rubuta gajerar hanyar rubutu akan maballin Ctrl + V bayan an zaɓi tantanin.

Abubuwan da ke cikin tantanin halitta 1C za'a shigar dasu cikin Excel.

Hanyar 2: saka jerin a cikin littafin karatun Excel na yanzu

Amma hanyar da ke sama ta dace ne kawai idan kuna buƙatar canja wurin bayanai daga sel ɗaya. Lokacin da kuke buƙatar canja wurin jerin duka, ya kamata kuyi amfani da wata hanya dabam, saboda yin kwafi akan abu ɗaya zai ɗauki lokaci mai yawa.

1. Muna buɗe kowane jeri, mujallu ko kundin adireshi a cikin 1C. Latsa maballin "Dukkanin ayyuka", wanda yakamata ayi a saman bayanan da aka sarrafa. An ƙaddamar da menu. Zaɓi abu a ciki "Jerin".



2. Smallan ƙaramin akwatin jerin buɗe. Anan zaka iya yin wasu saiti.

   Filin "Fitarwa zuwa" yana da ma’anoni guda biyu:

   • Daftarin aiki;
   • Rubutun rubutu.

   Zaɓin na farko da aka saita ta tsohuwa. Ya dace kawai don canja wurin bayanai zuwa Excel, don haka a nan ba ma canza komai.

   A toshe Nuni ginshikan Kuna iya tantance wane rukunan daga jerin da kuke son juyawa zuwa Excel. Idan zaku canja wurin duk bayanan, to ba za mu taɓa wannan saitin ba. Idan kana son juyawa ba tare da wani shafi ba ko kuma ginshiƙai da yawa, to sai a buɗe sauran abubuwa masu dacewa.

   Bayan an gama saitunan, danna maballin "Yayi kyau".



3. Sannan an nuna jerin a cikin tsarin tabular. Idan kuna son canja wurin shi zuwa fayil ɗin Excel wanda aka gama, kawai zaɓi duk bayanan da ke ciki tare da siginan yayin riƙe maɓallin linzamin kwamfuta na hagu, sannan danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama kuma zaɓi abu a cikin menu wanda ke buɗe. Kwafa. Kuna iya amfani da haɗin hotkey daidai kamar yadda a cikin hanyar da ta gabata Ctrl + C.



4. Bude takardar Microsoft Excel ka zabi sashin hagu na sama na kewayon da za'a shigar da bayanan. Saika danna maballin Manna a kan kintinkiri a cikin shafin "Gida" ko buga gajerar hanya Ctrl + V.

An saka jerin cikin kundin.

Hanyar 3: ƙirƙiri sabon littafin aikin Excel da jeri

Hakanan, lissafin daga shirin 1C za'a iya nuna shi nan da nan a cikin sabon fayil na Excel.

1. Muna aiwatar da duk waɗancan matakan da aka nuna a cikin hanyar da ta gabata kafin ƙirƙirar lissafin a cikin 1C a cikin sigar taɗi gaba ɗaya. Bayan haka, danna maɓallin menu, wanda yake saman tebur a cikin nau'i na alwatika da aka rub inta a cikin da'irar orange. A cikin menu wanda yake buɗe, shiga cikin abubuwan Fayiloli da "Ajiye As ...".

   

   Yana da sauƙin sauƙin sauyawa ta danna maɓallin Ajiye, wanda ke da nau'in diskette kuma yana cikin akwatin kayan aiki 1C a saman saman taga. Amma irin wannan damar tana samuwa ne kawai ga masu amfani waɗanda ke amfani da sigar shirin 8.3. A farkon sigogin, za a iya amfani da sigar da ta gabata.

   

   Hakanan, a kowane juzu'in shirin, zaku iya latsa haɗin maɓallin don ƙaddamar da taga ajiyar Ctrl + S.

2. Fara fayil ɗin ajiyewa yana farawa. Mun je kan littafin da muke shirin adana littafin idan asalin wurin bai dace ba. A fagen Nau'in fayil tsoho darajar "Takardar rubutu (* .mxl)". Wannan bai dace da mu ba, saboda haka, daga jerin zaɓi, zaɓi abu "Kundin aikin Excel (* .xls)" ko "Excel 2007 takardar aiki - ... (* .xlsx)". Hakanan, idan kuna so, zaku iya zaɓar tsoffin tsoffin tsoffin littattafai - Fasali 95 ko "Excel 97 takardar". Bayan an yi saitin ajiyewa, danna maballin Ajiye.

Za'a ajiye duk jerin azaman littafi daban.

Hanyar 4: kwafa iyaka daga jerin 1C a Excel

Akwai lokutan da kuke buƙatar canja wurin ba duka jerin ba, amma kawai layin mutum ko kewayon bayanai. Wannan zaɓi shima zai yuwu sosai tare da taimakon kayan aikin da aka gina.

1. Zaɓi layuka ko kewayon bayanai a lissafin. Don yin wannan, riƙe maɓallin riƙe ƙasa Canji da kuma hagu-danna kan layin da kake son canja wurin. Latsa maballin "Dukkanin ayyuka". A cikin menu wanda ya bayyana, zaɓi "Lissafa ...".



2. Jerin kayan fitarwa yana farawa. Saiti a ciki ana yin su ne kamar yadda a cikin hanyoyin biyun da suka gabata. Iyakar abin da aka ɓata shine kawai kana buƙatar duba akwatin kusa da sigogi Zaɓa kaɗai. Bayan haka, danna maɓallin "Ok".



3. Kamar yadda kake gani, ana nuna jerin abubuwa waɗanda suka haɗa da zaɓaɓɓun layin da aka zaɓa. Na gaba, muna buƙatar aiwatar da daidai irin abubuwan da muke ciki Hanyar 2 ko a ciki Hanyar 3, ya danganta da ko za mu ƙara lissafi cikin littafin aiki na Excel mai gudana ko ƙirƙirar sabon daftarin aiki.

Hanyar 5: Ajiye takardu a cikin tsarin Excel

A cikin Excel, wani lokacin ya zama dole don adana ba kawai jerin abubuwa ba, har ma da takardun da aka kirkira a cikin 1C (asusun, wasiƙa, umarnin biyan kuɗi, da sauransu). Wannan ya faru ne saboda gaskiyar cewa ga masu amfani da yawa da ke daftarin aiki suna da sauƙi a cikin Excel. Bugu da kari, a cikin Excel, zaku iya share bayanan da aka kammala kuma, bayan buga takardan, yi amfani da shi idan ya cancanta a matsayin tsari don cike takardar.

1. A cikin 1C, a cikin ƙirƙirar kowane takarda, akwai maɓallin bugawa. Akwai wani gunki kwatankwacin hoton firinta a jikinta. Bayan an shigar da bayanai masu mahimmanci a cikin takaddun kuma an ajiye shi, danna wannan gunkin.



2. Wani fom don bugawa yana buɗewa. Amma mu, kamar yadda muke tunawa, ba ma buƙatar buga takaddar, amma canza shi zuwa Excel. Mafi sauki cikin sigar 1C 8.3 yi wannan ta danna maballin Ajiye a cikin hanyar diskette.

   

   Don sigogin farko muna amfani da haɗin hotkey Ctrl + S ko ta danna maɓallin menu a cikin nau'i na alwati mai rikitarwa a saman taga, muna tafiya cikin abubuwan. Fayiloli da Ajiye.



3. Window ɗin ajiya yana buɗe. Kamar yadda a cikin hanyoyin da suka gabata, kuna buƙatar bayyana wurin fayil ɗin da aka ajiye a ciki. A fagen Nau'in fayil Dole ne a fayyace ɗayan ingantaccen tsarin. Kar a manta sanya sunan daftarin aiki a fagen "Sunan fayil". Bayan kammala dukkan saitunan, danna maballin Ajiye.

Za a adana takaddun a tsarin Excel. Yanzu za a iya buɗe wannan fayil ɗin a cikin wannan shirin, kuma a ci gaba da aiwatar da shi gabaɗaya a ciki.

Kamar yadda kake gani, loda bayani daga 1C zuwa Tsarin Excel ba mai wahala bane. Abin sani kawai kuna buƙatar sanin hanyoyin aiwatarwa, saboda, rashin alheri, ba ga duk masu amfani ba ne mai hankali. Amfani da ginanniyar kayan aikin 1C da Excel, zaku iya kwafar abubuwan da ke cikin sel, jerin abubuwa, da jeri daga aikace-aikacen farko zuwa na biyu, tare da adana jerin da takardu don raba littattafai. Akwai zaɓuɓɓuka da yawa don adanawa, kuma don mai amfani ya nemi wanda ya dace don yanayinsa, babu buƙatar komawa zuwa amfani da software na ɓangare na uku ko sanya hadadden ayyukan.