KHUTHAZA IZISOMBULULO zeExcel yokungenisa iApp
Ilungelo lokushicilela
Ilungelo lokushicilela © 2022 Boost Solutions Co., Ltd. Onke amalungelo agciniwe.
Zonke izinto eziqulethwe kolu papasho zikhuselwe yi-Copyright kwaye akukho nxalenye yolu papasho inokuphinda iveliswe, iguqulwe, iboniswe, igcinwe kwinkqubo yokubuyisela, okanye ihanjiswe ngayo nayiphi na indlela okanye ngayo nayiphi na indlela, i-elektroniki, i-mechanical, ifotokopi, ukurekhodwa okanye ngenye indlela, ngaphandle kwemvume ebhaliweyo yeBoost Solutions.
Yethu web indawo: http://www.boostsolutions.com
Intshayelelo
I-SharePoint Excel Import App ivumela abasebenzisi beshishini ukuba bangenise nayiphi na i-spreadsheet ye-Excel (.xlsx, .xls, okanye .csv file) kuluhlu lweSharePoint kwi-Intanethi kunye nemimandla yedatha yemephu ngesandla okanye ngokuzenzekelayo.
Ukusebenzisa i-Excel yokungenisa i-App, abasebenzisi banokungenisa idatha kwiindidi ezininzi ezakhelwe ngaphakathi kwiikholamu ze-SharePoint, kubandakanywa umgca omnye weSibhalo, iiNdlela ezininzi zeTeksti, ukhetho, inombolo, umhla kunye nexesha, iMali, abantu okanye iQela, ukuKhangela, Ewe / Hayi kunye I-Hyperlink okanye iMifanekiso.
Esi sikhokelo somsebenzisi sisetyenziselwa ukuyalela umsebenzisi ngendlela yokusebenzisa le app.
Ngekopi yamva nje yale kunye nezinye izikhokelo, nceda undwendwele:
http://www.boostsolutions.com/download-documentation.html
Uyisebenzisa njani iExcel yokungenisa iApp
Thatha ngaphandle iSpreadsheet
Ukungenisa i-Spreadsheet, kufuneka okungenani ube ne-Items kwaye uHlele iimvume ze-Items kuluhlu okanye ube lilungu leqela le-SharePoint Online elinokongeza izinto kunye neemvume ze-Items kuluhlu.
- Ngenisa uluhlu ofuna ukurhweba ngaphandle kulo ispredishithi. (Faka isiqulathi seefayili esikhethekileyo, ungangenisa ngaphandle i-aspreadsheet kwisiqulathi seefayili.)
- Cofa ukungenisa i-Excel kwibar yesenzo ephezulu. (I-Excel yokuthatha ngaphandle ayifumaneki kumava e-SharePoint yakudala.)
- Kwibhokisi yencoko yababini ye-Excel, kwi-Ngenisa kwi-Spreadsheet icandelo, tsala i-Excel file ujonge ukungenisa kwindawo yebhokisi enamachokoza (okanye nqakraza Tsala kwaye ulahle okanye nqakraza apha ukukhetha iExcel file ukukhetha i-Excel okanye i-CSV file).
- Kanye ngeExcel file ilayishiwe, amaphepha aqukiweyo aya kulayishwa kwaye afumaneke ukuba angeniswe. Kwicandelo lePhepha, khetha iphepha ofuna ukulingenisa ngaphandle.
Sebenzisa uKhetho lokutsiba umqolo weheader kwi-Excel ukwenza isigqibo sokuba ungangenisa okanye hayi umqolo wokuqala. Olu khetho lwenziwe ngokungagqibekanga kwaye lunokuvalwa ngesandla ukuba awunazo izihloko zentsimi kumqolo wokuqala okanye ukuba awufuni ukusebenzisa umqolo wokuqala njengezihloko zomhlaba.
- Kwicandelo leMaphu yeKholamu, khetha iikholamu kwi-Excel kwaye imephu yazo ukudwelisa iikholamu.
Ngokungagqibekanga, iikholamu ezinegama elifanayo ziya kwenziwa ngokuzenzekelayo nanini na iphepha lilayishiwe. Ukongeza, iikholamu ezifunekayo ziya kumakishwa ngeenkwenkwezi ezibomvu kwaye zikhethwe ngokuzenzekelayo.
- Kwicandelo Lokucoca, khetha uluhlu lwedatha kwaye ungenise idatha oyifunayo. Ukuba awukhethi olu khetho, yonke imiqolo ekwi-Excel sheet iya kuthathwa ngaphandle.
Ukuba ukhetha ibhokisi yokukhangela ecaleni kwe Rhweba ngaphandle ukusuka [] ukuya [] ukhetho, kwaye ukhankanye uluhlu lwedatha olunje ngokusuka kumqolo wesi-2 ukuya kumqolo wesi-8, ke yimigca exeliweyo kuphela eya kuthathwa ngaphandle kuluhlu. 
- Kwicandelo loKhetho lokuNgenisa, cacisa ukuba ufuna ukuhlaziya uluhlu lwe-SharePoint usebenzisa i-Excel file.
Ukungenisa okokuqala, akuyomfuneko ukukhetha olu khetho.
Kodwa ukuba sele ungenisile idatha ngaphambili, unokufuna ukwenza isigqibo sokuba leliphi inyathelo ekufuneka lithathwe ukuba iimpinda zifunyenwe xa ungenisa i-Excel kwi-SharePoint.
Phambi kokwenza oku, kufuneka wenze ukuba Jonga iirekhodi eziphindwe kabini xa ungenisa ukhetho.
Iirekhodi eziphindwe kabini zinokubakho kuzo zombini uluhlu lwe-SharePoint kunye ne-Excel Sheet. Ukuze kujongwe iirekhodi eziphindwe kabini, kufuneka kucaciswe iSitshixo ukuze kuchongwe iirekhodi eziphindiweyo.
Ikholamu ephambili yenye echonga ngokukodwa iirekhodi phakathi kwe-Excel kunye noluhlu lwe-SharePoint (njengekholamu ye-ID). Ungakhankanya ngaphezu kweminye imiqolo yesitshixo.
Phawula
Kuphela yimiqolo ekhethiweyo kwicandelo leMaphu yeKholam enokusetyenziswa njengoluhlu oluphambili.
Le mihlathi inokusetwa njengemiqolo engundoqo: Umgca omnye wokubhaliweyo, ukhetho, inani, umhla kunye nexesha, imali kunye no-Ewe/Hayi.
Nje ukuba i-Check duplicate iirekhodi xa ukhetho lokungenisa elizweni luvuliwe, kukho izenzo ezimbini ezinokuthathwa ukuba kukho naziphi na iikopi ezifunyenweyo xa ungenisa i-Excel kuluhlu.
- Tsiba iirekhodi eziphindiweyo
I-Excel Import App ithelekisa amaxabiso ekholamu ephambili kwi-Excel kunye ne-SharePoint yoluhlu lwe-Intanethi, ukuba amaxabiso ayafana kumacala omabini, iirekhodi ziya kuchongwa njengempinda.
Idatha echongwe njengeerekhodi eziphindwe kabini kwi-spreadsheet ye-Excel iya kutsitywa xa ithathwa ngaphandle kwaye kuphela iirekhodi ezizodwa eziseleyo ziya kuthunyelwa ngaphandle. - Hlaziya iirekhodi eziphindiweyo
I-Excel Import App ithelekisa amaxabiso eKholamu ePhambili kwi-Excel kunye ne-SharePoint yoluhlu lwe-Intanethi, ukuba amaxabiso ayafana kumacala omabini, iirekhodi ziya kuchongwa njengempinda.
Kwiirekhodi eziphindwe kabini, i-Excel Import App iya kuhlaziya ulwazi kwiirekhodi eziphindwe kabini kwi-SharePoint Online list kunye nolwazi oluhambelanayo kwi-spreadsheet ye-Excel. Emva koko, idatha eseleyo ye-spreadsheet iya kuthathwa njengeerekhodi ezintsha kwaye ingeniswe ngokufanelekileyo.
Phawula
Ukuba ikholomu engundoqo ayifani ne-Excel okanye uluhlu, iirekhodi eziphindwe kabini ziya kugqithwa.
UmzekeloampLe, ucinga ukuba usete ikholamu ye-ID yoMyalelo njengesitshixo:
Ukuba kukho iirekhodi ezininzi kwi-Excel ngexabiso elifanayo leKholam ye-ID ye-Order, ezi rekhodi ziya kuchongwa njengeziphindaphinda kwaye zeqiwe.
Ukuba kukho iirekhodi ezininzi ezinexabiso elifanayo lekholamu ye-ID ye-Order kuluhlu, iirekhodi ezikuluhlu ziya kuchongwa njengento ephindwe kabini kwaye igqitywe. - Kwaye emva koko ucofe iqhosha lokurhweba ngaphandle.
- Emva kokuba inkqubo yokungenisa elizweni igqityiwe, ungabona iziphumo zokungenisa njengezilandelayo. Cofa i Vala iqhosha ukuphuma.
Kuluhlu, uya kufumana ukuba zonke iirekhodi ze-Excel file zingeniswe kuluhlu njengokulandelayo.
Uninzi lweekholamu ze-SharePoint ezidumileyo zixhaswa yi-Excel Import App, kubandakanywa umgca omnye weTeksi, iMilayini emininzi yeTeksi, ukhetho, inombolo, umhla kunye nexesha, imali, abantu okanye iQela, ukukhangela, Ewe / Hayi kunye ne-Hyperlink okanye iMifanekiso. Unokwenza imephu ye-Excel ikholamu kwezi kholamu zeSharePoint xa ungenisa i-Excel file.
Nangona kunjalo, kwezinye iindidi zekholamu, kukho iingcebiso ekufuneka uzikhathalele:
Ukukhetha
Ikholomu yokukhetha yikholomu eyakhelweyo ye-SharePoint Online enexabiso elichazwe ngaphambili, ukungenisa amaxabiso kulo hlobo lwekholomu, kufuneka uhlolisise kwaye uqinisekise ukuba ixabiso kunye necala lifana ne-Excel kunye noluhlu.
Ukungenisa amaxabiso amaninzi kuluhlu loKhetho, amaxabiso kufuneka ahlulwe ngesiphumlisi ",".
UmzekeloampLe, amaxabiso oluhlu lwekholamu kufuneka yahlulwe ngo "," njengokulandelayo, ngoko ke inokungeniswa ngaphandle ngempumelelo.
IKholam yokukhangela
Ukungenisa ixabiso kwikholomu ye-SharePoint Lookup, ifuna ixabiso libe ngumbhalo okanye inani. Ithetha ikholamu ekhethiweyo ye Kulo kholamu kufuneka ibe ngumgca omnye wokubhaliweyo okanye umhlathi weNani. 
Ukuba uceba ukungenisa amaxabiso amaninzi kwikholamu yoKhetho, amaxabiso kufuneka ahlulwe ngu ";".
Umzekeloample, amaxabiso aMatyala aNxulumeneyo ikholam kufuneka ahlulwe ngu ";" njengokulandelayo, ngoko banokungeniswa kumhlathi wokuJonga ngempumelelo. 
IKholam yomntu okanye yeQela
Ukungenisa amagama kuMntu we-SharePoint okanye ikholamu yeQela, igama lomsebenzisi kwi-Excel kufuneka libe ligama lokungena, igama lokubonisa okanye idilesi ye-imeyile; Ukuba ufuna ukungenisa amaxabiso amaninzi kulo mhlathi, amaxabiso kufuneka ahlulwe ngu ";".
UmzekeloampLe, igama elibonisiweyo okanye idilesi ye-imeyile njengoko kubonisiwe kumzobo ongezantsi ingangeniswa ngempumelelo kuMntu okanye kuKholam weQela. 
IsiHlomelo 1: ULawulo lokuBhalisa
Unokusebenzisa ubhaliso lwesilingo se-Excel yokungenisa i-App kangangexesha leentsuku ezingama-30 ukusukela kusuku owalusebenzisa ngalo okokuqala.
Ukuba ixesha lobhaliso lolingo liyaphela, kuya kufuneka uthenge umrhumo.
Ubhaliso lwe-Excel Import App lukwindawo nganye (eyayibizwa ngokuba “yingqokelela yesiza”) okanye umqeshi ngonyaka.
Ukubhaliswa kokuqokelela indawo, akukho mda womsebenzisi wokugqibela. Bonke abasebenzisi abakwingqokelela yesiza banokufikelela kwi-app.
Ukubhaliswa komqeshi, akukho sayithi okanye umda wokuqokelela indawo. Bonke abasebenzisi banokufikelela kwi-app kuzo zonke iisayithi okanye ingqokelela yesayithi ngaphakathi komqeshi omnye.
Ijonga Isimo Somrhumo
- Xa uvula incoko yababini ye-Excel yokungenisa, isimo somrhumo siya kuboniswa ngaphezulu kwencoko yababini.
Xa umrhumo sele uza kuphelelwa kwiintsuku ezingama-30, umyalezo wesaziso uya kuhlala ubonisa iintsuku eziseleyo.
- Ukuhlaziya ubume bomrhumo, nceda ubeke imouse kumyalezo wesaziso kwaye ucofe kuwo, emva koko imeko entsha iya kulayishwa.
Ukuba imeko yokubhalisa ayitshintshi, nceda ucime i-cache ye-browser kwaye ucofe kwakhona.
- Nje ukuba imeko yobhaliso ijike kubhaliso lwakho alusebenzi njengokulandelayo, oko kuthetha ukuba umrhumo wakho uphelelwe lixesha.
- Nceda usithumele (sales@boostsolutions.com) indawo URL ukuqhubeka nomrhumo okanye ukuhlaziya.
Ukufumana iNgqokelela yeSiza URL
- Ukufumana indawo (eyayibizwa ngokuba yingqokelela yesiza) URLNONE
Cofa indawo ukuze uvule ifestile enezicwangciso zesayithi. Kwithebhu ngokubanzi, cofa Hlela ikhonkco kwaye emva koko ungafumana indawo URL.
Ukuba indawo yakho URL utshintsho, nceda usithumelele entsha URL ukuhlaziya umrhumo.
Ukufumana isazisi soMqeshi
- Ukufumana isazisi somqeshi, nceda uqale uye kwiziko lolawulo leSharePoint.
- Ukusuka kwiziko lolawulo lwe-SharePoint, cofa kwikhonkco leempawu ezingakumbi ukusuka ekhohlo lokukhangela, kwaye emva koko ucofe iqhosha lokuvula phantsi kwee-Apps.
- Kwiphepha elithi Lawula ii-Apps, cofa kwi-More features link ukusuka kukhangelo lwasekhohlo.
- Kwaye emva koko ucofe iqhosha lokuvula phantsi kweemvume ze-App.
- Iphepha leeMvume ze-App lidwelisa zonke ii-apps, kuquka igama le-app ebonisiweyo kunye neziphawuli ze-app. Kuluhlu lweSichongi se-App, indawo emva kwesimboli ye-@ yi-ID yakho yoMqeshi.
Nceda usithumele (sales@boostsolutions.com) i-ID yomqeshi ukuze uqhube umrhumo okanye uhlaziyo.
Okanye unokufumana i-ID yomqeshi nge-portal ye-Azure. - Sayina ungene kwi-Azure portal.
- Khetha i-Azure Active Directory.
- Khetha iinkcazelo ngeempawu.
- Emva koko, skrolela ezantsi kwindawo ye-ID yoMqeshi. Ungasifumana isazisi somqeshi kwibhokisi.
Amaxwebhu / Izibonelelo
 |
KHUTHAZA IZISOMBULULO zeExcel yokungenisa iApp [pdf] Isikhokelo somsebenzisi I-Excel yokuNgenisa i-App, iNgeniso ye-Excel, iNgeniso ngaphandle, i-Excel, i-App |
