Ungavula kanjani ifayela le-ODS ku-Excel: 3 Izindlela Zokusebenza

Anonim

Ukuvula Ods ku-Microsoft Excel

I-Ods yifomethi yespredishithi edumile. Kungashiwo ukuthi lolu uhlobo lokuncintisana kuma-XLS we-XLS kanye namafomethi we-XLSX. Ngaphezu kwalokho, ods, ngokungafani nalezi alolog ezingenhla, ifomethi evulekile, okungukuthi, ingasetshenziselwa mahhala futhi ngaphandle kwemikhawulo. Noma kunjalo, kuyenzeka futhi ukuthi idokhumenti ngokunwetshwa kwe-ODS kudinga ukutholwa ku-Excel. Ake sibheke ukuthi kungenziwa kanjani.

Izindlela zokuvula amadokhumenti wefomethi ye-ODS

I-OpendoCument Spreadsheet (Ods) ethuthukiswe ngumphakathi we-Oasis, ngokudala kwayo, bekuhloselwe njenge-analogue yamahhala nekhululekile yamafomethi we-Excel. Wambona ngo-2006. Njengamanje, u-Ods kungenye yamafomethi aphambili we-processor ye-tabular, kufaka phakathi uhlelo lokusebenza lwamahhala lwe-OpenOffice lwe-OpenOffice. Kepha nge-Excel, le fomethi "ubungani" ayikwazanga ukuba yimvelo, njengoba bencintisana nezemvelo. Uma ungavula amadokhumenti ngefomethi ye-Ods Excel ngezindlela ezijwayelekile, amathuba okugcina into enesandiso se-Microsoft senqabile ukusebenzisa engqondweni yakhe.

Izizathu zokuvula ifomethi ye-ODS ku-Excel. Isibonelo, kwikhompyutha lapho udinga khona ukusebenzisa ispredishithi, kumane kungenzeka kube yi-OpenOffice Calc application noma enye i-analog, kepha iphakethe le-Microsoft Office lizofakwa. Kungenzeka futhi ukuthi ithebula kufanele lenziwe ngamathuluzi atholakala kuphela ku-Excel. Ngaphezu kwalokho, abanye abasebenzisi phakathi kweqoqo lemisebenzi yethebula lathatha amakhono okusebenza ezingeni elifanele kuphela nge-Excel. Ngemuva kwalokho iba efanelekile ekuvuleni kwedokhumenti kulolu hlelo.

Ifomethi evulelwe ezinguqulweni ze-Excel, ukuqala nge-Excel 2010, elula impela. Inqubo yokuqalisa ayihlukile kakhulu ekuvuleni kwanoma iyiphi enye incwadi ye-tabular kulolu hlelo lokusebenza, kufaka phakathi izinto ezinokwanda kwama-xls ne-xlsx. Yize kukhona ama-nuances lapha, lapho sizogxila khona ngokuningiliziwe ngezansi. Kepha ezinguqulweni zangaphambilini zalolu hlelo le-tabular, inqubo yokutholwa ihlukile kakhulu. Lokhu kungenxa yokuthi ifomethi ye-ODS yavela ngo-2006 kuphela. Abathuthukisi beMicrosoft amandla okuqala lolu hlobo lwemibhalo ye-Excel 2007 kwadingeka ukuthi isetshenziswe cishe ngokuhambisana nokuthuthuka kwayo komphakathi we-oasis. Ukuze uthole u-Excel 2003, kwadingeka ngikhiqize ngokujwayelekile nge-plug-ngokuvamile, ngoba le nguqulo yadalwa isikhathi eside ngaphambi kokukhishwa kwefomethi ye-ODS.

Kodwa-ke, ngisho nasezinguqulweni ezintsha, i-Excel ayihlali ikwazi ukubonisa amaspredishithi akhonjisiwe ngendlela efanele futhi ngaphandle kokulahleka. Kwesinye isikhathi, lapho usebenzisa ukufomatha, akuzona zonke izinto ezingangeniswa futhi uhlelo lokusebenza kufanele lubuyisele idatha ngokulahleka. Uma kwenzeka kuba nezinkinga, umyalezo wolwazi ohambelana naye uyavela. Kepha, njengomthetho, akukuthinti ubuqotho bedatha etafuleni.

Umlayezo Wokubuyiselwa Kwe-ODS ku-Microsoft Excel

Ake sigxile kuqala ngokuningiliziwe lapho kuvulwa ama-Ods ezinhlotsheni zezinqolobane ze-Excel, bese sichaza kafushane ukuthi le nqubo yenzeka kanjani asebekhulile.

Idokhumenti ye-ODS ivuliwe eMicrosoft Excel

