Bude Tables ODS a cikin Microsoft Excel

ODS sanannen salon yada bayanai ne. Zamu iya faɗi cewa wannan wani nau'i ne na mai yin gasa zuwa nau'in Excel xls da xlsx. Bugu da kari, ODS, sabanin takwarorinsu na sama, tsari ne na budewa, watau, ana iya amfani dashi kyauta kuma ba tare da ƙuntatawa ba. Koyaya, Hakanan yana faruwa cewa ana buƙatar buɗe takaddun tare da haɓaka ODS a cikin Excel. Bari mu bincika yadda ake yin wannan.

Hanyoyi don buɗe takardun ODS

OpenDocument Spreadsheet (ODS), wanda jama'ar OASIS suka kirkira, an nuna shi azaman analog na kyauta mai kyauta wanda ba a kirkiresu ba. Duniya ta gan shi a shekara ta 2006. A halin yanzu ODS yana daya daga cikin manyan sifofin da ake sarrafawa a teburin, hade da sanannun aikace-aikacen OpenOffice Calc. Amma tare da Excel, wannan tsari na "abokantaka" a zahiri bai yi aiki ba, tunda suna gasa ne na halitta. Idan Excel ya san yadda ake buɗe takardu a cikin tsarin ODS ta hanyar daidaitattun abubuwa, to Microsoft ta ƙi aiwatar da ikon adana abu tare da wannan fadada cikin kwakwalwar ta.

Akwai dalilai da yawa don buɗe tsarin ODS a cikin Excel. Misali, a kwamfutar da ake son gudanar da falle, wataƙila ba ku da aikace-aikacen OpenOffice Calc ko wata analog ba, amma za a shigar da kunshin Microsoft Office. Hakanan yana iya faruwa cewa ya kamata a yi aiki akan tebur tare da waɗancan kayan aikin da suke akwai a cikin Excel. Bugu da kari, wasu masu amfani daga cikin masu sarrafa tebur da yawa sun kware kwarewar yin aiki a matakin da ya dace kawai tare da Excel. Sannan tambayar bude takaddar a cikin wannan shirin ta zama mai dacewa.

Tsarin yana buɗewa cikin juyi na Excel, farawa daga Excel 2010, a sauƙaƙe. Tsarin ƙaddamarwa bai bambanta sosai da buɗe kowane takaddun falle a cikin wannan aikace-aikacen ba, gami da abubuwa tare da xls da xlsx. Kodayake akwai wasu abubuwa da yawa a ciki, zamuyi cikakken bayani akan su. Amma a farkon juzu'in wannan aikin tebur, tsarin buɗewa ya bambanta sosai. Wannan ya faru ne saboda gaskiyar cewa tsarin ODS ya bayyana ne kawai a cikin 2006. Masu haɓaka Microsoft sun aiwatar da ikon sarrafa irin wannan takaddar don Excel 2007 kusan lokaci guda tare da ci gaban da OASIS ta ci gaba. Don Excel 2003, ya kasance wajibi ne gaba ɗaya don fitar da wata hanyar haɗa ta dabam, tun da aka ƙirƙiri wannan sigar tun kafin ta sake tsarin ODS.

Koyaya, koda a cikin sababbin juzu'i na Excel, ba koyaushe ba zai yiwu a nuna ƙayyadadden maƙunsar daidai kuma ba tare da asara ba. Wasu lokuta, lokacin amfani da tsara, ba duk abubuwan da za'a iya shigo dasu ba kuma dole aikace-aikacen ya dawo da bayanai tare da asara. Idan akwai matsala, saƙon bayanin mai dacewa ya bayyana. Amma, a matsayinka na mai mulkin, wannan ba ya shafar amincin bayanan da ke cikin tebur.

Bari mu fara yin cikakken bayani game da buɗewar ODS a cikin nau'ikan Excel na yanzu, sannan a taƙaice mu bayyana yadda wannan hanya take faruwa a cikin tsofaffi.

Duba kuma: Analogs Excel

Hanyar 1: jefa ta cikin takaddar buɗe taga

