XLSX, XLSM, XLS, XLTX thiab XLTM
Cov ntaub ntawv txuas ntxiv yog pawg ntawm cov ntawv uas tshwm sim tom qab lub sij hawm dhau los ntawm cov ntaub ntawv rau cov computers khiav hauv Windows operating system. Cov ntaub ntawv Extensions yog feem ntau 2 mus rau 4 cim ntev.
Cov ntaub ntawv txuas ntxiv muaj feem xyuam rau hom ntaub ntawv, uas yog lub computer programming lub sij hawm uas qhia tias cov ntaub ntawv sau cia kom muab cia rau hauv computer ntaub ntawv.
Nyob rau hauv rooj plaub ntawm Excel, tam sim no qhov kev hloov ncua sij hawm yog XLSX thiab lawm txij thaum Excel 2007. Ua ntej ntawd, lub neej ntawd ncua sij hawm ncua XLS.
Qhov txawv ntawm ob, dhau qhov sib ntxiv ntawm tus thib ob X, yog tias XLSX yog XML-raws li qhib cov ntaub ntawv hom, thaum XLS yog ib hom ntawv Microsoft.
XML Zoo Tshaj Plaws
XML txhais rau cov lus cim lus uas siv tau ntau ntxiv thiab nws yog hais txog HTML ( hypertext markup language ) txuas ntxiv rau cov nplooj ntawv web.
Raws li Microsoft lub vev xaib, qhov zoo ntawm cov ntaub ntawv muaj xws li:
- ntau cov ntaub ntawv me me rau cia thiab hloov;
- rov qab zoo dua ntawm cov ntaub ntawv los ntawm cov ntaub ntawv puas;
- nrhiav tau yooj yim ntawm cov ntaub ntawv muaj macros .
No kawg kom zoo dua qub los ntawm qhov tseeb tias cov ntaub ntawv tawm uas muaj VBA thiab XLM macros siv lub XLSM extension es tsis yog XLSX. Vim hais tias macros muaj peev xwm muaj kev siab phem uas ua rau cov ntaub ntawv thiab ua rau lub computer tsis ruaj, nws yog qhov tseem ceeb kom paub yog tias muaj cov ntaub ntawv muaj macros ua ntej qhib.
Cov newer versions of Excel tseem txuag thiab qhib XLS ntaub ntawv rau tus sake of compatibility nrog ua ntej versions ntawm qhov kev pab cuam.
Hloov Cov Ntaub Ntawv Hloov Nrog Txuag Li
Hloov cov ntaub ntawv tawm tswv yim tuaj yeem ua tiav los ntawm Daws Teeb Sib Tham , raws li muaj nyob hauv daim duab saum toj no. Cov kauj ruam rau kev ua li no yog:
- Qhib cov ntawv ua haujlwm uas yog kom tau txais kev cawmdim nrog lwm hom ntawv;
- Nias rau ntawm Daim Ntawv Txheej ntawm txoj hlua qhib qhib lub tshuab raj;
- Nias nyob rau hauv cov ntawv qhia zaub mov kom qhib lub Txuag Raws li cov kev xaiv;
- Xaiv qhov chaw los yog nias rau ntawm Xauj khawm qhib lub Txais Raws li kev sib tham sib tham;
- Hauv lub thawv ntawv, txais lub npe ntawm cov ntaub ntawv lossis sau ib lub npe tshiab rau phau ntawv no ;
- Hauv Txuag Cov Ntawv Xaiv Sau, xaiv ib hom ntaub ntawv khaws tseg rau cov ntaub ntawv;
- Nias Tseg kom txuag tau cov ntaub ntawv hauv hom ntawv tshiab thiab rov qab mus rau daim ntawv ua haujlwm tam sim no.
Ceeb Toom: Yog tias koj txuag cov ntaub ntawv ua hom ntawv uas tsis txhawb txhua tus qauv ntawm hom ntawv tam sim no, xws li kev sau ntawv los yog cov qauv, qhov kev ceeb toom kev ceeb toom yuav tshwm sim qhia koj txog qhov tseeb thiab muab qhov kev xaiv ntawm kev txiav luam yeeb tseg. Ua li ntawd yuav xa koj mus rau Txuas Raws Li lub thawv ntawv.
Qhib thiab Paub Cov Ntaub Ntawv
Rau feem ntau ntawm cov neeg siv ntawm Windows , qhov tseem ceeb siv thiab tau txais txiaj ntsim ntawm cov ntaub ntawv ntxiv yog tias nws tso cai rau lawv mus muab ob npaug nias rau ntawm XLSX, los yog XLS cov ntaub ntawv thiab lub operating system yuav qhib rau Excel.
Tsis tas li ntawd, yog hais tias cov ntaub ntawv txuas ntxiv yog pom , paub qhov kev txuas ntxiv uas cuam tshuam nrog cov kev pabcuam twg thiaj ua tau yooj yim los txheeb xyuas cov ntaub ntawv nyob hauv Kuv Cov Ntaub Ntawv lossis Lub Tuam Txhab Uas Qhov Tseeb.
XLTX thiab XLTM tej ntaub ntawv
Thaum twg tus ntaub ntawv zoo lawm rua ntawm ib lub XLTX los yog XLTM extension nws yog rua li ib cov ntaub ntawv template. Cov ntaub ntawv Template yog siv los ua cov ntaub ntawv keeb kwm tshiab rau cov phau ntawv sau tshiab thiab lawv yeej muaj kev nqis tes ua xws li cov ntawv pov thawj ntawm ib daim ntawv ua hauj lwm, formatting, qauv , cov duab kos, thiab kev cai toolbars.
Qhov txawv ntawm qhov ob extensions yog tias lub XLTM hom yuav khaws VBA thiab XML (Excel 4.0 macros) macro code.
Lub neej cia cov chaw nyob rau cov neeg siv tsim tus qauv yog:
C: \ Cov neeg siv \ [UserName] \ Cov ntaub ntawv \ Kev cai Office Templates
Thaum ib tus qauv kev tsim qauv tsim, nws thiab tag nrho tom qab tsim templates yuav tau muab ntxiv rau Daim Ntawv Teev ntawm cov ntsiab lus nyob hauv qab Cov Ntawv> Tshiab hauv cov ntawv teev khoom.
Excel rau Macintosh
Thaum Macintosh cov computers tsis cia siab rau cov ntaub ntawv txuas ntxiv rau kev txiav txim siab twg qhov kev zov me nyuam siv thaum qhib ib cov ntaub ntawv, rau lub hom phiaj ntawm kev sib raug zoo nrog lub Windows versions of Excel, newer versions Excel rau Mac - raws li version 2008, siv cov XLSX cov ntaub ntawv ncua ntxiv los ntawm lub neej ua ke .
Rau feem ntau cov feem, Excel cov ntaub ntawv tsim nyob rau hauv txawm tias operating system yuav qhib los ntawm lwm. Ib qho kos rau qhov no yog Excel 2008 rau Mac uas tsis txhawb VBA macros. Yog li ntawd, nws yuav tsis qhib XLMX lossis XMLT ntaub ntawv tsim los ntawm Windows los tom Mac Mac ntawm qhov kev pab cuam uas txhawb VBA macros.