Ukulayisha ukusuka kwi-Excel kwi-1c: Imiyalelo yokusebenza

Sele kudala, eyona nkqubo ithandwayo phakathi kwababhali, abacwangcisi, oonoqoqosho kunye nabaphathi bengu-Annex 1c. Ayizizo iintlobo ngeentlobo zeentlobo zemisebenzi eyahlukeneyo, kodwa ikwayale finsed kwimigangatho yokuphendula kumazwe aliqela ehlabathi. Amashishini amaninzi ngakumbi atshintshelwe kwi-Accounting kule nkqubo. Kodwa inkqubo yokuhambisa idatha ngesandla kwezinye iinkqubo ze-akhawunti kwi-1c sisifundo eside nesihle, nto leyo eyenzekayo. Ukuba ishishini lirekhodwe ngokusebenzisa i-Excel, inkqubo yokudluliselwa inokuba yengozi kwaye ikhawuleziswe.

Ukudlulisela idatha kwi-Excel ukuya kwi-1c

Ukudlulisela idatha kwi-Excel kwi-1c ayimfuneko kwixesha lokuqala lokusebenza kule nkqubo. Ngamanye amaxesha iyeza kwimfuno yale nto, ngexesha lomsebenzi, kufuneka ubeke uluhlu olunye olugcinwe kwincwadi yeProjekthi yePropeskor. Umzekelo, ukuba ufuna ukutshintshela uluhlu lwamaxabiso okanye ii-odolo kwivenkile ekwi-Intanethi. Kwimeko apho uluhlu luncinci, baya kuqhutywa ngesandla, kodwa yintoni endifanele ndiyenze ukuba banamakhulu ezinto? Ukwenzela ukukhawulezisa inkqubo, ungabhenela kwezinye izinto ezongeziweyo.

Phantse zonke iintlobo zamaxwebhu ziya kulungela ukhuphelo oluzenzekelayo:

• Uluhlu lokungasebenzi;
• Uluhlu lwamalungu olwala;
• Uluhlu lwamaxabiso;
• Uluhlu lwee-odolo;
• Ulwazi malunga nokuthenga okanye ukuthengisa, njl.

Kwaoko kufuneka kuqatshelwe ukuba kwi-1C akukho izixhobo ezakhiweyo ezinokukuvumela ukuba udlulise idatha ukusuka kwi-Excel. Ngezi njongo, kufuneka uqhagamshele i-bootloader yangaphandle, eyifayile kwifomathi ye-EPF.

Ukulungiswa kwedatha

Kuya kufuneka silungiselele idatha kwitafile ye-Excel ngokwakho.

1. Naluphi na uluhlu olulayishwe kwi-1C kufuneka lube ngokwakhiwe ngendlela efanayo. Awunakho ukukhupha ukuba kukho iintlobo ezininzi zedatha kwikholamu enye okanye iseli, umzekelo, igama lomntu kunye nenombolo yefowuni. Kule meko, iirekhodi eziphindwe kabini kufuneka zahlukaniswe kwiikholamu ezahlukeneyo.



2. Akuvumelekanga ukuba ube neeseli ezigcweleyo nasezintloko. Oku kunokukhokelela kwiziphumo ezingachanekanga xa kudlulisa idatha. Ke ngoko, ukuba iiseli ezihlanganisiweyo ziyafumaneka, ziyahlulwa.



