Isofthiwe yokufunda ibhakhodi

I-ODS ifomethi yespredishithi ethandwayo. Singasho ukuthi lokhu kuyindlela yokuphikisana namafomethi we-Excel xls no-xlsx. Ngaphezu kwalokho, i-ODS, ngokungafani nemifanekiso engenhla, ifomethi evulekile, okungukuthi, ingasetshenziswa mahhala futhi ngaphandle kwemingcele. Kodwa-ke, kwenzeka nokuthi idokhumenti ene-ODS isandiso idinga ukuvulwa ku-Excel. Ake sithole ukuthi lokhu kungenziwa kanjani.

Izindlela zokuvula amadokhumenti kufomethi ye-ODS

I-OpenDocument Spreadsheet (ODS), eyakhiwe ngumphakathi we-OASIS, yayihloselwe ukudalwa njenge-analogue yamahhala namahhala yamafomethi e-Excel. Izwe lambona ngo-2006. Njengamanje, i-ODS ingenye yefomethi eziyinhloko zamaphrosesa we-tabular, kuhlanganise nesicelo samahhala se-OpenOffice Calc. Kodwa nge-Excel kule fomathi, "ubungane" ngokwemvelo akusebenzi, ngoba bangabancintisana bemvelo. Uma ungakwazi ukuvula amadokhumenti efomethi ye-ODS Excel ngamathuluzi ajwayelekile, iMicrosoft inqabe ukwethula ithuba lokulondoloza into enokwandiswa okunjalo ekudalweni kwayo.

Kunezizathu eziningi zokuvula ifomu le-ODS ku-Excel. Isibonelo, kwikhompyutha lapho ufuna ukusetha ispredishithi, kungenzeka ukuthi ungenayo uhlelo lokusebenza lwe-OpenOffice Calc noma olunye olulinganayo, kodwa i-Microsoft Office izofakwa. Kungenzeka futhi ukuthi ukuhlinzwa kufanele kwenziwe etafuleni nalawo mathuluzi atholakalayo kuphela ku-Excel. Ngaphezu kwalokho, abanye abasebenzisi phakathi kwabaningi abacubungula i-tabular bazi kahle amakhono okusebenza ezingeni elifanele kuphela nge-Excel. Yilapho inkinga yokuvula idokhumenti kulolu hlelo iba efanele.

Ifomethi evuliwe ku-Excel izinguqulo, ngokuqala nge-Excel 2010, ilula kakhulu. Inqubo yokuqalisa ayifani kakhulu nokuvula noma iyiphi enye idokhumenti yedatha kulolu hlelo lokusebenza, kufaka phakathi izinto ezinezandiso ze-xls ne-xlsx. Nakuba kunezinto ezincane ezikhona lapha, esizoxoxa ngazo ngokuningiliziwe ngezansi. Kodwa kwezinye izinguqulo zangaphambili zalolu hlelo lokusebenza lwetafula, inqubo yokuvula ihluke kakhulu. Lokhu kungenxa yokuthi ifomethi ye-ODS ivele ngo-2006 kuphela. Abathuthukisi beMicrosoft kwadingeka baqalise ikhono lokuqalisa lolu hlobo lwemibhalo ye-Excel 2007 cishe ngokuhambisana nokuthuthukiswa kwalo ngumphakathi we-OASIS. Ku-Excel 2003, kwakudingeka ngikhulule i-plug-in ehlukile, ngoba le nguqulo yadalwa isikhathi eside ngaphambi kokukhishwa kwefomethi ye-ODS.

Kodwa-ke, ngisho nezinguqulo ezintsha ze-Excel, akunakwenzeka njalo ukubonisa lezi amaspredishithi ngendlela efanele futhi ngaphandle kokulahlekelwa. Ngezinye izikhathi, uma usebenzisa ukufometha, akuzona zonke izakhi ezingangeniswa futhi isicelo kufanele sithole idatha ngokulahlekelwa. Uma kwenzeka izinkinga, umyalezo ohambelana nokwaziswa uvela. Kodwa, njengomthetho, lokhu akuthinti ubuqotho bemininingwane etafuleni.

Ake siqale ngokucacisa ngokuvula i-ODs ezinkambisweni zamanje ze-Excel, bese uchaza kafushane ukuthi le nqubo ivela kanjani kulabo asebekhulile.

Bheka futhi: Excel Excel

Indlela 1: ugijimele amadokhumenti avuliwe

