Peb xa Excel nplooj ntawv mus rau Is Taws Nem, faib lawv, muab tso rau hauv nplooj ntawv web thiab ua rau lawv sib tham sib

Hauv ib qho ntawm cov ntawv, peb tau kawm txog cov txheej txheem los hloov cov nplooj ntawv Excel rau HTML. Niaj hnub no zoo li txhua leej txhua tus tab tom tsiv mus rau huab cia, yog li vim li cas peb thiaj li phem dua? Cov thev naus laus zis tshiab rau kev sib qhia Excel cov ntaub ntawv hauv Is Taws Nem yog txoj hauv kev yooj yim, nrog ntau yam nta thiab cov txiaj ntsig uas koj tuaj yeem siv.

Nrog rau qhov tshwm sim ntawm Excel Online, koj tsis tas yuav cumbersome HTML code los tshaj tawm cov ntawv nthuav dav hauv lub vev xaib. Tsuas txuag koj phau ntawv ua haujlwm hauv online thiab nkag mus rau nws los ntawm txhua qhov chaw, qhia rau lwm tus, thiab ua haujlwm ua ke ntawm tib daim ntawv nthuav qhia. Siv Excel Online, koj tuaj yeem kos ib daim ntawv Excel rau hauv lub vev xaib lossis blog thiab tso cai rau cov qhua tuaj yeem cuam tshuam nrog nws kom tau raws nraim cov ntaub ntawv lawv xav nrhiav.

Tom qab hauv tsab xov xwm no, peb yuav saib cov no thiab ntau lwm yam uas Excel Online muab.

• Uploading Excel 2013 Workbooks (Local) rau hauv Internet
• Tsim cov ntawv online hauv Excel Online
• Yuav ua li cas kho cov ntawv ua haujlwm hauv Excel Online
• Sib koom Excel Online Worksheets
• Yuav ua li cas thaiv kev kho cov hlwb uas nyiam hauv cov nplooj ntawv Excel sib koom
• Embedding Excel Web App hauv Lub Vev Xaib lossis Blog
• Excel Web App Mashups

Yuav Ua Li Cas Xa Cov Ntawv Excel 2013 rau hauv Web

Yog tias koj nyuam qhuav pib nrog cov kev pabcuam huab dav dav thiab Excel Online tshwj xeeb, ces qhov pib yooj yim yuav yog qhia cov ntawv ua haujlwm uas twb muaj lawm uas siv Excel 2013 paub hauv koj lub computer.

Txhua daim ntawv Excel Online tau khaws cia hauv OneDrive (yav tas los SkyDrive) lub vev xaib. Raws li koj paub, qhov kev cia online no tau nyob ib puag ncig tam sim no thiab tam sim no tau muab tso rau hauv Microsoft Excel raws li ib-nias interface hais kom ua. Tsis tas li ntawd, cov qhua, piv txwv li lwm cov neeg siv uas koj muab koj cov ntawv nthuav qhia tsis tas yuav tsum tau lawv tus kheej Microsoft account los saib thiab kho cov ntaub ntawv Excel uas koj qhia rau lawv.

Yog tias koj tseem tsis muaj OneDrive account, koj tuaj yeem tsim ib qho tam sim no. Qhov kev pabcuam no yooj yim, pub dawb thiab twv yuav raug hu tsim nyog rau koj vim tias feem ntau ntawm cov ntawv thov ntawm Microsoft Office 2013 suite (tsis yog Excel nkaus xwb) txhawb OneDrive. Tom qab sau npe, ua raws li cov kauj ruam no:

1. Nkag mus rau hauv koj tus account Microsoft

Xyuas kom tseeb tias koj tau kos npe rau hauv koj tus account Microsoft los ntawm Excel 2013. Qhib koj Excel workbook thiab saib nyob rau sab xis saum toj kawg nkaus. Yog tias koj pom koj lub npe thiab duab nyob ntawd, ces mus rau kauj ruam tom ntej, txwv tsis pub nyem Sau npe (Input).

Excel yuav tso saib lub qhov rais nug koj kom paub meej tias koj xav tso cai rau Office txuas rau Is Taws Nem. Nyem Yog (Yog) thiab tom qab ntawd sau koj cov ntaub ntawv Windows Live account.

