I-XLSX, i-XLSM, i-XLS, i-XLTX ne-XLTM
Isandiso sefayela iqoqo lezinhlamvu ezivela ngemva kwesikhathi sokugcina egameni lefayela lamakhompiyutha asebenzisa uhlelo lokusebenza lwe - Windows . Ifayela izandiso ngokuvamile ziyizinhlamvu ezimbili kuya kwezingu-4 ubude.
Ifayela lesandiso lihlobene nefomethi yefayili, eyisikhathi sokuhlela ikhompyutha esichaza indlela ulwazi olufakwe ngayo ukugcinwa kwifayili yekhompyutha.
Endabeni ye-Excel, isandiso sefayela elizenzakalelayo samanje yi-XLSX futhi kusukela kusukela ku-Excel 2007. Ngaphambi kwalokho, isandiso sefayela elizenzakalelayo yi-XLS.
Umehluko phakathi kwalaba ababili, ngaphandle kokungezwa kwe- X yesibili , yilokho i-XLSX iyifomethi yefayela evuliwe e-XML, kanti i-XLS iyifomethi ye-Microsoft.
Izinzuzo ze-XML
I-XML imele ulimi olumangalisayo lwe-markup futhi lihlobene ne-HTML ( ulimi lwe-markup hypertext ) isandiso esetshenziselwa amakhasi wewebhu.
Ngokwesayithi le-Microsoft, izinzuzo zefomethi yefayela zifaka:
- amancane amarekhodi wefayela wokugcina nokudlulisa;
- ukutakula okungcono kolwazi kusuka kumafayela awonakele;
- Ukuthola lula kwamafayela aqukethe ama-macros .
Le nzuzo yokugcina ibangelwa ukuthi amafayela aphezulu aqukethe i- VBA ne- XLM macros asebenzisa isandiso se-XLSM esikhundleni se-XLSX. Njengoba ama-macros angaqukatha ikhodi enonya engalimaza amafayela futhi akwehlise ukuphepha kwekhompyutha, kubalulekile ukwazi uma ifayela liqukethe ama-macros ngaphambi kokuba livule.
Izinguqulo ezintsha ze-Excel zingasindisa futhi zivule amafayela we-XLS ngenxa yokuhambisana nezinuqulo zangaphambili zohlelo.
Ukushintsha amafomethi wefayela ne-Save As
Ukushintsha amafomethi wefayela kungafezwa ngebhokisi le- Save njengebhokisi , njengoba kuboniswe esithombeni ngenhla. Izinyathelo zokwenza kanjalo zi:
- Vula ibhuku lokugcina elizogcinwa ngefomethi yefayela ehlukile;
- Chofoza kuthebhu yefayela yebhebhoni ukuvula imenyu ehlayo;
- Chofoza ku- Londoloza Njengemenyu ukuze uvule iphaneli yokulondoloza yezinketho;
- Khetha indawo noma uchofoze inkinobho yokudlulisa amehlo ukuze uvule ibhokisi lokungenisa le- Save njenge-;
- Ebhokisini lengxoxo, yamukela igama lefayela eliphakanyisiwe noma uthayiphe igama elisha kubhuku lokusebenzela ;
- Ku- Londoloza njengohlu lwamagama, khetha ifomethi yefayela yokulondoloza ifayela;
- Chofoza u- Londoloza ukuze ulondoloze ifayela kufomethi entsha futhi ubuyele kumshicileli wamanje.
Qaphela: uma ulondoloza ifayela ngefomethi engasekeli zonke izici zefomathi yamanje, njengokufometha noma amafomula, ibhokisi lomyalezo wokuxwayisa lizovela likukwazise ngaleli qiniso futhi likunike ithuba lokukhansela ukulondoloza. Ukwenza kanjalo kuzokubuyisela ebhokisini lebhokisi lokulondoloza.
Ukuvula nokukhomba amafayela
Kubasebenzisi abaningi be- Windows , ukusetshenziswa okuyinhloko nokuzuza kwesandiso sefayela ukuthi kubavumela ukuba bachofoze kabili kwifayela le-XLSX, noma i-XLS kanye nesistimu yokusebenza izoyivula ku-Excel.
Ngaphezu kwalokho, uma izandiso zefayela zibukeka , zikwazi ukuthi yiziphi izandiso ezihlotshaniswa yiziphi izinhlelo ezingenza kube lula ukubona amafayela kumadokhumenti ami noma i- Windows Explorer.
Amafomethi wefayela le-XLTX ne-XLTM
Uma ifayela elihle ligcinwe nge-extension XLTX noma i-XLTM ilondolozwa njengefayela lethempulethi. Amafayela wesifanekiso ahloswe ukuthi asetshenziswe njengeziqalo zokuqala zezincwadi zokusebenzela futhi ngokuvamile ziqukethe izilungiselelo ezilondoloziwe njengezinombolo ezizenzakalelayo zamashidi ebhukwini ngalinye, ukufometha, amafomula , ihluzo, namabha yamathuluzi wendabuko.
Umehluko phakathi kwezandiso ezimbili ukuthi ifomethi ye-XLTM ingagcina i-VBA ne-XML (i-Excel 4.0 macros) ikhodi macro.
Indawo yokugcina okuzenzakalelayo yezifanekiso ezidalwe ngumsebenzisi yilezi:
C: \ Abasebenzisi \ [Igama lomsebenzisi] \ Amadokhumenti \ Izifanekiso ze-Custom Office
Uma ithemplate yangokwezifiso idalwe, yona nayo yonke izifanekiso ezidalwe kamuva zizofakwa ngokuzenzekelayo ohlwini lwabantu lwazo izifanekiso ezitholakala ngaphansi kwefayela> Okusha kumamenyu.
I-Excel ye-Macintosh
Ngenkathi amakhompiyutha e-Macintosh engathembeli ezandisweni zefayela ukunquma ukuthi iyiphi uhlelo lokusebenza oluzoyisebenzisa uma uvula ifayela, ngenxa yokuhambisana nezinguqulo ze- Windows ze-Excel, izinguqulo ezintsha ze-Excel ze-Mac - njengenguqulo ye-2008, sebenzisa isandiso sefayela le-XLSX ngokuzenzakalelayo .
Ngokuyinhloko, amafayela e-Excel adalwe kuhlelo noma uhlelo lokusebenza angavulwa ngolunye. Okuhlukile kulokhu yi-Excel 2008 ye-Mac engazange isekele i-VBA macros. Ngenxa yalokho, ayikwazi ukuvula amafayela we-XLMX noma i-XMLT adalwe yizinguqulo ze-Windows noma kamuva ze-Mac ezisekela i-VBA macros.