Okokuqala, asiyeke ukuqala i-ODS ngefasitela lokuvula idokhumenti. Le nqubo ifana kakhulu nenqubo yezincwadi zokuvula ze-xls noma i-xlsx ifomethi ngendlela efanayo, kodwa inehlukile eyodwa encane kodwa ephawulekayo.

  1. Run Excel bese uya kuthebhu "Ifayela".
  2. Ewindini evulekile ngakwesokunxele chofoza imenyu ku-inkinobho "Vula".
  3. Iwindi elijwayelekile livula ukuvula idokhumenti ku-Excel. Kumele ifinyelele kufolda lapho into ekhona kwifomethi ye-OD ofuna ukuyivula. Okulandelayo, udinga ukuhlela kabusha ushintsho lwefayili kule window ukuya endaweni "I-OpenDocument Spreadsheet (* .ods)". Emva kwalokho, ifasiteleni izobonisa izinto kufomethi ye-ODS. Lona umehluko kusukela ekuqalisweni okujwayelekile, okukhulunywe ngakho ngenhla. Emva kwalokho, khetha igama lwedokhumenti esiyidingayo bese uchofoza inkinobho "Vula" ngezansi kwesokudla kwewindi.
  4. Idokhumenti izovulwa futhi iboniswe kwi-Excel sheet.

Indlela 2: chofoza kabili inkinobho yegundane

Ngaphezu kwalokho, inguqulo evamile yokuvula ifayela ukuyiqalisa ngokuchofoza kabili inkinobho yegundane lesokunxele egameni. Ngendlela efanayo, ungavula i-ODS ku-Excel.

Uma ikhompyutha ingenayo uhlelo lokusebenza lwe-OpenOffice Calc efakwe futhi ungadlulisi ukuvula ifomethi ye-ODS ehlukile kwenye uhlelo, ke ukuyisebenzisa ngale ndlela ku-Excel ngeke kube nezinkinga nhlobo. Ifayela izovuleka, njengoba i-Excel iyayibona njengetafula. Kodwa uma ihhovisi le-OpenOffice lifakwe ku-PC, uma uchofoza kabili efayeleni, izoqala ku-Calc, hhayi i-Excel. Ukuze uyiqalise ku-Excel, kuzodingeka wenze ezinye izinyathelo.

  1. Ukuze ushayele imenyu yokuqukethwe, chofoza ngakwesokudla kwisithonjana seDokhumenti ye-ODS okudingeka ivuliwe. Kuhlu lwezinyathelo, khetha into "Vula nge". Imenyu eyengeziwe iqalisiwe, lapho igama kufanele likhonjiswe kuhlu lohlelo. "I-Microsoft Excel". Chofoza kuso.
  2. Ukwethulwa kwedokhumenti ekhethiwe ku-Excel.

Kodwa indlela engenhla ifanele kuphela ukuvula okulodwa kwento. Uma uhlela ukuvula amadokhumenti e-ODS evuliwe njalo ku-Excel, hhayi kwezinye izinhlelo zokusebenza, ngakho-ke kunengqondo ukwenza lolu hlelo lube uhlelo oluzenzakalelayo lokusebenza ngamafayela nesandiso esicacisiwe. Ngemuva kwalokho, ngeke kudingekile ukwenza izinyathelo ezengeziwe isikhathi ngasinye sokuvula idokhumenti, futhi kwanele ukuchofoza kabili into efunwayo nge-extension ye-ODS.

  1. Chofoza kusithonjana sefayela ne inkinobho yesinxele yesokudla. Futhi, kwimenyu yokuqukethwe, khetha isikhundla "Vula nge"kodwa ngalesi sikhathi ohlwini olwengeziwe chofoza entweni "Khetha uhlelo ...".

    Kukhona futhi okunye okukhethwa kukho ukuya efasiteleni lokukhetha uhlelo. Ukwenza lokhu, godu, uchofoze ngakwesokudla esithombeni, kodwa manje kule imenyu yemenyu khetha into "Izakhiwo".

    Kuwindiza yezakhiwo eziqalayo, ekubeni kuthebhu "Jikelele", chofoza inkinobho "Shintsha ..."okuyinto ephikisana nepharamitha "Isicelo".

  2. Ekukhetheni kokuqala nesesibili, iwindi lokukhetha uhlelo luzoqala. Ku-block "Izinhlelo eziphakanyisiwe" igama kufanele libe khona "I-Microsoft Excel". Khetha it. Qiniseka ukuqinisekisa ukuthi ipharamitha "Sebenzisa uhlelo olukhethiwe kuwo wonke amafayela alolu hlobo" kwakukhona uphawu. Uma ingekho, kufanele uyifake. Ngemva kokwenza izinyathelo ezingenhla, chofoza inkinobho. "Kulungile".
  3. Manje ukubonakala kwezimpawu ze-ODS kuzoshintsha kancane. Izokwengeza i-Excel logo. Kuzoba nokubaluleka kokusebenza okubaluleke nakakhulu. Uma uchofoza kabili inkinobho yegundane lesokunxele kunoma iyiphi yalezi zithombe, idokhumenti izomiswa ngokuzenzakalelayo ku-Excel, hhayi ku-OpenOffice Calc noma kwenye uhlelo lokusebenza.