2. Txuag koj daim ntawv Excel rau hauv huab

Nco ntsoov, rau koj tus kheej kev thaj yeeb ntawm lub siab, tias phau ntawv xav tau qhib, uas yog, raws nraim qhov koj xav qhia hauv Is Taws Nem. Kuv xav qhia ib phau ntawv Nyiaj so koobtsheej Listkom kuv tsev neeg thiab cov phooj ywg tau saib thiab pab 🙂

Thaum qhib phau ntawv ua haujlwm, mus rau lub tab Fillet (Cov ntaub ntawv) thiab nyem Qhia (Sib koom) ntawm sab laug ntawm lub qhov rais. Qhov kev xaiv ua ntej yuav yog Caw Tib Neeg (Caw lwm tus), ces koj yuav tsum nias Txuag rau Huab (Txuag rau Huab) ntawm sab xis ntawm lub qhov rais.

Tom qab ntawd, xaiv qhov chaw los khaws cov ntaub ntawv Excel. OneDrive tau teev ua ntej ntawm sab laug thiab raug xaiv los ntawm lub neej ntawd. Koj tsuas yog yuav tsum tau qhia kom meej cov nplaub tshev kom txuag tau cov ntaub ntawv nyob rau sab xis ntawm lub qhov rais.

Nco ntsoov: Yog tias koj tsis pom OneDrive cov ntawv qhia zaub mov, ces koj tsis muaj OneDrive account, lossis koj tsis tau kos npe rau hauv koj tus account.

Kuv twb tau tsim ib daim nplaub tshev tshwj xeeb Khoom plig Planner, thiab nws tau pom nyob rau hauv cov npe folders tsis ntev los no. Koj tuaj yeem xaiv lwm cov ntawv tais ceev tseg los ntawm nias lub pob PAWG (Cov ntsiab lus) hauv qab no cheeb tsam Tsis ntev los no Folders (Cov folders tsis ntev los no), lossis tsim ib lub nplaub tshev tshiab los ntawm txoj cai-nias thiab xaiv los ntawm cov ntawv qhia zaub mov Tshiab (Tsim) > nplaub tshev (folder). Thaum xaiv cov ntawv tais ceev tseg, nyem Txuag (Txuag).

3. Sib faib ib daim ntawv Excel Txuag rau hauv Web

Koj phau ntawv ua haujlwm Excel twb nyob online thiab koj tuaj yeem saib nws hauv koj OneDrive. Yog tias koj xav tau faib cov ntawv Excel khaws tseg hauv Is Taws Nem, ces koj tsuas yog yuav tsum ua ib kauj ruam - xaiv ib qho ntawm cov txheej txheem muab los ntawm Excel 2013 rau kev sib koom:

• Caw Tib Neeg (Caw lwm tus). Qhov kev xaiv no raug xaiv los ntawm lub neej ntawd. Tsuas yog nkag mus rau email chaw nyob ntawm tus neeg koj xav qhia daim ntawv Excel nrog. Thaum koj pib ntaus nws, Excel's autocomplete yuav sib piv cov ntaub ntawv koj tau nkag nrog cov npe thiab chaw nyob hauv koj phau ntawv chaw nyob thiab qhia koj cov npe ntawm cov kev xaiv sib xws los xaiv. Yog tias koj xav ntxiv ntau tus neeg sib cuag, nkag rau lawv sib cais los ntawm semicolons. Tsis tas li ntawd, koj tuaj yeem siv kev tshawb nrhiav cov neeg nyob hauv phau ntawv chaw nyob, ua qhov no, nyem lub cim Nrhiav Chaw Nyob Phau Ntawv (Nrhiav hauv phau ntawv chaw nyob). Koj tuaj yeem teeb tsa txoj cai nkag mus saib lossis kho los ntawm kev xaiv qhov kev xaiv tsim nyog los ntawm cov npe poob rau ntawm sab xis. Yog tias koj qhia ntau tus neeg sib cuag, ces qhov kev tso cai yuav raug teeb tsa rau tib yam rau txhua tus, tab sis tom qab ntawd koj tuaj yeem hloov qhov kev tso cai rau txhua tus neeg. Koj tseem tuaj yeem ntxiv cov lus ntawm tus kheej rau qhov kev caw. Yog tias koj tsis sau dab tsi, Excel yuav ntxiv cov lus qhia dav dav rau koj.

  Thaum kawg, koj yuav tsum xaiv seb tus neeg siv yuav tsum tau nkag mus rau hauv lawv lub Windows Live account txhawm rau nkag mus rau koj daim ntawv Excel online. Kuv tsis pom ib qho laj thawj tshwj xeeb rau yuam lawv ua qhov no, tab sis nws yog nyob ntawm koj.

  Thaum txhua yam npaj txhij, nias lub pob Qhia (General nkag). Txhua tus neeg caw yuav tau txais email uas muaj qhov txuas rau cov ntaub ntawv koj tau qhia. Txhawm rau qhib koj daim ntawv Excel online, tus neeg siv tsuas yog xav tau nyem rau ntawm qhov txuas

  

  Tom qab nias lub Qhia (Qhia), Excel yuav tso saib cov npe ntawm cov neeg koj tau qhia cov ntaub ntawv nrog. Yog tias koj xav tshem tawm ib qho kev sib cuag los ntawm cov npe lossis hloov kev tso cai, nyem rau ntawm lub npe ntawm tus neeg sib cuag no thiab xaiv qhov kev xaiv tsim nyog los ntawm cov ntawv qhia zaub mov.

  