3. Ukuba itheyibhile yomthombo yenziwe ilula kangangoko inokwenzeka kwaye icacile, ngaphandle kokufaka isicelo setekhnoloji entsonkothileyo (i-macros, ifomula, izinto ezisezantsi, ziya kukunceda ukwandisa iindlela zokuphendula.



4. Qiniseka ukuba uza negama lawo onke amaxabiso kwifomathi enye. Akukho sitshixo asivumelekanga, umzekelo, ikhilogramu eboniswe ziirekhodi ezahlukeneyo: "kg", "kilogram", "kg.". Le nkqubo iza kuziqonda njengezixabisekileyo ezahlukeneyo, ke kufuneka ukhethe ukhetho olunye, kwaye ezinye zilungisiwe phantsi kwale template.



5. Qiniseka ukuba unezichazi ezizodwa. Iziqulatho zayo nayiphi na ikholamu inokudlalwa kwindima yazo, engaphindwanga eminye imiqolo: inombolo yerhafu nganye, inqaku, njl. Ukuba akukho kholam kwitafile ekhoyo enexabiso elifanayo, unokongeza ikholamu eyongezelelweyo kwaye uvelise inani elilula apho. Oku kuyimfuneko ukuze kulandelwe inkqubo yokuchonga idatha kumgca ngamnye ngokwahlukeneyo, kwaye ayizihlanganisi ".



6. Uninzi lweefayile ze-Excel zisebenza ngefomathi ye-XLSX, kodwa kuphela ngefomathi ye-XLS kuphela. Ke ngoko, ukuba uxwebhu lwethu lunolwando lweXalsx, kuya kufuneka ukuguqula. Ukwenza oku, yiya kwi "Ifayile" yethebhu kwaye ucofe iqhosha u "Gcina njenge" iqhosha.

   

   I-Window ivuliwe. Ifomati emiselweyo ye-XLSX iya kuchazwa kwintsimi ye "Ifayile". Siyayitshintsha kwi "Bhodi i-Iscel 97-2003" kwaye ucofe iqhosha "longa".

   

   Emva koko, olu xwebhu luya kusindiswa ngendlela oyifunayo.

Ukongeza kwezi zenzo jikelele zokulungiselela idatha kwincwadi ye-Excel, kuya kufuneka uzisa uxwebhu ngokuhambelana neemfuno ze-bootloader ekhethekileyo, kodwa siya kuthetha ngapha ngezantsi.

Ukuqhagamshela i-bootloader yangaphandle

Qhagamshela i-bootloader yangaphandle ye-bootfloader enesihlomelo kwi-Applix 1c inokuba njengaphambi kokuba ulungiselele ifayile ye-Excel nasemva koko. Eyona nto iphambili kukuqalisa inkqubo yokwenza ukhuphelo lwala maxesha okulungiselela lusonjululwe.

Kukho amacwecwe amakhulu okugxothwa kwangaphandle kwi-1c, edalwe ngabaphuhlisi abahlukeneyo. Siza kuqwalasela umzekelo osebenzisa isixhobo sokulungisa ulwazi "Khuphela idatha evela kuxwebhu lwe-tabuster" lwenguqulo ye-1C 8.3.

1. Emva kwefayile kwifomati ye-EPF ekhutshelweyo kwaye igcinwe kwi-hard disk yekhompyuter, yazisa inkqubo ye-1C. Ukuba ifayile ye-EPF ipakishwe kwindawo yokugcina, kufuneka isuswe apho. Kwiphaneli yesicelo esezantsi ethe tyaba, cinezela iqhosha eliqhuba imenyu. Kwinguqulelo ye-1C 8.3, iboniswa ngohlobo lolwalukelo lwenxantathu ebhalwe kwi-orenji, engle. Kuluhlu oluvelayo, ngokulandelelana hamba "kwifayile" kunye "evulekileyo".



2. Ifayile evulekileyo yefayile iqala. Yiya kwisikhombisi sendawo yaso, sibalaselisa loo nto kwaye ucofe iqhosha elithi "vula".



3. Emva koko, i-bootloader iya kuqala kwi-1c.

Ukukhuphela iflow "Idatha yokukhuphela kuxwebhu lwetafile"

Ukulayisha idatha

Omnye woovimba weenkcukacha eziphambili apho basebenza khona 1C luluhlu lweemveliso kunye neenkonzo. Ke ngoko, ukuchaza inkqubo yokulayisha ukusuka kwi-Excel, siya kugxila kumzekelo wokudluliselwa kolu hlobo lwedatha.

1. Buyela kwifestile yokulungisa. Kuba siza kulayisha le mveliso, ke kwi "Iparamitha, iswitch kufuneka ime" isikhundla "isikhundla. Nangona kunjalo, ifakwe nje ngokungagqibekanga. Kuya kufuneka uyitshintshe kuphela xa uza kudlulisela olunye uhlobo lwedatha: Icandelo le-tabuster okanye irejista yolwazi. Emva koko, endle "Ukujonga isikhombisi" ngokunqakraza kwiqhosha le-DOT eliboniswe kuwo. Uluhlu lwehlayo luvule. Kuyo, kufuneka sikhethe into "nomphumo".



2. Emva koko, isiphatho esiphathwa ngokuzenzekelayo sibeka intsimi esetyenziswayo le nkqubo ngohlobo lolawulo. Kuyimfuneko ukuba uqaphele ngokukhawuleza ukuba akunyanzelekanga ukuba ugcwalise onke amasimi.



3. Ngoku vula uxwebhu lwe-Excel ophathwayo. Ukuba igama leekholamu zalo lahlukile kwigama lemimandla ye-1c, equkethe efanelekileyo, ke kufuneka igama kwakhona le kholan kwi-Presele ukuze amagama aqengqeleke ngokupheleleyo ukuze amagama aphesheya. Ukuba kukho iikholamu ezitafileni apho kukho i-alogues kwisalathiso, kufuneka zisuswe. Kwimeko yethu, iikholamu ezinje "ubungakanani" kunye "nexabiso". Kuya kufuneka kongezelelwa ukuba i-odolo yendlela yokubekwa kwekholamu kuxwebhu kufuneka ihambelane nelowo iboniswe kwiNkqubo. Ukuba iikholamu ezithile eziboniswe kwi-bootloader ongenayo idatha, emva koko ezi kholamu zingashiywa zingenanto, kodwa inani leekholamu apho idatha ifanelekile. Ukulula kunye nesantya sokuhlela, ungawusebenzisa into ekhethekileyo ye-Excel ukuze ususe ngokukhawuleza iikholamu ngokweendawo.

   Emva kokuba ezi zenziwa, nqakraza kwi-Icon "Gcina" i-icon, emele i-pictomgram ebonisa idiski yefloppy kwikona ephezulu yefestile. Emva koko vala ifayile ngokunqakraza kwiqhosha lokuvala elimiselweyo.



4. Buyela kwifestile yokulungisa i-1c. Cofa kwiqhosha elithi "Vula", eliboniswe njengefolda yetyheli.



5. Ifayile evulekileyo yefayile iqala. Yiya kulawulo apho uxwebhu lwe-Excel lufumaneka khona, esiludingayo. Ifayile yokubonisa okungagqibekanga iseti yokwandisa i-MXL. Ukwenzela ukubonisa ifayile oyifunayo, kuyafuneka ukuba uphinde uphinde uphinde uyisebenzise kwisikhundla "iphepha le-Excel". Emva koko, sabela uxwebhu oluphathekayo kwaye ucofe iqhosha elithi "vula".



6. Emva koko, iziqulatho zivuliwe kwisiphathangi. Ukujonga ukuchaneka kokugcwaliswa kwedatha, cofa kwi "Lawula ulawulo".



7. Njengoko ubona, isixhobo solawulo lokugcwalisa ukuzaliswa sisixelela ukuba iimpazamo azifumaneki.



8. Ngoku sifudukela kwi "Useto" ngethebhu. Kwintsimi yokukhangela 'sibeka uphawu lomgca ukuba onke amagama angeniswe kwi-Nomestory Directory iya kwahlukile. Ihlala ihleli ngokusebenzisa amasimi "inqaku elithi" okanye "igama". Kuyimfuneko ukuba kwenzeke ukuze xa uyongeza izikhundla ezintsha kuluhlu, idatha ayizange inikezele.



9. Emva kokuba yonke idatha yenziwa kwaye kusekwe izicwangciso, ungaya kukhutshelo lwengcaciso ngqo yolwazi kwisalathiso. Ukwenza oku, cofa kumbhalo "wokukhuphela idatha".



10. Inkqubo ye-boot yenziwe. Emva kokuwugqiba, ungaya kwisikhombisi sobume kwaye uqiniseke ukuba yonke idatha eyimfuneko yongezwa apho.

Isifundo: Ungayitshintsha njani iikholamu kwiindawo ze-Excel

Sasilandele inkqubo yokongeza idatha kwi-Nomengelo: Kwezinye iincwadi kunye namaxwebhu, ukhuphelo luya kwenziwa kwimigaqo efanayo, kodwa ngenye into eya kuba nakho ukuyiqonda ngokuzimeleyo. Kuya kufuneka kuqatshelwe ukuba ii-boot-quaders ezahlukeneyo zeqela le-boot-quatring zinokuba yinkqubo eyahlukileyo, kodwa indlela iyonke ihlala iyongezwa ulwazi kwifayile kwifestile apho ihlelwe khona, kwaye kuphela emva koko yongezwa ngokuthe ngqo kwi-1C Idatha.