Kukhona enye indlela yokukhetha i-Excel njengendlela yokuzenzakalela yokuvula izinto nge-extension ye-ODS. Lolu khetho luyinkimbinkimbi, kodwa, noma kunjalo, kukhona abasebenzisi abakhetha ukuyisebenzisa.

  1. Chofoza inkinobho "Qala" I-Windows itholakala ekhoneni elingezansi elingakwesokunxele kwesikrini. Emenyu evula, khetha into "Izinhlelo ezizenzakalelayo".

    Uma kumenyu "Qala" awuyitholi le nto, bese ukhetha isikhundla "Iphaneli Yokulawula".

    Ewindini evula Lawula amaphaneli iya kwesigaba "Izinhlelo".

    Ewindini elilandelayo, khetha isigatshana "Izinhlelo ezizenzakalelayo".

  2. Ngemuva kwalokho, ifasitela elifanayo liqalisiwe, elizovuleka uma siqhafaza into "Izinhlelo ezizenzakalelayo" ngqo kwimenyu "Qala". Khetha isikhundla "Ukuqhathaniswa kwezinhlobo zefayela noma izivumelwano ezinhlelo ezithile".
  3. Iwindi iqala "Ukuqhathaniswa kwezinhlobo zefayela noma izivumelwano ezinhlelo ezithile". Kuhlu lwazo zonke izandiso zefayela ezibhalisiwe ohlelweni lokubhalisa kwesistimu yakho ye-Windows, bheka igama ".ods". Ngemva kokuthola, khetha leli gama. Okulandelayo, chofoza inkinobho "Shintsha uhlelo ..."elitholakala ngakwesokudla kwewindi, ngaphezulu kohlu lwezandiso.
  4. Futhi, ifasitela lokukhethwa kwesicelo elijwayelekile livuleka. Lapha nawe udinga ukuchofoza egameni "I-Microsoft Excel"bese ucindezela inkinobho "Kulungile"njengoba senze kule nguqulo yangaphambilini.

    Kodwa kwezinye izimo, awukwazi ukuthola "I-Microsoft Excel" ohlwini lwazo izicelo eziphakanyisiwe. Lokhu kungenzeka ikakhulukazi uma usebenzisa izinguqulo ezindala zalolu hlelo, ezingakahlinzekiwe ngokuhlanganyela namafayela e-ODS. Kungenzeka futhi ngenxa yokuhluleka kwesistimu noma ngenxa yokuthi othile ususe ngokuphumelelayo i-Excel ohlwini lwazinhlelo eziphakanyisiwe zamadokhumenti nokwandiswa kwe-ODS. Kule nkinga, efasiteleni lokukhetha lesicelo, chofoza inkinobho "Buyekeza ...".

  5. Ngemuva kwesenzo sokugcina, iwindi iqalisiwe. "Vula nge ...". Ivula ifolda yendawo yohlelo kukhompyutha ("Amafayela Ohlelo"). Udinga ukuya kusiqondisi sefayela eligijima i-Excel. Ukwenza lokhu, thuthela kwifolda ebizwa ngokuthi "I-Microsoft Office".
  6. Ngemuva kwalokho, esihlalweni esivuliwe udinga ukukhetha uhla lwemibhalo equkethe igama "Ihhovisi" futhi inombolo yenombolo yehhovisi ehhovisi. Isibonelo, i-Excel 2010 izoba igama "Office14". Njengomthetho, kuphela ihhovisi le-Microsoft elilodwa kuphela elifakwe kukhompyutha. Ngakho khetha nje ifolda equkethe igama egameni layo. "Ihhovisi"bese ucindezela inkinobho "Vula".
  7. Esihlalweni esivuliwe sibheke ifayela ngegama "EXCEL.EXE". Uma izandiso zingavunyelwe ku-Windows yakho, kungabizwa "EXCEL". Lena ifayela lokuqaliswa kokusebenzisa igama elifanayo. Khetha bese uchofoza inkinobho. "Vula".
  8. Emva kwalokhu, sibuyela ewindini lokukhetha uhlelo. Uma ngisho ngasekuqaleni phakathi kohlu lwamagama wezinhlelo zokusebenza "I-Microsoft Excel" kwakungekho, manje kuzovela. Khetha bese uchofoza inkinobho. "Kulungile".
  9. Ngemuva kwalokho, iwindi lefayili yohlobo lwefayili lizobuyekezwa.
  10. Njengoba ungabona efasiteleni lomhlobo wefayili, manje imibhalo ene-ODS extension izohlanganiswa ne-Excel ngokuzenzakalelayo. Okusho ukuthi, uma uchofoza kabili kwisithonjana salesi fayela ngenkinobho yegundane lesokunxele, sizovula ngokuzenzakalelayo ku-Excel. Sidinga kuphela ukuqedela umsebenzi efasiteleni lomhlobo lohlobo lwefayela ngokuchofoza inkinobho. "Vala".

