XLSX, XLSM, XLS, XLTX da XLTM
Fayil din fayil shine rukuni na haruffan da suka bayyana bayan lokacin ƙarshe a cikin sunan fayil don kwakwalwa ke gudana cikin tsarin tsarin Windows . Karin kariyar fayilolin yawancin haruffa 2 zuwa 4.
Karin kariyar fayil suna da alaƙa da tsarin fayil, wanda shine lokacin tsara shirye-shiryen kwamfuta wanda ya ƙayyade yadda aka tsara bayanin don ajiya a cikin fayil na kwamfuta.
A cikin akwati na Excel, layin fayil ɗin tsoho na yanzu shi ne XLSX kuma ya kasance tun daga Excel 2007. Kafin wannan, ƙaddamar fayil din tsoho shi ne XLS.
Bambanci tsakanin su biyu, banda Bugu da kari na X na X, shine XLSX shine tsari na budewa ta hanyar XML, yayin da XLS tsarin Microsoft ne na ƙira.
Magani na XML
XML na tsaye ne don harshen ƙwaƙwalwar ƙwaƙwalwa kuma ana danganta shi da HTML ( harshen sautin murya ) da tsawo da ake amfani dashi don shafukan intanet.
Bisa ga shafin yanar gizon yanar gizon Microsoft, ƙwarewar tsarin fayil ɗin sun haɗa da:
- Ƙananan fayilolin fayil don ajiya da canja wuri;
- mafi alhẽri dawo da bayanin daga lalace fayiloli;
- mafi sauƙin ganewa na fayiloli dauke da macros .
Wannan amfani na ƙarshe ya samo asali daga gaskiyar cewa fayilolin da ke dauke da VBA da XLM macros suna amfani da XLSM tsawo maimakon XLSX. Tun da macros zasu iya ƙunsar lambar mallaka wanda zai iya lalata fayiloli da kuma daidaita tsarin tsaro na kwamfuta, yana da muhimmanci a san idan fayil yana da macros kafin a bude shi.
Sabbin sababbin Excel na iya adanawa da buɗe fayilolin XLS don kare kanka da dacewa tare da fasali na wannan shirin.
Canza fayilolin Fayilolin Ajiye Kamar yadda
Canja fayilolin fayil za a iya cika ta hanyar Ajiye Kamar akwatin maganganu , kamar yadda aka nuna a cikin hoto a sama. Matakan yin haka sune:
- Bude littafin da za'a adana tare da tsarin fayil ɗin daban;
- Danna kan fayil na rubutun don bude jerin menu na saukewa;
- Danna kan Ajiye Kamar yadda a cikin menu don buɗe Shafin As panel na zažužžukan;
- Zaɓi wuri ko danna maɓallin Browse don buɗe akwatin maganganun Ajiye Kamar yadda ;
- A cikin maganganun maganganu, yarda da sunan fayil ɗin da aka shawarta ko rubuta sabon suna don littafin aiki ;
- A Ajiye azaman jerin nau'in , zaɓi tsarin fayil don ajiye fayil;
- Danna Ajiye don ajiye fayil ɗin a sabon tsarin kuma komawa zuwa aikin aiki na yanzu.
Lura: idan kana ajiye fayil din a cikin tsari wanda ba ya goyi bayan duk siffofin tsarin yanzu, kamar tsarawa ko tsari, akwatin saƙon saƙo zai bayyana sanar da kai game da wannan hujja kuma yana ba ka zaɓi na soke buƙatar. Yin hakan zai dawo da ku zuwa akwatin Ajiye Kamar yadda zane.
Ana buɗewa da ganowa fayiloli
Ga mafi yawan masu amfani da Windows , babban amfani da amfanar fayil ɗin shine faɗakar da su don sauƙaƙe a kan XLSX, ko kuma XLS fayil kuma tsarin aiki zai bude shi a Excel.
Bugu da ƙari, idan kariyar fayiloli za a iya gani , sanin abin da waɗannan haɗin ke hade da abin da shirye-shiryen zasu iya sauƙaƙe don gane fayiloli a cikin takardunku ko Windows Explorer.
XLTX da XLTM Formats na Fayil
Lokacin da aka ajiye fayil din da ya fi dacewa da XLTX ko XLTM tsawo an ajiye shi azaman fayil ɗin samfuri. An yi amfani da fayilolin samfuri don amfani da fayiloli na farko don sababbin littattafan littattafai kuma suna ƙunshi saitunan da aka adana kamar su tsoho yawan takardun shaida ta littafin littafi, tsarawa, dabarar , kayan hoto, da kayan aiki na al'ada.
Bambanci tsakanin adadin biyu shine cewa tsarin XLTM zai iya adana lambar macro VBA da XML (Excel 4.0 macros).
Yanayin ajiya na asali don samfurori masu amfani ne:
C: \ Masu amfani [Sunan mai amfani] \ Takardun \ Samfura na Custom Custom
Da zarar an kirkira samfurin al'ada, anyi amfani da duk takardun da aka kirkira ta atomatik a cikin Jerin sunayen ɗakunan da ke karkashin Fayil> Sabo a cikin menus.
Excel don Macintosh
Yayinda kwakwalwa ta Macintosh ba su dogara da kariyar fayil ba don ƙayyade abin da shirin zai yi amfani dashi lokacin bude fayil, don sake dacewa tare da sassan Excel na Windows , sababbin Excel na Mac - kamar yadda na 2008, yi amfani da tsawo na XLSX ta hanyar tsoho .
Ga mafi yawancin, fayilolin Excel da aka halitta a ko dai tsarin aiki zasu iya buɗewa ta ɗayan. Ɗaya daga cikin banda wannan shine Excel 2008 don Mac wadda ba ta goyi bayan VBA macros ba. A sakamakon haka, ba zai iya bude fayilolin XLMX ko fayilolin XMLT da Windows ya tsara ko daga baya daga cikin shirin da ke goyon bayan VBA macros ba.