Da farko dai, bari mu mayar da hankali kan fara ODS ta hanyar bude taga. Wannan hanya tana kama da hanya ta buɗe littattafai na xls ko xlsx ta wannan hanyar, amma tana da ƙarami ɗaya amma babban bambanci.

1. Kaddamar da Excel kuma je zuwa shafin Fayiloli.



2. A cikin taga da yake buɗe, a cikin menu a tsaye hagu, danna maɓallin "Bude".



3. Ana buɗe daidaitaccen taga don buɗe takaddara a cikin Excel. Ya kamata ya matsa zuwa babban fayil inda abin da ke cikin tsarin ODS da kake son buɗewa ya ke. Bayan haka, sauya yanayin fayil ɗin cikin wannan taga zuwa matsayi "Shafin shimfidar bude shafin OpenDocument (* .ods)". Bayan haka, abubuwa a cikin tsarin ODS za a nuna su a taga. Wannan shine bambanci daga farawar yau da kullun, wanda aka tattauna a sama. Bayan haka, zaɓi sunan takardar da muke buƙata kuma danna maɓallin "Bude" a kasan dama daga taga.



4. Za a buɗe kundin kuma a nuna shi a kan takardar aikin Excel.

Hanyar 2: danna sau biyu akan maɓallin linzamin kwamfuta

Kari akan haka, ingantacciyar hanyar da za'a bude fayil ita ce kaddamar da ita ta danna maɓallin linzamin kwamfuta na hagu sau biyu akan sunan. Ta wannan hanyar, zaka iya buɗe ODS a cikin Excel.

Idan ba'a shigar da OpenOffice Calc a kwamfutarka ba kuma baku wakilci wani shirin don buɗe tsarin ODS ba ta atomatik, to, gudanar da Excel ta wannan hanyar bazai zama matsala ba kwata-kwata. Fayil zai buɗe saboda Excel na gane shi azaman tebur. Amma idan an shigar da babban ofishin OpenOffice a PC, to, lokacin da ka danna sau biyu a cikin fayil ɗin, zai fara ne a cikin Calc, kuma ba a cikin Excel ba. Domin fara shi a cikin Excel, zaku aiwatar da wasu jan hankali.

1. Don kiran menu na mahallin, danna-kan madogaran alamar ODS takaddar da kake son buɗewa. A cikin jerin ayyuka, zaɓi Bude tare da. An ƙaddamar da ƙarin menu, wanda ya kamata a nuna sunan a cikin jerin shirye-shirye "Microsoft Excel". Mun danna shi.



2. An ƙaddamar da takaddun daftarin aiki a Excel

Amma hanyar da ke sama ya dace kawai don buɗewa lokaci-lokaci na abu. Idan kuna shirin kullun buɗe takardun ODS a cikin Excel, kuma ba a cikin wasu aikace-aikacen ba, to yana da ma'anar yin wannan aikace-aikacen shirin tsoho don aiki tare da fayiloli tare da ƙayyadadden lokaci. Bayan wannan, ba lallai ba ne a aiwatar da ƙarin magudin kowane lokaci don buɗe takaddar, amma zai isa a danna sau biyu tare da maɓallin linzamin kwamfuta na hagu akan abin da ake so tare da ODS.

1. Mun danna kan gunkin fayil tare da maɓallin linzamin kwamfuta na dama. Sake, zaɓi matsayi a cikin mahallin mahalli Bude tare da, amma wannan lokacin a cikin ƙarin jerin, danna kan abun "Zaɓi shiri ...".

   

   Haka kuma akwai wani madadin hanyar don zuwa taga zaɓi na shirin. Don yin wannan, sake, danna-dama akan gunkin, amma wannan lokacin zaɓi abu a cikin mahallin mahallin "Bayanai".

   

   A cikin taga Properties da aka ƙaddamar, kasancewa a cikin shafin "Janar"danna maballin "Canza ..."located gaban da siga "Aikace-aikacen".