Indlela ye-3: Vula ifomethi ye-ODS kuzihumusho ezindala ze-Excel

Futhi manje, njengokwethenjisiwe, sizohlala ngokufushane ngamafomu okuvula ifomu le-ODS kuzihumusho ezindala ze-Excel, ikakhulukazi ku-Excel 2007, 2003.

Ku-Excel 2007, kunezinketho ezimbili zokuvula idokhumenti ngesandiso esichaziwe:

  • ngokusebenzisa isikhombikubona sohlelo;
  • ngokuchofoza isithonjana salo.

Indlela yokuqala, eqinisweni, ayifani nendlela evulekile yokuvula ku-Excel 2010 nakuzinguqulo zakamuva, esizichazile okuncane. Kodwa ngenguqulo yesibili sizoyeka ngokuningiliziwe.

  1. Iya kuthebhu Engeza-ons. Khetha into "Ngenisa ifayela le-ODF". Ungenza futhi inqubo efanayo ngokusebenzisa imenyu "Ifayela"ngokukhetha isikhundla "Ukungenisa ispredishithi kufomethi ye-ODF".
  2. Uma wenza noma yikuphi kwalokhu okukhethwa kukho, iwindi lokungenisa lizoqaliswa. Kuyo kufanele ukhethe into oyidingayo nge-extension ye-ODS, ukhethe bese uchofoza inkinobho "Vula". Ngemuva kwalokho, lo mbhalo uzoqaliswa.

Ku-Excel 2003, konke kuyinkimbinkimbi kakhulu, ngoba le nguqulo yavela ngaphambi kokuthi ifomethi ye-ODS ithuthukiswe. Ngakho-ke, ukuvula amadokhumenti ngalesi sandiso, kumele ufake i-plugin ye-Sun ODF. Ukufakwa kwe-plugin ecacisiwe kwenziwa njengenjwayelo.

Landa i-Plugin ye-Sun ODF

  1. Ngemva kokufaka iphaneli ye-plug-in izovela "I-Plugin ye-Sun ODF". Inkinobho izobekwa kuso. "Ngenisa ifayela le-ODF". Chofoza kuso. Okulandelayo udinga ukuchofoza egameni "Ngenisa Ifayela ...".
  2. Iwindi lokungenisa liqala. Kudingeka ukhethe idokhumenti oyifunayo bese uchofoza inkinobho. "Vula". Ngemuva kwalokho kuzosungulwa.

Njengoba ubona, ukuvulwa kwamatafula kufomethi ye-ODS ngezihumusho ezintsha ze-Excel (2010 nangaphezulu) akufanele kubangele ubunzima. Uma noma ubani enenkinga, ke lesi sifundo sizonqoba. Nakuba, naphezu kokukhululeka kokuqaliswa, akunakwenzeka njalo ukubonisa le dokhumenti ku-Excel ngaphandle kokulahlekelwa. Kodwa ngezihumusho zesikhathi esedlule, ukuvula izinto nge-extension ecacisiwe kuhlotshaniswa nezinkinga ezithile, kuhlanganise nesidingo sokufaka i-plug-in ekhethekile.