Lo mbhalo uhlola izimbangela futhi unikeze izixazululo ezingaba khona zokuxazulula i-MS Iphutha le-Excel "I-Excel Ithole Okuqukethwe Okungafundeki".
I-MS Excel uhlelo olukhulu lokuhlaziywa kwedatha. Ivumela abasebenzisi ukuthi bahlele amarekhodi kudatha enengqondo engasetshenziselwa ukwenza izinqumo zebhizinisi. Uhlelo lokusebenza lunamandla okuphatha amafomula anzima angacubungula idatha ngokushesha nangokunembile. Lokhu kukuvumela ukuthi uhlaziye amathani wedatha kahle.
Ngeshwa, amaspredishithi athinteka enkohlakalweni yedatha, ikakhulukazi uma uthuthukela kusuka enguqulweni ephansi uye phezulu. Uma lokhu kwenzeka, awukwazi ukufinyelela kudatha yakho. Esikhundleni salokho, uzothola amaphutha ahlukahlukene akuvimbela ukuthi uvule ispredishithi. Isibonelo salawa maphutha i- "Excel ithole okuqukethwe okungafundeki".
Yini ebangela leli phutha
Leli phutha lingadalwa yizizathu ezahlukahlukene, kufaka phakathi ukusetshenziswa kwe-Open XML lapho kwakhiwa amafayela we-Excel. Inkohlakalo ingenzeka kunoma iyiphi ingxenye yespredishithi. Lokhu kungaba kufomathi yeseli, ezingeni leMacros, noma amafomula. Ispredishithi singaba nezinkinga eziningi zenkohlakalo. Ukushintsha kusuka kunguqulo ephansi ye-Excel kuye phezulu kungakhuphula izinga lenkohlakalo. Isibonelo, kulula ukuphatha leli phutha ngesandla ku-Excel 2003 kune-Excel 2010.
Izindlela zokulungisa leli phutha
Lapho ulungisa leli phutha, ayikho indlela ethile yezandla esebenza kuzo zonke izimo. Lokhu kungenxa yokuthi kuzoya ngesizathu se- Inkohlakalo yefayela le-Excel. Ngakho-ke, ngaphambi kwakho start ukuxazulula inkinga ngefayela elonakele, yenza ikhophi lefayela loqobo ukuze ube nesipele uma imizamo yakho yokutakula ingadala umonakalo omkhulu kuspredishithi sakho.
Indlela 1: Guqula ispredishithi sakho sibe yi-HTML uphinde ubuyele kufomethi ye-.xls
Enye indlela yokuxazulula leli phutha ukuguqula ifayela lakho libe yifomethi ye-HTML bese ubuyela kufomethi ye-.xls. Ukufeza lokhu, chofoza kwesokudla ku- taruthole ifayela bese ukhetha inketho ethi 'Qamba kabusha'. Manje shintsha isandiso sefayela sibe yi-.html.
Kuzovela umyalezo ozivelelayo, okuxwayisa ngokuthi ukushintsha ifomethi yefayela kuzonikeza lelo fayela ukuthi lingasebenziseki futhi kubuze ukuthi uyafuna yini ukuqhubeka. Thepha inkinobho ethi 'Yebo' ukuqedela inqubo. Manje phinda le nqubo kepha shintsha ifomethi yefayela ibe ngama-.xls bese uzama ukuvula ispredishithi. Lokhu kusebenza kungasebenza ku-Excel 2003 kepha hhayi kuzinguqulo zakamuva ezisebenzisa i-Open XML.
Indlela 2: Sebenzisa i-Open XML SDK 2.5 ukukhomba izingxenye ezikhohlakele zefayela lakho
Ungasebenzisa futhi ithuluzi le-Open XML SDK 2.5 ukuphenya ukuthi iziphi izingxenye zefayela lakho ezonakele. Ukufeza lokhu, landa ithuluzi kwa-Microsoft bese ulifaka kukhompyutha yakho. Manje, qalisa uhlelo bese uvula ifayela lakho elonakele usebenzisa leli thuluzi. Shaya ithebhu ethi 'Qinisekisa' kubha yemenyu. Lokhu kuzogqamisa izigaba ezikhohlakele zefayela. Ngemuva kwalokho ungalungisa lawo maphutha ngokwakha elinye ifayela. Ngeshwa, le ndlela idinga ukuthi ube namakhono aphezulu we-IT njengokuhlela futhi ngenxa yalokho kungenzeka ingasebenzi kumsebenzisi ojwayelekile we-Excel.
Indlela 3: Sebenzisa ithuluzi elikhethekile lokulungisa nokubuyisa le-MS Excel
Uma ungakwazi ukulungisa ifayela lakho usebenzisa izindlela ezingenhla, kuyalulekwa ukusebenzisa ithuluzi elithuthukisiwe elenzelwe ngokukhethekile ukuthola amafayela we-Excel akhohlakele. Elinye lamathuluzi ahamba phambili kulesi sigaba DataNumen Excel Repair. Ngokungafani nezinye izindlela ezenziwa ngesandla, ukusebenzisa leli thuluzi akudingi ukuthi ube namakhono e-IT athuthukile. Kulula ukuyisebenzisa futhi isebenza kahle kakhulu. Lapho usufake uhlelo kwikhompyutha yakho, landela imiyalo elula kuwebhusayithi yenkampani ukuthola ifayela lakho.
1