• Tau txais Kev Sib Txuas Txuas (Tau qhov link). Yog tias koj xav muab kev nkag mus rau hauv online Excel daim ntawv rau ntau tus neeg, ces txoj hauv kev sai yog xa lawv mus rau cov ntaub ntawv, piv txwv li, los ntawm Outlook xa ntawv. Xaiv ib qho kev xaiv Tau txais Kev Sib Txuas Txuas (Get Link) nyob rau sab laug ntawm lub qhov rais, ob qhov txuas yuav tshwm rau sab xis ntawm lub qhov rais: Saib Txuas Ntawv (Txuas mus saib) thiab Kho qhov link (Txuas ntxiv rau kev kho). Koj tuaj yeem xa ib lossis ob qho tib si.
• Tshaj tawm rau Social Networks (Post rau Social Media). Lub npe ntawm qhov kev xaiv no hais lus rau nws tus kheej thiab tsis xav tau cov lus piav qhia ntxiv, tshwj tsis yog rau ib nqe lus. Yog tias koj xaiv txoj kev no, koj yuav tsis pom cov npe ntawm cov kev sib tham muaj nyob rau hauv txoj cai ntawm lub qhov rais. Nyem qhov txuas Nyem qhov no txhawm rau txuas kev sib tham (Ntxiv social networks) ntxiv koj cov nyiaj rau Facebook, Twitter, Google, LinkedIn, thiab lwm yam.
• Email (Xa los ntawm email). Yog tias koj xav xa Excel phau ntawv ua haujlwm raws li daim ntawv txuas (raws li Excel, PDF lossis XPS cov ntaub ntawv) lossis hauv Internet Fax, xaiv hom no ntawm sab laug ntawm lub qhov rais thiab qhov kev xaiv tsim nyog ntawm sab xis.

Tswv yim: Yog tias koj xav txwv thaj tsam ntawm Excel phau ntawv ua haujlwm uas pom tau los ntawm lwm tus neeg siv, qhib rau ntawm tab Fillet (Cov ntaub ntawv) ntu info (Cov ntsiab lus) thiab nias Browser Saib Options (Browser View Options). Ntawm no koj tuaj yeem teeb tsa cov nplooj ntawv twg thiab cov npe npe twg tuaj yeem tso tawm hauv lub vev xaib.

Yog tag nrho! Koj phau ntawv ua haujlwm Excel 2013 tam sim no online thiab muaj rau cov neeg siv xaiv. Thiab txawm tias koj tsis nyiam koom tes nrog leej twg, txoj kev no yuav tso cai rau koj nkag mus rau Excel cov ntaub ntawv los ntawm txhua qhov chaw, txawm tias koj nyob hauv chaw ua haujlwm, ua haujlwm hauv tsev lossis mus txawv tebchaws.

Ua haujlwm nrog phau ntawv ua haujlwm hauv Excel Online

Yog tias koj yog ib tus neeg muaj kev ntseeg siab ntawm Cloud Universe, koj tuaj yeem yooj yim paub Excel Online thaum koj noj su.