2. A zaɓuɓɓuka na farko da na biyu, za a ƙaddamar da taga zaɓi na shirin. A toshe Shirye-shiryen da aka ba da shawarar sunan ya kamata ya kasance "Microsoft Excel". Zaba shi. Tabbatar tabbatar da cewa siga "Yi amfani da shirin da aka zaɓa don duk fayilolin wannan nau'in" akwai alamar rajista. Idan ya ɓace, to shigar da shi. Bayan aiwatar da matakan da ke sama, danna kan maɓallin "Ok".



3. Yanzu bayyanar gumakan ODS zasu canza kadan. Zai kara alamar Excel. Canji mafi mahimmancin aiki zai faru. Ta danna maɓallin linzamin kwamfuta na hagu sau biyu akan kowane ɗayan waɗannan gumakan, za a gabatar da takaddar ta atomatik a cikin Excel, kuma ba cikin OpenOffice Calc ko a cikin wani aikace-aikacen ba.

Akwai wani zaɓi don saita Excel azaman aikace-aikacen tsoho don buɗe abubuwa tare da fadada ODS. Wannan zabin ya fi rikitarwa, amma, duk da haka, akwai masu amfani waɗanda suka fi son amfani da shi.

1. Latsa maballin Fara Windows dake cikin ƙananan hagu na allo. A menu na buɗe, zaɓi "Shirye-shiryen tsoho".

   

   Idan menu Fara Idan baku samo wannan abun ba, sai ku zaɓi abin "Kwamitin Kulawa".

   

   A cikin taga yana buɗewa Gudanarwa bangarori je zuwa bangare "Shirye-shirye".

   

   A taga na gaba, za thei sashin hoofin "Shirye-shiryen tsoho".



2. Bayan wannan, an fara wannan taga, wanda zai buɗe idan muka danna abu "Shirye-shiryen tsoho" kai tsaye zuwa menu Fara. Zabi wani matsayi "Ppingauraran nau'ikan fayil ɗin ko ladabi ga takamaiman shirye-shiryen".
3. Window yana farawa "Ppingauraran nau'ikan fayil ɗin ko ladabi ga takamaiman shirye-shiryen". A cikin jerin duk jerin fadada fayil ɗin da aka yi rajista a cikin tsarin rajista na Windows ɗinku, muna neman suna ".ods". Bayan kun samo shi, zaɓi wannan sunan. Nan gaba danna maballin "Canza shirin ...", wanda ke gefen dama na taga, sama da jerin abubuwan kari.



4. Hakanan, taga zaɓi na aikace-aikacen da aka saba da shi yana buɗewa. Anan kuma kuna buƙatar danna kan sunan "Microsoft Excel"sannan kuma danna maballin "Ok"kamar yadda muka yi a sigar da ta gabata.

   

   Amma a wasu halaye, wataƙila ba ku samu ba "Microsoft Excel" a cikin jerin aikace-aikacen da aka ba da shawarar. Wannan yana iya yiwuwa musamman idan kuna amfani da tsoffin sigogin wannan shirin waɗanda ba a haɗa ku da fayilolin ODS ba. Hakanan zai iya faruwa saboda fashewar tsarin ko kuma saboda wani ya tilasta Excel daga jerin shirye-shiryen da aka bada shawara don takaddun tare da ODS na haɓaka. A wannan yanayin, danna maballin a cikin taga zaɓi na aikace-aikace "Yi bita ...".



5. Bayan aiki na ƙarshe, taga yana farawa "Bude tare da ...". Yana buɗewa cikin babban fayil inda ake gabatar da shirye-shiryen a kwamfutar ("Fayilolin shirin") Kuna buƙatar zuwa ga directory inda fayil ɗin ke gudana Excel. Don yin wannan, matsa zuwa babban fayil da ake kira "Ofishin Microsoft".



6. Bayan haka, a cikin kundin da ke buɗe, kuna buƙatar zaɓar shugabanci wanda ya ƙunshi sunan "Ofishin" da lambar lamba ta ofishin. Misali, don Excel 2010 - wannan zai zama sunan "Office14". Yawanci, office ɗaya ne kawai daga Microsoft aka shigar a kan kwamfuta. Saboda haka, kawai zaɓi babban fayil ɗin da ke ɗauke da kalmar "Ofishin", kuma danna maballin "Bude".



