Excel File Extensions ndi Ntchito Zawo

XLSX, XLSM, XLS, XLTX ndi XLTM

Kuwonjezera pa mafayilo ndi gulu la makalata omwe amawoneka pambuyo pa nthawi yotsiriza mu dzina la fayilo kwa makompyuta omwe akuyendetsa mawonekedwe a Windows . Zowonjezera maulendo nthawi zambiri amakhala awiri kapena 4.

Zowonjezera mafayilo zikugwirizana ndi mafayilo apangidwe, omwe ndi pulogalamu yamakina pakompyuta yomwe imatanthauzira momwe malemba amalembera kuti asungidwe mu fayilo ya makompyuta.

Pankhani ya Excel, kufalikira kwa mafayilo omwe alipo tsopano ndi XLSX ndipo wakhala kuyambira Excel 2007. Zisanayambe, kufalikira kwa mafayilo osasintha kunali XLS.

Kusiyanitsa pakati pa ziwirizi, pambali pa kuwonjezera kwa X yachiwiri , ndi XLSX ndi XML yochokera kufotokozera mafayilo, pomwe XLS ndi ma Microsoft apamwamba.

Zotsatira za XML

XML imayimira chilankhulo chosasinthika ndipo imakhudzana ndi HTML ( chinenero chamakono ) kufalikira kwa masamba.

Malinga ndi webusaiti ya Microsoft, ubwino wa mawonekedwe a fayilo ndi awa:

Ubwino wotsirizawu umachokera kukuti maofesi opambana omwe ali ndi VBA ndi XLM macros amagwiritsa ntchito XLSM kufalikira m'malo mwa XLSX. Popeza macros ikhoza kukhala ndi code yoipa yomwe ingasokoneze mafayilo ndikugonjetsa chitetezo cha makompyuta, ndikofunikira kudziwa ngati fayilo ili ndi macros musanatsegulidwe.

Excel yatsopano ikhoza kusunga ndi kutsegula mafayilo a XLS chifukwa chogwirizana ndi mapulogalamu oyambirira.

Kusintha Fomu Zopangira ndi Save As

Kusintha mawonekedwe a mafayilo angakhoze kupyolera kupyolera mu bokosi la Kusunga Monga Gulu , monga momwe tawonetsera pa chithunzi pamwambapa. Masitepe otero ndi:

  1. Tsegulani buku loti lidzapulumutsidwe ndi mawonekedwe osiyana siyana;
  2. Dinani pa Fayilo tabu ya riboni kuti mutsegule menyu otsika;
  3. Dinani ku Sungani Monga mndandanda kuti mutsegule gulu la zosungira zosungira;
  4. Sankhani malo kapena dinani pakani Yang'anani kuti mutsegule bokosi la bokosi la Save As .
  5. Mu bokosi la bokosilo, landirani dzina la fayilo limene mwasankha kapena lembani dzina latsopano pa bukhuli ;
  6. Mu Save monga mndandanda wamndandanda, sankhani mafayilo apamwamba kuti mupulumutse fayilo;
  7. Dinani Pulumutsani kuti muzisunga fayiloyi muyipangidwe yatsopano ndikubwezera ku tsamba lomwe liripo.

Zindikirani: ngati mukusunga fayiloyi mu maonekedwe omwe sagwirizane ndi maonekedwe omwe ali nawo panopa, monga kupanga maonekedwe kapena ma fomu, bokosi la uthenga wochenjeza lidzawonekera kukudziwitsirani izi ndikukupatsani mwayi wotsutsa. Kuchita zimenezi kukubwezeretsani ku bokosi la bokosi la Kusunga.

Kutsegula ndi Kuzindikiritsa Mafayilo

Kwa ambiri ogwiritsira ntchito Windows , kugwiritsa ntchito kwakukulu ndi kupindula kwazowonjezera mafayilo ndikuti kumawalola kuti awonetse kawiri pa fayilo ya XLSX, kapena XLS ndipo dongosolo lothandizira lidzatsegula ku Excel.

Kuwonjezera apo, ngati mafayilo apamwamba akuwonekera , podziwa kuti ndizowonjezera ziti zomwe zimagwirizanitsidwa ndi mapulogalamu omwe angathandize kuti zikhale zovuta kuzindikira mafayilo mu My Documents kapena Windows Explorer.

Zithunzi Zopangira Faili XLTX ndi XLTM

Pamene fayilo yapamwamba imasungidwa ndi XLTX kapena extension XLTM imasungidwa ngati fayilo ya template. Mafayilo a ndemanga amayenera kugwiritsidwa ntchito ngati mafayilo oyambira kwa mabuku atsopano ndipo nthawi zambiri amakhala ndi masewero osungidwa monga tsamba losasinthika lamasamba pamabuku, zojambula, mafomu , zithunzi, ndi zida zamakono.

Kusiyanitsa pakati pazowonjezera ziwiri ndikuti XLTM mawonekedwe akhoza kusunga VBA ndi XML (Excel 4.0 macros) code macro.

Malo osungirako osungirako omwe ali opangira mafano ndi awa:

C: \ Users \ [UserName] \ Documents \ Custom Office Zithunzi

Kamodzi kachitidwe ka template kamangidwe, izo ndi zonse zomwe zakhazikitsidwa pambuyo pake zidzangowonjezeredwa m'ndandandanda wazithunzi zomwe zili pansi pa Faili> Chatsopano m'ma menus.

Kupatula kwa Macintosh

Ngakhale makompyuta a Macintosh sakudalira pazithunzi zazithunzi kuti mudziwe pulogalamu yomwe mungagwiritse ntchito potsegula fayilo, chifukwa chogwirizana ndi mawindo a Excel, mawonekedwe atsopano Excel kwa Mac - monga a 2008, gwiritsani ntchito fayilo ya XLSX powonjezera .

Kawirikawiri, maofesi a Excel omwe amapangidwa m'dongosolo lina lililonse akhoza kutsegulidwa ndi linalo. Chimodzi mwa izi ndi Excel 2008 ya Mac yomwe siidagwirizane ndi VBA macros. Chotsatira chake, sichikhoza kutsegula ma XLMX kapena XMLT mafayilo opangidwa ndi Mawindo kapena Mac Mac omwe amasintha pulogalamuyi yomwe imathandiza macro VBA.