ODS shine tsarin shafukan da aka sani. Za mu iya cewa wannan wata irin kishiya ne ga siffofin Excel xls da xlsx. Bugu da ƙari, ODS, wanda ya bambanta da analogues masu sama, ana iya budewa, wato, ana iya amfani dashi kyauta kuma ba tare da izini ba. Duk da haka, haka kuma ya faru cewa an buƙaci daftarin aiki da ODS tsawo a Excel. Bari mu gano yadda za ayi wannan.
Hanyoyi don bude takardu a tsarin ODS
Fayil ɗin Rubutun OpenDocument (ODS), wanda kungiyar OASIS ta ƙaddamar, an yi nufin a ƙirƙira shi azaman kyauta na kyauta da kyauta na Excel. Duniya ta gan shi a shekarar 2006. A halin yanzu, ODS yana ɗaya daga cikin mahimman bayanai na wasu na'urori masu mahimmanci, ciki har da aikin kyauta na OpenOffice Calc. Amma tare da Excel a cikin wannan tsari, "aboki" ta halitta ba ta aiki ba, tun da sun kasance masu fafatawa na halitta. Idan za ka iya buɗe takardu a cikin tsarin ODS Excel tare da kayan aiki na asali, to, Microsoft ya ƙi gabatar da yiwuwar ajiye abu tare da irin wannan tsawo a cikin halittarsa.
Akwai dalilai da yawa don buɗe tsarin ODS a Excel. Alal misali, a kan kwamfutarka inda kake son gudanar da furofayil ɗin, mai yiwuwa ba za ka sami aikace-aikace na OpenOffice Calc ko wani daidai ba, amma za a shigar da Microsoft Office. Zai yiwu kuma ya kamata a yi aiki a kan tebur tare da kayan aikin da suke samuwa ne kawai a Excel. Bugu da ƙari, wasu masu amfani daga masu sarrafawa masu yawa sun ƙware ƙwarewa don aiki a matakin dace kawai tare da Excel. Wannan shine lokacin da batun bude wani takardu a wannan shirin ya zama dacewa.
Tsarin ya buɗe a cikin sassan Excel, farawa da Excel 2010, yana da sauki. Shirin ƙaddamarwa ba ya bambanta da bude duk wani takarda a cikin wannan aikace-aikacen, ciki har da abubuwa tare da kariyar xls da xlsx. Ko da yake akwai wasu nuances a nan, wanda zamu tattauna dalla-dalla a kasa. Amma a cikin sassan farko na wannan na'ura mai sarrafawa, hanyar budewa yana da mahimmanci. Wannan shi ne saboda gaskiyar cewa tsarin ODS ya bayyana ne kawai a shekara ta 2006. Masu haɓaka Microsoft sunyi amfani da ikon kaddamar da wannan takarda don Excel 2007 kusan a cikin layi tare da ci gabanta ta al'ummar OASIS. Don Excel 2003, dole in sake saki wani sashi na musamman, tun da an halicci wannan rukunin kafin a saki tsarin ODS.
Duk da haka, ko a cikin sababbin sassan Excel, ba koyaushe yana iya nuna waɗannan ɗakunan rubutu daidai ba kuma ba tare da hasara ba. Wani lokaci, lokacin yin amfani da tsari, ba dukkan abubuwa ba za'a iya shigo da kuma aikace-aikacen ya dawo da bayanai tare da hasara. Idan akwai matsalolin, saƙo mai bayani daidai ya bayyana. Amma, a matsayin mai mulkin, wannan ba zai tasiri mutunci na bayanan da ke cikin tebur ba.
Bari mu fara bayani a kan bude ODS a cikin sassan Excel na yanzu, sa'an nan kuma a taƙaice bayyana yadda wannan tsari ya faru a cikin tsofaffi.
Duba kuma: Excel Excel
Hanyarka 1: gudu ta cikin takardun bude taga
Da farko dai, bari mu dakatar da ƙaddamar da ODS ta taga ta bude wani takardun. Wannan hanya tana kama da hanya don buɗe littattafai na xls ko xlsx a cikin irin wannan hanyar, amma yana da ƙananan kaɗan amma muhimmiyar bambanci.
- Run Excel kuma je zuwa shafin "Fayil".
- A bude taga a cikin menu na gefen hagu danna kan maballin "Bude".
- Gilashin taga yana bude don buɗe takardun a Excel. Ya kamata ya motsa zuwa babban fayil inda aka samo abu a cikin tsarin ODS da kake son budewa. Kusa, kana buƙatar sake shirya fasalin fayil ɗin a cikin wannan taga zuwa matsayin "Rubutun Bayanin Shafi na Ƙari (* .ods)". Bayan haka, taga zai nuna abubuwa a cikin tsarin ODS. Wannan shi ne bambanci daga kaddamar da aka saba, wadda aka tattauna a sama. Bayan wannan, zaɓi sunan takaddun da muke buƙatar kuma danna maballin "Bude" a cikin ƙasa dama na taga.
- Za a bude daftarin kuma a nuna a takardar Excel.
Hanyar 2: danna maɓallin linzamin dama sau biyu
Bugu da ƙari, ƙirar misali ta buɗe fayil ɗin shine ta fara shi ta danna maɓallin linzamin hagu a kan sunan. Haka kuma, za ka iya buɗe ODS a Excel.
Idan kwamfutar ba ta da aikace-aikacen OpenOffice Calc da aka shigar kuma baza ka canja wurin bude tsoho tsarin ODS zuwa wani shirin ba, to sai ka gudana ta wannan hanya a Excel ba zai da matsaloli ba. Fayil ɗin zai bude, kamar yadda Excel ta gane shi a matsayin tebur. Amma idan an shigar da dakin OpenOffice a kan PC, to, idan ka danna sau biyu a kan fayil ɗin, zai fara a Calc, ba Excel. Domin kaddamar da ita a Excel, dole ne ka yi wasu manipulations.
- Don kiran menu na mahallin, danna-dama kan gunkin daftarin ODS wanda ya buƙatar bude. A cikin jerin ayyukan, zaɓi abu "Buɗe tare da". An kaddamar da wani ƙarin menu, wanda za'a nuna sunan a cikin jerin shirin. "Microsoft Excel". Danna kan shi.
- Kaddamar da abin da aka zaɓa a Excel.
Amma hanyar da aka sama ta dace ne kawai don buɗewa ɗaya na abu. Idan kayi shirin tattara bayanan ODS a Excel, kuma ba a sauran aikace-aikacen ba, to lallai yana da mahimmancin yin wannan aikace-aikacen shirin tsoho don aiki tare da fayiloli tare da ƙayyadadden ƙayyade. Bayan haka, bazai buƙatar yin ƙarin manipulations a kowane lokaci don buɗe littafin ba, kuma ya isa ya danna abu mai so tare da tsawo na ODS.
- Danna kan gunkin fayil tare da maɓallin linzamin linzamin dama. Bugu da ƙari, a cikin mahallin menu, zaɓi matsayi "Buɗe tare da"amma wannan lokaci a cikin ƙarin jerin danna kan abu "Zaɓi shirin ...".
Akwai kuma zaɓi madadin don zuwa jerin zaɓin shirin. Don yin wannan, sake, danna-dama a kan gunkin, amma wannan lokaci a cikin mahallin menu zaɓi abu "Properties".
A cikin dakin kaddarorin da suka fara, kasancewa a cikin shafin "Janar", danna kan maɓallin "Canji ..."wanda yake shi ne wanda yake fuskantar mota "Aikace-aikace".
- A cikin zaɓuka na farko da na biyu, zaɓin zaɓi na shirin zai fara. A cikin toshe "Shirye-shiryen da aka ba da shawarar" sunan ya kamata a kasance "Microsoft Excel". Zaɓi shi. Tabbatar tabbatar da cewa saitin "Yi amfani da shirin da aka zaba don dukkan fayiloli na irin wannan" akwai alamar. Idan batacce, ya kamata ka shigar da shi. Bayan yin matakan da ke sama, danna maballin. "Ok".
- Yanzu bayyanar gumakan ODS zai canza wani abu. Zai ƙara maɓallin Excel. Za a yi canji mafi muhimmanci. Idan ka danna maɓallin linzamin hagu sau biyu a kan kowane ɗayan waɗannan gumakan, za a buga takardun ta atomatik a Excel, kuma ba cikin OpenOffice Calc ko a wani aikace-aikace ba.
Akwai wani zaɓi don tsara Excel a matsayin aikace-aikacen tsoho don buɗe abubuwa tare da tsawo na ODS. Wannan zaɓi yana da haɗari, amma, duk da haka, akwai masu amfani da suka fi so su yi amfani da shi.
- Danna maballin "Fara" Windows located a cikin kusurwar hagu na allon. A cikin menu da ya buɗe, zaɓi abu "Shirye-shiryen Saɓo".
Idan a menu "Fara" ba ku sami wannan abu ba, sannan ku zaɓi matsayi "Hanyar sarrafawa".
A cikin taga wanda ya buɗe Ma'aikatan sarrafawa je zuwa sashe "Shirye-shirye".
A cikin taga mai zuwa, zaɓi sashe "Shirye-shiryen Saɓo".
- Bayan haka, an kaddamar da wannan taga, wanda zai buɗe idan muka danna kan abu "Shirye-shiryen Saɓo" kai tsaye a menu "Fara". Zaɓi matsayi "Daidaita iri iri ko ladabi ga wasu shirye-shirye".
- Ginin yana farawa "Daidaita iri iri ko ladabi ga wasu shirye-shirye". A cikin jerin dukkan kariyar fayilolin da aka rajista a cikin rijistar tsarin kwamfutarka na Windows, bincika sunan ".ods". Bayan ka samo shi, zaɓi wannan suna. Kusa, danna maballin "Canja shirin ..."wanda yake a gefen dama na taga, a saman jerin jerin kari.
- Bugu da ƙari, maɓallin zaɓi na aikace-aikace wanda ya saba. Anan kuma kuna buƙatar danna sunan "Microsoft Excel"sannan kuma danna maɓallin "Ok"kamar yadda muka yi a baya.
Amma a wasu lokuta, baza ka gano ba "Microsoft Excel" a cikin jerin aikace-aikacen da aka ba da shawarar. Wannan yana da mahimmanci idan kuna amfani da sababbin sifofin wannan shirin, wanda ba a ba da su ba don haɗawa da fayilolin ODS. Haka kuma zai iya faruwa saboda rashin lalacewar tsarin ko saboda gaskiyar cewa wani ya tilasta cire Excel daga jerin jerin shirye-shiryen da aka ba da shawarar don takardun tare da tsawo na ODS. A wannan yanayin, a cikin maɓallin zaɓi na zaɓi, danna maballin "Review ...".
- Bayan aikin karshe, an kaddamar da taga. "Bude tare da ...". Yana buɗewa a cikin matakan shirin wuri a kwamfuta ("Fayilolin Shirin"). Kuna buƙatar shiga jagorar fayil ɗin dake gudana Excel. Don yin wannan, matsa zuwa babban fayil da ake kira "Microsoft Office".
- Bayan haka, a cikin buƙatar budewa kana buƙatar zaɓar shugabanci wanda ya ƙunshi sunan "Ofishin" da kuma lambar sigar ofishin. Alal misali, don Excel 2010 zai zama sunan "Office14". A matsayinka na doka, kawai ɗayan ɗakin Microsoft yana shigar da kwamfutar. Saboda haka kawai zabi babban fayil wanda ya ƙunshi kalmar a cikin sunansa. "Ofishin"kuma latsa maballin "Bude".
- A cikin bayanin budewa muna neman fayil din tare da sunan "EXCEL.EXE". Idan ba a kunna kari a cikin Windows ba, ana iya kiran shi "EXCEL". Wannan shi ne fayil din ƙaddamar da wannan sunan. Zaɓi shi kuma danna maballin. "Bude".
- Bayan wannan, za mu koma cikin jerin zaɓin shirin. Idan ko da a baya cikin jerin aikace-aikace sunaye "Microsoft Excel" ba, yanzu zai bayyana. Zaɓi shi kuma danna maballin. "Ok".
- Bayan wannan, za a sabunta taga ƙungiyar fayil ɗin.
- Kamar yadda kake gani a cikin sakon ƙungiyar fayil ɗin, yanzu takardu tare da tsawo na ODS za a haɗa shi da Excel ta tsoho. Wato, idan ka danna gunkin wannan fayil tare da maɓallin linzamin hagu, za a bude ta atomatik a Excel. Muna buƙatar kammala aikin kawai a cikin ɓangaren ƙungiyar fayil ta danna kan maballin. "Kusa".
Hanyar 3: Buɗe tsarin ODS a cikin tsofaffin asali na Excel
Kuma yanzu, kamar yadda aka alkawarta, za mu yi la'akari da hanyoyi na bude tsarin ODS a cikin tsofaffin sassan Excel, musamman a Excel 2007, 2003.
A cikin Excel 2007, akwai zaɓuɓɓuka guda biyu don buɗe wani takardu tare da tsawo mai tsawo:
- ta hanyar shirin neman karamin aiki;
- ta danna kan icon.
Ainihin farko, a gaskiya, ba bambanta da irin wannan hanya na bude a Excel 2010 da kuma cikin wasu sigogin baya, wanda muka bayyana kadan kaɗan. Amma a karo na biyu zamu dakatar da ƙarin bayani.
- Jeka shafin Ƙara-kan. Zaɓi abu "Shigo da fayil ODF". Zaka kuma iya yin wannan hanya ta hanyar menu "Fayil"ta zabi wani wuri "Ana shigo da rubutu a cikin tsarin ODF".
- A yayin yin wani daga cikin waɗannan zaɓuɓɓukan, za a kaddamar da taga mai shigowa. A ciki ya kamata ka zaɓi abin da kake buƙata tare da tsawo na ODS, zaɓi shi kuma danna maballin "Bude". Bayan haka, za a kaddamar da takardun.
A cikin Excel 2003, duk abin ya fi rikitarwa, tun da wannan sifa ya fito a baya fiye da tsarin ODS. Saboda haka, don buɗe takardun tare da wannan tsawo, dole ne ka shigar da plugin Sun ODF. Ana shigar da shigarwa na musamman da aka yi kamar yadda aka saba.
Sauke Sun ODF Plugin
- Bayan shigar da sshe-in panel zai bayyana "Sun ODF Plugin". Za a sanya maɓallin a kan shi. "Shigo da fayil ODF". Danna kan shi. Nan gaba kana buƙatar danna sunan "Shigar da Fayil ...".
- Gilashin shigarwar farawa. Ana buƙatar zaɓar abin da ake buƙata kuma danna maballin. "Bude". Bayan haka za a kaddamar da shi.
Kamar yadda kake gani, buɗe gada a cikin tsarin ODS cikin sababbin sassan Excel (2010 da mafi girma) bazai haifar da matsala ba. Idan wani yana da matsala, to wannan darasi zai rinjaye su. Ko da yake, duk da sauƙi na kaddamarwa, ba koyaushe yana iya nuna wannan takarda a Excel ba tare da asarar ba. Amma a cikin tsararru na wannan shirin, buɗe abubuwa da ƙayyadadden ƙayyadadden yana haɗi da wasu matsalolin, ciki har da buƙatar shigar da inji na musamman.
