Cov txheej txheem:

Kuv yuav tsim cov ntaub ntawv XLSB li cas?
Kuv yuav tsim cov ntaub ntawv XLSB li cas?

Video: Kuv yuav tsim cov ntaub ntawv XLSB li cas?

Video: Kuv yuav tsim cov ntaub ntawv XLSB li cas?
Video: txiv tham maum txiab (maiv lis lauj & npawglem new song nkauj tawm tshiab) funny song 2024, Kaum ib hlis
Anonim
  1. Kauj ruam 1: Qhib Developer tab hauv Excel: Hauv Excel xaiv: Cov ntaub ntawv . Kev xaiv.
  2. Kauj ruam 2: Sau cov macro tsim tus kheej. XLSB tsev qiv ntawv: Koj yuav xav tau ua a macro uas yuav tsim tus kheej. xlsb ib tsev qiv ntawv.
  3. Kauj ruam 3: Luam cov macros peb tau muab rau hauv XLSB tsev qiv ntawv. Rov qhib Excel. Nyem rau ntawm Developer Tab.

Ib yam li ntawd, XLSB file format yog dab tsi?

A ntaub ntawv nrog rau XLSB file extension yog Excel Binary Workbook ntaub ntawv . Lawv khaws cov ntaub ntawv hauv binary hom ntawv hloov XML zoo li nrog rau feem ntau lwm Excel cov ntaub ntawv (xws li XLSX). Txij li thaum XLSB files yog binary, lawv tuaj yeem nyeem los ntawm thiab sau kom nrawm dua, ua rau lawv siv tau zoo heev rau cov ntawv loj loj.

Ib yam li ntawd, qhov txawv ntawm XLSB thiab XLSX yog dab tsi? Tus yuam sij qhov sib txawv ntawm XLSB thiab XLSX - XLSMis uas cov ntaub ntawv nyob rau hauv lub pob zipped yog compressed binarycomponents (.bin) encoded hauv a hom ntawv tswv, tsis yog nyeem tau XML code. Cov ntaub ntawv binary tau ua kom zoo rau kev ua tau zoo thiab tuaj yeem khaws txhua yam koj tuaj yeem tsim hauv Excel.

Tom qab ntawd, ib tus tuaj yeem nug, kuv tus kheej cov ntaub ntawv XLSB nyob qhov twg?

Sib koom macro Yog tias koj xav qhia koj Tus kheej . xlsbfile nrog rau lwm tus, koj tuaj yeem luam nws mus tus XLSTART folders rau lwm lub computer. Hauv Windows 10, Windows 7, thiab Windows Vista, phau ntawv no tau khaws cia rau hauv tus C:UsersusernameAppDataLocalMicrosoftExcelXLStart folder.

Kuv yuav ua li cas thiaj pab tau tus kheej phau ntawv ua haujlwm hauv Excel?

Ua raws li cov kauj ruam no:

  1. Tso saib Excel Options dialog box.
  2. Nyem Ntxiv-Ins ntawm sab laug ntawm lub dialog box.
  3. Siv cov Tswj cov npe teev tseg (hauv qab ntawm lub thawv sib tham), xaiv Cov Khoom Tsis Taus.
  4. Nyem rau khawm mus.
  5. Yog tias Phau Ntawv Qhia Txog Tus Kheej tau teev tseg tias yog neeg xiam oob qhab, xaiv nws thiab tom qab ntawd nyem Enable.
  6. Kaw tag nrho cov qhib dialog boxes.

Pom zoo: