Takardun Rubutun rubutu Csv amfani da shirye-shiryen kwamfuta da yawa don musayar bayanai tsakanin juna. Zai zama cewa a cikin Excel zaka iya ƙaddamar da irin wannan fayil tare da daidaitaccen danna sau biyu akansa tare da maɓallin linzamin kwamfuta na hagu, amma daga nesa a koyaushe a wannan yanayin ana nuna bayanan daidai. Gaskiya ne, akwai wata hanyar don ganin bayanan da ke cikin fayil. Csv. Bari mu bincika yadda ake yin wannan.
Bude CSV Takaddun shaida
Sunan tsari Csv yankewa ne na sunan "Maabi'u masu rarrabewa", wanda ke fassara zuwa Rashanci a matsayin "wakafi a ware dabi'u." Lallai, a cikin waɗannan fayil ɗin wakafi suna ɗaukar matsayin raba gari, kodayake a cikin sigogin Rashanci, ba kamar a Turanci ba, har yanzu al'ada ce don amfani da lafuzza
Lokacin shigo da fayiloli Csv A cikin Excel, ainihin matsalar ita ce rufin asiri. Sau da yawa, ana gabatar da takardu a cikin abin da Cyrillic yake ciki tare da rubutun da ke cike da "gashin gashi", wato haruffa marasa karantawa. Bugu da kari, batun rarrabuwar kawuna matsala ce ta kowa da kowa. Da farko dai, wannan ya shafi yanayi idan muka yi ƙoƙarin buɗe takaddun da aka yi a wasu shirye-shiryen Turanci, Excel, wanda aka ƙaddara a matsayin mai amfani da harshen Rashanci. Tabbas, a cikin tushen, mai keɓewa a matsayin wakafi ne, kuma Excel mai magana da harshen Rashanci yana tsinkaye wani wasan semicolon a cikin wannan ingancin. Sabili da haka, an sake samun sakamako wanda ba daidai ba. Za mu gaya muku yadda ake warware waɗannan matsalolin lokacin buɗe fayiloli.
Hanyar 1: Bude fayil a al'ada
Amma da farko, zamu mayar da hankali kan zaɓi yayin daftarin aiki Csv wanda aka kirkira a cikin shirye-shiryen yaren Rasha kuma yana shirye don buɗewa cikin Excel ba tare da ƙarin magudin abubuwan da ke ciki ba.
Idan an riga an shigar da Excel don buɗe takardu Csv akan kwamfutarka ta atomatik, a wannan yanayin, kawai danna fayil ɗin ta danna maɓallin linzamin kwamfuta na hagu sau biyu, zai buɗe a cikin Excel. Idan har yanzu ba a kafa haɗin ba, to a wannan yanayin, kuna buƙatar yin ƙarin ƙarin takaddun amfani.
- Kasancewa a ciki Windows Explorer a cikin shugabanci inda fayil ɗin yake, danna-dama kai tsaye. An ƙaddamar da menu na mahallin. Zaɓi abu a ciki Bude tare da. Idan ƙarin jerin buɗewa ya ƙunshi sunan "Ofishin Microsoft", saika danna shi. Bayan haka, takaddar za ta gudana ne kawai a kan misalin ku na Excel. Amma, idan baku sami wannan abun ba, to danna kan matsayin "Zaɓi shirin".
- Ana buɗe buɗe zaɓi na shirin. Anan, kuma, idan a cikin toshe Shirye-shiryen da aka ba da shawarar za ku ga sunan "Ofishin Microsoft"sannan ka zavi shi ka danna maballin "Ok". Amma kafin hakan, idan kuna son fayilolin Csv koyaushe yana buɗe ta atomatik a cikin Excel lokacin da ka danna sau biyu akan sunan shirin, to ka tabbata cewa kusa da sigogi "Yi amfani da shirin da aka zaɓa don duk fayilolin wannan nau'in" akwai alamar rajista.
Idan sunaye "Ofishin Microsoft" a cikin taga zaɓi na shirin ba ku samu ba, to danna kan maɓallin "Yi bita ...".
- Bayan haka, taga Explorer zai buɗe a cikin jagoran inda aka shigar shirye-shirye a kwamfutarka. Ana kiran wannan babban fayil "Fayilolin shirin" kuma yana cikin tushen faifai C. Dole ne ku je zuwa Firefox a adireshin masu zuwa:
C: Fayilolin Shirya Microsoft Office Office№Inda maimakon wata alama "№" Ya kamata ya zama nau'in sigar mafi girman sigar ofishin Microsoft da aka sanya a kwamfutarka. A matsayinka na mai mulkin, akwai guda ɗaya irin wannan babban fayil, don haka zaɓi directory Ofishinkomai lambarsa. Matsawa zuwa takamaiman directory, bincika fayil wanda ake kira FASAHA ko "EXCEL.EXE". Na biyu nau'i na suna suna zai kasance idan kun haɗa jerin abubuwan fashewa a ciki Windows Explorer. Haskaka wannan fayil ɗin kuma danna maballin. "Bude ...".
- Bayan wannan shirin "Microsoft Excel" Za a ƙara zuwa taga zaɓi na shirin, wanda muka yi magana game da shi a baya. Za ku buƙaci kawai zaɓi sunan da kuke so, waƙa da kasancewar alamar alama kusa da maƙallin ɗaukar nau'in fayil ɗin (idan kuna son buɗe takaddun kullun. Csv a cikin Excel) kuma danna maballin "Ok".
Bayan haka, abubuwan da ke cikin takaddar Csv za a buɗe a Excel. Amma wannan hanyar ta dace ne kawai idan ba a sami matsaloli tare da keɓance ko tare da nuna haruffan Cyrillic ba. Bugu da kari, kamar yadda muke gani, zamuyi wasu gyare-gyare na takaddar: tunda bayanin ba koyaushe ya dace da girman kwayar ta yanzu ba, suna buƙatar fadada su.
Hanyar 2: amfani da Wizard Text
Kuna iya shigo da bayanai daga takardar tsarin CSV ta amfani da ginanniyar kayan aiki mai suna Excel Mayen rubutu.
- Gudun shirin Excel kuma tafi zuwa shafin "Bayanai". A kan kintinkiri a cikin akwatin kayan aiki "Samun bayanan waje" danna maballin da ake kira "Daga rubutun".
- Taga taga shigo da daftarin rubutu farawa. Mun matsa zuwa wurin directory na manufa fayil CVS. Zaɓi sunan shi kuma danna maɓallin "Shigo"wanda yake a gindin taga.
- An kunna taga Masters rubutu. A cikin toshe saitin Tsarin bayanai Wajibi ya kamata ya kasance cikin matsayi An ware. Don tabbatar da cewa abubuwan da aka zaɓa an nuna su daidai, musamman idan ya ƙunshi Cyrillic, kula da filin "Tsarin fayil" saita zuwa Unicode (UTF-8). In ba haka ba, kuna buƙatar shigar da hannu. Bayan an saita dukkan saiti na sama, danna maballin "Gaba".
- Sai taga na biyu ya buɗe. Masters rubutu. Anan yana da matukar muhimmanci a tantance wanne hali ne mai rabuwa a cikin aikin. A cikin yanayinmu, wannan rawar ana buga shi ta hanyar wasan kwaikwayo, tun daftarin aiki yaren Rasha ne kuma an keɓe shi musamman don sigar software na gida. Sabili da haka, a cikin toshe saitunan "Halin raba kayan shine" muna duba akwatin Semicolon. Amma idan ka shigo da fayil din CVS, wanda aka inganta don matsayin Turanci, kuma a matsayin mai raba shi a cikin wakafi, to ya kamata ka duba akwatin Takaice. Bayan an yi saitunan da ke sama, danna maballin "Gaba".
- Na uku taga yana buɗewa Masters rubutu. A matsayinka na mai mulkin, ba a buƙatar ƙarin ayyuka a ciki. Iyakar abin da ya rage ita ce idan ɗayan bayanan da aka gabatar a cikin takaddun suna kan hanyar kwanan wata. A wannan yanayin, kuna buƙatar alamar wannan shafi a ƙasan taga, da kuma juyawa a cikin toshe Tsarin Bayanai na Shafi saita zuwa matsayi Kwanan Wata. Amma a mafi yawan lokuta, tsoffin saitunan da aka saita tsarin sun isa "Janar". Don haka zaka iya danna maɓallin Anyi a kasan taga.
- Bayan wannan, ƙaramin taga don shigo da bayanai yana buɗewa. Ya kamata ya nuna daidaitawar ɓangaren hagun hagu na yankin inda za'a shigo da bayanan. Ana iya yin wannan ta kawai sanya siginar siginan kwamfuta a cikin taga, sannan danna-danna hagu a kan tantanin da ya dace a cikin takardar. Bayan haka, za a shigar da masu kula da ita a fagen. Kuna iya latsa maɓallin "Ok".
- Bayan haka, abubuwan da ke cikin fayil ɗin Csv za a haɗe a cikin ingantaccen takaddara. Haka kuma, kamar yadda muke gani, an nuna shi daidai yadda aka yi amfani da lokacin amfani Hanyar 1. Musamman, babu buƙatar ƙarin fadada girman sel.
Darasi: Yadda za a canza encoding a Excel
Hanyar 3: buɗe ta hanyar Fayil
Hakanan akwai hanyar buɗa takarda. Csv ta shafin Fayiloli Shirye-shirye masu kyau.
- Kaddamar da Excel kuma matsa zuwa shafin Fayiloli. Danna kan kayan "Bude"located a gefen hagu na taga.
- Window yana farawa Mai gudanarwa. Ya kamata ku matsa zuwa kundin adireshi a kan rumbun kwamfutarka ko a cikin hanyar cire iska wanda a ciki akwai takaddun ƙauna gare mu Csv. Bayan haka, kuna buƙatar sake shirya nau'in fayil ɗin a cikin taga zuwa wuri "Duk fayiloli". A wannan yanayin ne kawai takardar Csv za a nuna a taga tunda ba irin fayil ɗin Excel bane. Bayan an nuna sunan daftarin aiki, zaɓi shi kuma danna maballin "Bude" a kasan taga.
- Bayan haka, taga zai fara Masters rubutu. Dukkanin sauran ayyukan ana yin su gwargwadon aikin iri ɗaya kamar yadda yake a cikin Hanyar 2.
Kamar yadda kake gani, duk da wasu matsaloli game da bude tsarin takardu Csv a cikin Excel, har yanzu zaka iya warware su. Don yin wannan, yi amfani da ginanniyar kayan aikin da ake kira Mayen rubutu. Kodayake, saboda lamura da yawa, ya isa a yi amfani da daidaitaccen hanyar buɗe fayil ta danna maɓallin linzamin kwamfuta na hagu sau biyu akan sunanta.