7. A cikin jagorar da ke buɗe, nemi fayil tare da suna "EXCEL.EXE". Idan ba a kunna alamun kari a kan Windows din ku ba, to ana iya kiransa FASAHA. Wannan fayil ɗin ƙaddamar da aikace-aikace iri ɗaya ne. Zaɓi shi kuma danna maballin. "Bude".



8. Bayan haka, za mu koma taga zaɓi na shirin. Idan ma a baya cikin jerin sunayen sunaye "Microsoft Excel" ba, to yanzu zai bayyana. Zaɓi shi kuma danna maballin. "Ok".



9. Bayan haka, za a sabunta taga nau'in taswirar fayil ɗin fayil.



10. Kamar yadda kake gani a cikin taga nau'in fayil ɗin da ya dace, yanzu takardu tare da fadada ODS za a danganta su da Excel ta tsohuwa. Wato, lokacin da ka danna maballin wannan file sau biyu tare da maɓallin linzamin kwamfuta na hagu, zai buɗe ta atomatik a cikin Excel. Muna buƙatar kawai kammala aikin a cikin taga kwatanta fayil ɗin ta danna maɓallin Rufe.

Hanyar 3: bude tsarin ODS a tsoffin juzu'i na Excel

Yanzu kuma, kamar yadda aka alkawarta, zamu danyi bayani kan takaitaccen bayani kan bude tsarin ODS a tsoffin juzu'i na Excel, musamman a Excel 2007, 2003.

A cikin Excel 2007, akwai zaɓuɓɓuka guda biyu don buɗe takaddun tare da tsayayyen da aka ƙaddara:

• ta hanyar dubawar shirin;
• ta danna alamar sa.

Zaɓin farko, a zahiri, bai bambanta da irin hanyar buɗe makamancin wannan ba a cikin Excel 2010 da a juzurorin da suka gabata, waɗanda muka bayyana kaɗan. Amma akan zaɓi na biyu munyi cikakken bayani dalla-dalla.

1. Je zuwa shafin "Karin abubuwa". Zaɓi abu "Shigo da fayil na ODF". Hakanan zaka iya yin wannan hanya ta menu Fayilolita zabi wani matsayi "A shigo da falle a tsarin ODF".
2. Lokacin da ɗayan waɗannan zaɓuɓɓun ke aiwatarwa, taga shigowa yana farawa. A ciki ya kamata ka zaɓi abun da kake buƙata tare da haɓaka ODS, zaɓi shi kuma danna maballin "Bude". Bayan haka, za a ƙaddamar da daftarin aiki.

A cikin Excel 2003, komai yafi rikitarwa, tunda an fito da wannan sigar kafin a samar da tsarin ODS. Sabili da haka, don buɗe takaddun tare da wannan fadada, wajibi ne don shigar da kayan aikin Sun ODF. Shigarwa da aka ƙayyade shi aka kera kamar yadda aka saba.

Zazzage Sun ODF Plugin

1. Bayan shigar da plugin ɗin, wani kwamiti ya kira "Sun ODF Plugin". Za a sanya maballin a bisan sa "Shigo da fayil na ODF". Danna shi. Bayan haka, danna kan sunan "Shigo fayil ...".
2. Wurin shigowa yana farawa. Ana buƙatar zaɓar daftarin da ake so kuma danna maballin "Bude". Bayan haka za a ƙaddamar da shi.

Kamar yadda kake gani, buɗe teburin tsarin ODS a cikin sababbin juzu'in Excel (2010 da sama) bai kamata ya haifar da matsaloli ba. Idan kowa yana da matsaloli, to wannan darasin zai shawo kansu. Kodayake, duk da sauƙin ƙaddamarwa, yana da nisa daga koyaushe yiwu a nuna wannan takaddar a cikin Excel ba tare da asara ba. Amma a cikin tsoffin juzu'i na shirin, buɗe abubuwa tare da ƙayyadaddun fadada ya cika tare da wasu matsaloli, har zuwa buƙatar shigar da toshe ta musamman.