Indlela 2: Ukuqalisa kabili inkinobho yokuchofoza kabili

Ngaphezu kwalokho, inketho ejwayelekile yokuvula ifayela ukwethulwa kwayo kwenkinobho yegundane kwesobunxele egameni. Ngendlela efanayo, ungavula ama-Ods ukuze uphumelele.

Uma ikhompyutha ingafakwanga kukhompyutha, i-OpenOffice Calc application ifakiwe futhi awuzange uphinde uphinde uphinde uphinde uqinise ohlelweni olungavuli ifomethi ezenzakalelayo, khona-ke nokwethulwa ngale ndlela ku-Excel ngeke kube khona izinkinga. Ifayela lizovuleka, njengoba i-Excel ibona njengetafula. Kepha uma iphakethe le-OpenOffice lifakiwe kwi-PC, lapho-ke lapho uchofoza kabili inkinobho yegundane kufayela, lizoqala kwi-calc, hhayi le-Excel. Ukuze uqale ukugijima ku-Excel, kuzofanele uchithe amanye amakhono.

  1. Ukushayela imenyu yomongo ngokuchofoza inkinobho yegundane kwesokudla kwisithonjana sedokhumenti ye-ODS ofuna ukuvula. Uhlu lwesenzo, khetha "Vula usebenzisa" into ". Imenyu eyengeziwe yethulwa lapho igama elithi "Microsoft Excel" kumele lichazwe kuhlu lwezinhlelo. Chofoza kuyo.
  2. Ukuvula idokhumenti le-ODS usebenzisa i-Microsoft Excel

  3. Idokhumenti ekhethiwe ku-Efpelle yethulwa.

Kepha indlela echazwe ngenhla ilungele ukuvulwa kwento eyodwa kuphela. Uma uhlela ukuvula njalo amadokhumenti we-ODS ukugqama, hhayi kwezinye izinhlelo zokusebenza, okungukuthi, kunengqondo ukwenza lolu hlelo lokusebenza oluzenzakalelayo lusebenze namafayela ngesandiso esibekiwe. Ngemuva kwalokho, ngeke kudingeke ukuvula okwengeziwe kokuvula idokhumenti, futhi kuzokwanela ukuchofoza kabili inkinobho yegundane kwesobunxele entweni oyifunayo nge-ODS Experied.

  1. Chofoza kusithonjana sefayela ngenkinobho yegundane efanele. Futhi kumenyu yokuqukethwe, khetha isikhundla esithi "Open USAT", kepha kulokhu ohlwini ongakukhetha Chofoza ku- "Khetha uhlelo ...".

    Iya ekukhetheni kohlelo ukuvula ifayela le-ODS

    Kukhona nenketho yokuguqula enye iwindi lokukhetha kohlelo. Ukuze wenze lokhu, futhi udinga ukubeka inkinobho yegundane efanele kwisithonjana, kepha kulokhu kumenyu yokuqukethwe Khetha into "Izakhiwo".

    Iya kuwindi le-ODS File Properties

    Ezakhiweni ezigijima, ngenkathi kuthebhu Okujwayelekile, chofoza inkinobho ethi "Change ...", etholakala maqondana nepharamitha ye- "appendix".

  2. Iwindi le-ODS File Properties

  3. Ekuqaleni kokuqala nokwesibili, iwindi lokukhetha uhlelo luzoqala. "Izinhlelo ezinconyiwe" block kufanele zitholakale igama elithi "Microsoft Excel". Siyakugqama. Qiniseka ukuthi uqinisekisa ukuthi ipharamitha "Sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" kwakuwuphawu lokuhlola. Uma ilahlekile, kufanele uyifake. Ngemuva kokwenza okungenhla, kufanele uchofoze inkinobho ethi "KULUNGILE".
  4. Iwindi lokukhetha isoftware

  5. Manje ukubukeka kwezithonjana ze-ODS zizoshintsha ngandlela thile. Izongezwa ku-logo ye-Excel. Kuzokwenzeka ushintsho olubaluleke ngokwengeziwe. Uma uchofoza kabili inkinobho yesokunxele ukuthola noma yiziphi zalezi zimpawu, idokhumenti izoqalwa ngokuzenzakalelayo ku-Excel, hhayi ku-OpenOffice Calc noma kolunye uhlelo lokusebenza.

Ukugijima idokhumenti le-ODS ku-Microsoft Excel Qhafaza kabili inkinobho yegundane kwesokunxele