Yuav ua li cas los tsim ib phau ntawv ua haujlwm hauv Excel Online

Txhawm rau tsim ib phau ntawv tshiab, nyem lub xub me nyob ib sab ntawm lub pob tsim (Tsim) thiab xaiv los ntawm daim ntawv teev npe Excel phau ntawv ua haujlwm (Excel Phau Ntawv).

Txhawm rau hloov npe koj phau ntawv online, nyem rau ntawm lub npe qub thiab sau ib qho tshiab.

Txhawm rau rub tawm phau ntawv uas twb muaj lawm rau Excel Online, nyem upload (Upload) ntawm OneDrive toolbar thiab xaiv cov ntaub ntawv xav tau khaws tseg hauv koj lub computer.

Yuav ua li cas kho cov ntawv ua haujlwm hauv Excel Online

Tom qab koj qhib phau ntawv ua haujlwm hauv Excel Online, koj tuaj yeem ua haujlwm nrog nws siv Excel Web App (ib yam li Excel tau teeb tsa hauv lub khoos phis tawj tus kheej), piv txwv li sau cov ntaub ntawv, txheeb thiab lim, suav siv cov qauv, thiab pom cov ntaub ntawv siv kab kos.

Tsuas muaj ib qho tseem ceeb sib txawv ntawm lub vev xaib version thiab lub zos version ntawm Excel. Excel Online tsis muaj khawm Txuag (Txuag) vim nws txuag cov ntawv ua haujlwm tau txais. Yog tias koj hloov siab, nyem Ctrl + Ztshem tawm qhov kev txiav txim, thiab Ctrl + Yrov ua dua qhov kev ua tsis tiav. Rau tib lub hom phiaj, koj tuaj yeem siv cov nyees khawm undo (Cancel) / Redo (Rov qab) tab Tsev (Tsev) hauv ntu undo (Tau tseg).

Yog tias koj tab tom sim hloov qee cov ntaub ntawv, tab sis tsis muaj dab tsi tshwm sim, feem ntau yuav cov phau ntawv qhib hauv hom nyeem nkaus xwb. Txhawm rau kom hloov kho hom, nyem Tshawb Nrhiav Workbook (Hloov Phau Ntawv) > Hloov kho hauv Excel Web App (Hloov hauv Excel Online) thiab hloov pauv sai sai hauv koj lub vev xaib browser. Txhawm rau nkag mus rau ntau cov ntaub ntawv txheeb xyuas cov yam ntxwv xws li PivotTables, Sparklines, lossis txuas mus rau cov ntaub ntawv sab nraud, nyem Kho kom raug hauv Excel (Qhib hauv Excel) hloov mus rau Microsoft Excel ntawm koj lub computer.

Thaum koj khaws ib daim ntawv hauv Excel, nws yuav tau txais kev cawmdim nyob qhov twg koj tau tsim nws thawj zaug, uas yog, hauv OneDrive huab cia.

Tswv yim: Yog tias koj xav hloov pauv sai rau ntau phau ntawv, ces txoj hauv kev zoo tshaj yog qhib cov npe ntawm cov ntaub ntawv hauv koj OneDrive, nrhiav phau ntawv koj xav tau, nyem rau ntawm nws thiab xaiv qhov xav tau los ntawm cov ntawv qhia zaub mov.

Yuav Ua Li Cas Qhia Ib Daim Ntawv Ua Haujlwm nrog lwm tus neeg siv hauv Excel Online

Txhawm rau qhia koj daim ntawv ua haujlwm hauv Excel Online, nyem Qhia (Shared) > Qhia nrog Neeg (Share)…

… thiab tom qab ntawd xaiv ib qho ntawm cov kev xaiv:

• Caw Tib Neeg (Xa qhov txuas) - thiab nkag mus rau email chaw nyob ntawm cov neeg koj xav qhia phau ntawv nrog.
• Tau ib qhov txuas (Tau qhov txuas) - thiab txuas qhov txuas no mus rau email, tshaj tawm rau hauv lub vev xaib lossis hauv social networks.

Koj tuaj yeem teeb tsa txoj cai nkag mus rau cov neeg sib cuag: txoj cai saib nkaus xwb lossis tso cai rau hloov cov ntaub ntawv.

