XLSX, XLSM, XLS, XLTX uye XLTM
A faira rinowedzera iboka reetsamba dzinoonekwa pashure penguva yekupedzisira mune zita refaira yemakombiyuta ari kushandisa Windows operating system. Firiji yakawedzerwa inowanzova 2 kusvika ku 4 mavara kwenguva refu.
Firiji yakawedzerwa inowirirana nefaira yefaira, iyo kombiyuta programming term iyo inotsanangura kuti mashoko anonyorwa sei kuchengetwa mune imwe kombiyuta faira.
Muchiitiko cheExcel, ikozvino kusina faira yekuwedzera ndeye XLSX uye yakabva kubvira kuExcel 2007. Isati yakadaro, iyo yakawandisa yefaira yefaira yaiva XLS.
Kusiyana pakati pezviviri, kunze kwekuwedzerwa kwechipiri X, ndeyekuti XLSX iri XML-based open file fomu, nepo XLS ine yeMicrosoft yemhando.
XML Makomborero
XML inomirira mutauro wakanyatsoshandiswa uye yakabatana ne HTML ( hypertext markup language ) kushandiswa kunoshandiswa pamapeji ewebhu.
Maererano newebhu yeMicrosoft, zvakanakira fomu yefaira zvinosanganisira:
- mabhuku maduku maduku ekuchengetedza nekutsvaga;
- zviri nani kugadzirisa ruzivo kubva kune zvakakanganiswa mafaira;
- nyore kuona mafaira ane macros .
Izvi zvinobatsira kubva pakuona kuti mafaira akakwirira ane VBA uye XLM macros anoshandisa kuwedzera XLSM pane XLSX. Sezvo macros inogona kuva neipi yakaipa iyo inogona kukuvadza mafaira uye inopesana nekuchengetedzwa kwekombiyuta, zvinokosha kuziva kana faira ine ma macros isati yavhurwa.
Zvitsva zvitsva zveExcel zvinogona kuchengetedza uye kuzarura mafaira eXLS nekuda kwekuenderana nemapurogiramu apfuura epurogiramu.
Kuchinja mafaira eFaira ne Save As
Kuchinja mafaira mafaira kunogona kuitwa kuburikidza ne Save As dialog box , sezvinoratidzwa mumufananidzo uri pamusoro. Matanho ekuita izvi ndeokuti:
- Vhura bhuku rebhuku rinofanira kuponeswa neefaira yakasiyana nefaira;
- Dzvanya paDhiyabhorosi tab yebhoni kuitira kuti uzarure mhando yekunyorera;
- Dzvanya pa Save As in menyu kuti uzarure Save As panel yezvasarudzo;
- Sarudza nzvimbo kana chengetera paBook pakutanga kuzarura Save As dialog box;
- Mubhokisi rebhokisi, bvuma zita repafaira rakarongeka kana kuisa zita idzva rebhuku rebhuku ;
- Muchi Save semhando yerudzi , sarudza faira mafaira ekuchengetedza faira;
- Dzvanya Ponesa kuti uchengetedze faira mumutauro mutsva uye dzokera kune pepa rekushandira riripo.
Cherechedza: kana iwe uri kuchengetedza faira iri mumutauro usingatsigire zvinhu zvose zvemaitiro zvino, zvakadai sekugadzirisa kana mazano, bhokisi rekucherechedza bhokisi richauya richikuzivisai izvozvi uye kukupa sarudzo yekuregesa kuchengeta. Kuita izvi kuchakudzorera kuIndaneti Sekugovera sebhokisi.
Kuvhura uye Kuziva Mafaira
Kune vakawanda vashandisi veWindows , kushandiswa kukuru uye kubatsirwa kwefaira yefaira ndeyekuti inovabvumira kudarika kaviri pane XLSX, kana XLS file uye system yekushanda ichaizarura mu Excel.
Mukuwedzera, kana mafaira ekuwedzera achioneka , achiziva kuti zvidimbu zvipi zvinobatanidzwa nezvirongwa zvipi zvinogona kuita kuti zvive nyore kuona mafaira muMy Documents kana Windows Explorer.
XLTX uye XLTM Fomu Yemafaira
Apo faira yakakosha yakachengetedzwa pamwe nehuwandu hwe XLTX kana XLTM inochengetwa sefa template. Zvinyorwa zve Template zvakagadziridzwa kushandiswa sekutanga mafaira e mabhuku matsva emabasa uye inowanzo dzine zvirongwa zvakachengetedzwa zvakadai sekushamba kwenhamba yemashizha mubhuku rebasa, kuumba mafomu , mafananidzo, mavara, uye tsika dzebasa.
Misiyano pakati pezvinyorwa zviviri ndeyokuti XLTM format inogona kuchengetedza VBA ne XML (Excel 4.0 macros) code macro.
Nzvimbo isina kuchengetwa nzvimbo yekugadzirirwa kwevashandi ndeyokuti:
C: \ Users \ [UserName] \ Documents \ Custom Office Templates
Kana imwe tsika ye template yakasikwa, iyo uye zvose zvadaro yakagadzirirwa zviratidzo zvichongowedzerwa kuRuga rwandu rwema templates iri pasi peFaili> Itsva mumam menus.
Excel Macintosh
Kunyange zvazvo makombiyuta maMacintosh asingatarisi mafaira ekuwedzera ekugadzirisa chirongwa chipi chekushandisa kana uzarura faira, nekuda kwekuenderana neWindows versions dzeExcel, zvitsva zvinoshandiswa Excel zve Mac - sekushandurwa kwa2008, shandisa XLSX file extension kuburikidza .
Pamusoro pezvikamu zvakawanda, Excel mafaira akaumbwa mune chero inoshandiswa system anogona kuvhurwa nemumwe. Chimwe chete kune iyi ndiyo Excel 2008 yeMac iyo isina kutsigira VBA macros. Somugumisiro, haikwanise kuzarura mafaira eXLMX kana XMLT akasika neWindows kana kuti later Mac mavhesi epurogiramu inotsigira VBA macros.