Kukhona enye inketho yokwabela uhlelo lokusebenza oluzenzakalelayo lwe-Excel ukuvula izinto ngokunwetshwa kwe-ODS. Le nketho iyinkimbinkimbi ngokwengeziwe, kepha, noma kunjalo, kukhona abasebenzisi abathanda ukuyijabulela.

  1. Chofoza inkinobho ethi "Qala" etholakala ekhoneni elingezansi kwesobunxele kwesikrini. Kumenyu evula, khetha into ezenzakalelayo yohlelo.

    Shintshela esigabeni sokufaka uhlelo esizenzakalelayo ku-Windows

    Uma ungatholi le nto kwimenyu yokuqala, khetha isikhundla esithi "Ukulawula Iphaneli".

    Shintshela ku-Windows Control Panel

    Efasiteleni lephaneli lokulawula elivula, liye esigabeni "sezinhlelo".

    Shintshela kuhlelo lokulawula iphaneli

    Ewindi elilandelayo, khetha isigatshana sohlelo esizenzakalelayo.

  2. Iya kwisigatshana sohlelo esizenzakalelayo kuphaneli yokulawula

  3. Ngemuva kwalokho, iwindi elifanayo liqala iwindi elifanayo elizovula uma sichofoze entweni yohlelo oluzenzakalelayo ngqo kumenyu ethi "Qala". Khetha "ukumephu kwezinhlobo zefayela noma amaphrothokholi ezinhlelweni ezithile".
  4. Shintshela ezinhlotsheni zefayela noma amaphrothokholi ezinhlelweni ezithile.

  5. I- "Imephu yezinhlobo zefayela noma amaphrothokholi ezinhlelweni ezithile" iwindi liqala. Kulolu hlu lwezandiso zefayela ezibhaliswe kwirejista yesistimu ye-Windows yesimo sakho, ubheke igama elithi ".Ads". Ngemuva kokukuthola, sabela leli gama. Okulandelayo, chofoza inkinobho ethi "Shintsha uhlelo ...", olutholakala ngakwesokunene sewindi, kusuka phezulu ohlwini lwezandiso.
  6. Ifayela noma i-Protocol Thayipha Iwindi lemephu ezinhlelweni ezithile

  7. Kuphinde kuvule iwindi elijwayelekile ukuze ukhethe uhlelo. Kudinga futhi ukuze uchofoze igama elithi "Microsoft Excel", bese uqhafaza inkinobho ethi "KULUNGILE", njengoba senza kuhlobo lwangaphambilini.

    Khetha i-Microsoft Excel ewindini lokukhetha uhlelo

    Kepha kwezinye izikhathi, awungeke ubone "iMicrosoft Excel" ohlwini lwezinhlelo ezinconyiwe. Lokhu kungenzeka ikakhulukazi uma usebenzisa izinguqulo ezindala zalolu hlelo, ezingakaze zinikeze inhlangano namafayela we-ODS. Kungenzeka futhi ngenxa yokwehluleka ohlelweni noma ngenxa yokuthi othile ukhishwe ngenkani i-Excel ephumelele kusuka ohlwini lwemibhalo enconyiwe yamadokhumenti anezincwadi ezinokwandiswa kwe-ODS. Kulokhu, ewindini lokukhetha kohlelo lokusebenza, chofoza inkinobho ethi "Overview ...".

  8. Iya ekubuyekezweni kohlelo ewindini lokukhetha uhlelo

  9. Ngemuva kokuqeda isenzo sokugcina, "ukuvula nge ..." i-Window. Kuvulwa kufolda yendawo yohlelo kwikhompyutha ("Amafayela Ohlelo"). Udinga ukuya kwisikhombi sendawo yefayela eliqhuba i-Excel. Ukuze wenze lokhu, hambisa kufolda ebizwa nge- "Microsoft Office".
  10. Iya kufolda ye-Microsoft Office

  11. Ngemuva kwalokho, ku-Directory evulekile udinga ukukhetha umkhombandlela oqukethe igama elithi "Ihhovisi" nenombolo yenguqulo yephakethe lehhovisi. Isibonelo, nge-Excel 2010 - lokhu kuzoba igama elithi "Ihhovisi14". Njengomthetho, yiphakethe elilodwa lehhovisi elivela ku-Microsoft elifakiwe kwikhompyutha. Ngakho-ke, mane ukhethe ifolda equkethe igama elithi "Ihhovisi" esihlokweni sakho, bese uqhafaza inkinobho ethi "Open Open".
  12. Iya kufolda ye-Office14

  13. In the Directory evulekile, ufuna ifayela ngegama elithi "Excel.exe". Uma kungekho mbukiso owengeziwe emafasiteleni akho, kungabizwa ngokuthi "Excel". Leli yifayela lokuqalisa lokusetshenziswa kwegama elifanayo. Siyigqabisisa bese uchofoza inkinobho ethi "Open".
  14. Ifayela lokuqalisa le-Excel

  15. Ngemuva kwalokho, sibuyela efasiteleni lokukhetha uhlelo. Ngisho ngaphambili, phakathi kohlu lohlu lweMicrosoft Excel Vales, bekungenjalo, manje kuzovela nakanjani. Sikugqamisa kanye nobumba enkombeni ethi "KULUNGILE".
  16. Khetha uhlelo ukushintsha ngokuzenzakalelayo

  17. Ngemuva kwalokho, izinhlobo zefayela le-Map Mapmep Window zizovuselelwa.
  18. Vuselela izinhlobo zefayela noma amaphrothokholi ezinhlelweni ezithile

  19. Njengoba ukwazi ukubona kufasitela lemephu yefayela lefayela, manje amadokhumenti anokunwetshwa kwe-ODS okuzenzakalelayo azohlotshaniswa ne-Excel. Lokho wukuthi, lapho uchofoza kabili kwisithonjana saleli fayela ngenkinobho yegundane kwesobunxele, izovulwa ngokuzenzakalelayo ku-Excel. Kumele nje siqedele umsebenzi ewindini lemephu yohlobo lwefayela ngokuchofoza inkinobho ethi Vala.