Thaum ntau tus neeg tab tom kho daim ntawv ua haujlwm tib lub sijhawm, Excel Online tam sim ntawd qhia lawv lub xub ntiag thiab hloov kho tshiab, yog tias txhua tus tab tom kho cov ntaub ntawv hauv Excel Online thiab tsis yog hauv Excel hauv zos hauv computer. Yog tias koj nyem rau ntawm tus xub me nyob ib sab ntawm tus neeg lub npe nyob rau sab xis saum toj kawg nkaus ntawm Excel daim ntawv, koj tuaj yeem pom cov xov tooj ntawm tus neeg tam sim no kho.

Yuav ua li cas thaiv kev kho ntawm qee lub hlwb ntawm ib daim ntawv sib koom

Yog tias koj tab tom sib koom cov ntawv ua haujlwm hauv online nrog koj pab neeg, tej zaum koj yuav xav muab kev tso cai rau lawv los kho qee lub hlwb, kab, lossis kab hauv koj daim ntawv Excel. Txhawm rau ua qhov no, hauv Excel ntawm lub khoos phis tawj hauv zos, koj yuav tsum xaiv qhov ntau (s) uas koj tso cai hloov kho, thiab tom qab ntawd tiv thaiv daim ntawv ua haujlwm.

1. Xaiv ntau lub hlwb uas koj cov neeg siv tuaj yeem hloov kho, qhib lub tab Review (Saib xyuas) thiab hauv seem kev hloov (Hloov) nyem Tso Cai Rau Cov Neeg Siv Hloov Kho Ntau Yam (Tso cai hloov ntau yam).
2. Nyob rau hauv lub dialog box Tso Cai Rau Cov Neeg Siv Hloov Kho Ntau Yam (Tso cai hloov pauv) nyem lub pob Tshiab (Tsim), kom paub tseeb tias qhov ntau yog qhov tseeb thiab nyem Tiv Thaiv Daim Ntawv (Cov ntawv tiv thaiv). Yog tias koj xav tso cai rau koj cov neeg siv hloov kho ntau yam, ces nyem lub pob dua. Tshiab (Tsim).
3. Sau koj tus password ob zaug thiab upload daim ntawv ruaj ntseg rau OneDrive.

Yog xav paub ntxiv txog qhov no, thov nyeem tsab xov xwm Xauv thiab qhib qhov chaw tshwj xeeb ntawm daim ntawv tiv thaiv.

Yuav Ua Li Cas Embed Excel Sheet hauv Lub Vev Xaib lossis Blog

Yog tias koj xav tshaj tawm koj phau ntawv ua haujlwm Excel rau lub vev xaib lossis blog, ua raws li 3 kauj ruam yooj yim hauv Excel Web App:

1. Qhib phau ntawv ua haujlwm hauv Excel Online, nyem Qhia (Shared) > Embed (embed), ces nias lub pob tsim (Tsim).
2. Hauv cov kauj ruam tom ntej, koj txhais raws nraim li cas daim ntawv yuav tsum saib hauv lub vev xaib. Cov kev xaiv hauv qab no muaj rau koj:
   • Dab tsi los qhia (Dab tsi yuav tsum tau qhia). Hauv seem no, koj tuaj yeem hais qhia seb koj puas xav embed tag nrho phau ntawv ua haujlwm lossis tsuas yog ib feem ntawm nws, xws li ntau lub hlwb, lub rooj pivot, thiab lwm yam.
   • tsos (Qhov tshwm sim). Ntawm no koj tuaj yeem hloov kho cov duab ntawm phau ntawv (qhia lossis zais kab kab, kab thiab kab kab, suav nrog qhov txuas txuas).
   • sis (Kev sib tham). Tso cai lossis tsis tso cai rau cov neeg siv cuam tshuam nrog koj lub rooj - txheeb, lim thiab nkag mus rau hauv cov ntaub ntawv. Yog tias koj tso cai rau cov ntaub ntawv nkag, ces cov kev hloov pauv los ntawm lwm tus neeg hauv cov hlwb hauv Is Taws Nem yuav tsis raug khaws cia hauv phau ntawv ua haujlwm qub. Yog tias koj xav kom qhib lub xov tooj tshwj xeeb thaum qhib nplooj ntawv web, kos lub thawv Ib txwm pib nrog lub xovtooj ntawm no xaiv (ib txwm pib los ntawm lub xovtooj ntawm no) thiab nyem qhov xav tau ntawm tes hauv cheeb tsam saib ua ntej (Saib ua ntej), uas nyob rau sab xis ntawm lub dialog box.
   • Qhov ntev (Dimensions). Nkag mus rau ntawm no qhov dav thiab qhov siab ntawm lub rooj qhov rai hauv pixels. Txhawm rau pom qhov tseeb qhov ntev ntawm lub qhov rais, nyem Saib qhov loj me (qhov tseeb saib loj) saum lub qhov rais saib ua ntej (Saib ua ntej). Nco ntsoov tias koj tuaj yeem teeb qhov loj me kom tsawg kawg yog 200 x 100 pixels thiab ntau tshaj 640 x 655 pixels. Yog tias koj xav tau kom tau txais qhov sib txawv me me uas dhau mus dhau qhov kev txwv no, tom qab ntawd koj tuaj yeem hloov cov cai hauv ib qho HTML editor, ncaj qha rau ntawm koj qhov chaw lossis blog.