Ukuvala izinhlobo zefayela noma amaphrothokholi ezinhlelweni ezithile

Indlela 3: Ukuvula ifomethi ye-ODS kuzinguqulo ezindala ze-Excel

Futhi manje, njengoba kuthenjisiwe, kugxile kafushane ama-nuances wokuvulwa kwefomethi ye-ODS kuzinguqulo ezindala ze-Excel, ikakhulukazi ku-Excel 2007, 2003.

Ku-Excel 2007 izinketho ezimbili zokuvula idokhumenti ngesandiso esibekiwe:

  • Nge-interface yohlelo;
  • Ngokuchofoza kusithonjana sayo.

Inketho yokuqala, eqinisweni, awehlukile ngendlela efanayo yokuvula ngokuhamba nge-Excel 2010 nangezinguqulo zakamuva esichaze ngaphezulu. Kepha engxenyeni yesibili izohlala imininingwane eminingi.

  1. Iya kuthebhu ethi "Faka-in". Khetha "Ifayela Ngenisa kufayela le-ODF". Ungenza futhi inqubo efanayo ngemenyu ethi "Ifayela" ngokukhetha i- "E-Table Ukungenisa ngefomethi ye-ODF".
  2. Lapho wenza noma yiziphi zalezi zinketho, kuthulwe iwindi lokungenisa. Kufanele ukhethe into oyidingayo ngesandiso se-ODS, ukhethe bese uqhafaza inkinobho ethi "Open". Ngemuva kwalokho, lo mbhalo uzokwethulwa.

Ku-Excel 2003, yonke into iyinkimbinkimbi kakhulu, njengoba le nguqulo iphuma ngaphambili kunefomethi ye-ODS yathuthukiswa. Ngoba amadokhumenti analokhu kwandiswa kuyadingeka ukufaka i-Sun Odf plugin. Ukufakwa kwe-plugin ebekiwe kwenziwa kwimodi ejwayelekile.

Landa i-Sun Odf plugin

  1. Ngemuva kokufaka i-plugin, iphaneli ebizwa nge- "Sun Odf plugin" izovela. Izoqukatha "ifayela lokungenisa ngefomethi yefomethi yefomethi". Chofoza kuyo. Okulandelayo, udinga chofoza igama elithi "Ngenisa Ifayela ...".
  2. Ngenisa iwindi liqala. Udinga ukugqamisa idokhumenti oyifunayo bese uqhafaza inkinobho ethi "Open". Ngemuva kwalokho, kuzokwethulwa.

Funda futhi: Holela ukuthi avule kanjani ifomethi ye-ODS

Njengoba ukwazi ukubona, ukuvulwa kwamatafula wefomethi ye-ODS kunguqulo entsha ye-Excel (2010 nangaphezulu) akufanele kubangele ubunzima. Uma umuntu enezinkinga, lesi sifundo sizobavumela ukuba bazinqobe. Noma, naphezu kokulula kokwethulwa, akuhlali njalo ukubonisa lo mbhalo ngaphandle kokulahleka kwe-Excel. Kepha ezinguqulweni eziphelelwe yisikhathi, ukuvulwa kwezinto ezinokwandiswa okucacisiwe kuhlotshaniswa nobunzima obuthile, kuze kufinyelele kwisidingo sokufaka i-plug-in ekhethekile.

Funda kabanzi