3. Txhua yam koj tau ua yog nyem Copy (Copy) hauv qab no Embed code (embed code) thiab muab tshuaj txhuam HTML (lossis JavaScript) code rau hauv koj qhov blog lossis lub vev xaib.

Nco ntsoov: Lub embed code yog ib qho iframe, yog li xyuas kom tseeb tias koj lub vev xaib txhawb qhov cim npe no thiab koj qhov blog tso cai rau nws siv hauv cov ntawv tshaj tawm.

Embedded Excel Web App

Qhov koj pom hauv qab no yog daim ntawv sib tham sib Excel uas qhia txog cov txheej txheem piav qhia hauv kev nqis tes ua. Cov lus no suav tias tshuav pes tsawg hnub kom txog rau thaum koj lub hnub yug tom ntej, hnub tseem ceeb, lossis qee qhov xwm txheej, thiab xim qhov khoob ntawm ntau qhov ntxoov ntsuab, daj, thiab liab. Hauv Excel Web App, koj tsuas yog yuav tsum nkag mus rau koj cov xwm txheej hauv thawj kab, tom qab ntawd sim hloov cov hnub sib xws thiab pom cov txiaj ntsig.

Yog tias koj xav paub txog cov qauv siv ntawm no, thov saib cov lus Yuav ua li cas teeb tsa hnub tim formatting hauv Excel.

Tus neeg txhais lus ceeb toom: Hauv qee qhov browsers, iframe no yuav tsis tso tawm kom raug lossis tsis tag nrho.

Mashups hauv Excel Web App

Yog tias koj xav tsim kom muaj kev sib raug zoo ntawm koj lub vev xaib Excel thiab lwm lub vev xaib lossis cov kev pabcuam, koj tuaj yeem siv JavaScript API muaj nyob rau ntawm OneDrive los tsim kev sib tham sib mashups los ntawm koj cov ntaub ntawv.

Hauv qab no koj tuaj yeem pom Destination Explorer mashup tsim los ntawm pab pawg Excel Web App ua piv txwv ntawm cov neeg tsim khoom tuaj yeem tsim rau koj lub vev xaib lossis blog. Qhov mashup no siv Excel Services JavaScript thiab Bing Maps APIs los pab cov neeg tuaj saib lub vev xaib xaiv txoj hauv kev mus ncig. Koj tuaj yeem xaiv qhov chaw nyob ntawm daim ntawv qhia thiab lub mashup yuav qhia koj cov huab cua ntawm qhov chaw ntawd lossis tus naj npawb ntawm cov neeg tuaj ncig tebchaws tuaj xyuas cov chaw ntawd. Cov screenshot hauv qab no qhia peb qhov chaw 🙂

Raws li koj tuaj yeem pom, ua haujlwm hauv Excel Online yog qhov yooj yim heev. Tam sim no peb tau hais txog cov hauv paus, koj tuaj yeem tshawb xyuas nws cov yam ntxwv thiab ua haujlwm nrog koj cov nplooj ntawv yooj yim thiab ntseeg siab!