Ukukhipha i-SharePoint kuya ku-Excel: ukuvuselelwa kusebenza kuphi ngempela

Ukukhipha kuya ku-Excel kukhiqiza izinto ezintathu ezihlukene kuye ngokufakwa, futhi iphutha lingelinye lazo ngqo. Ifayela lombuzo elandisiwe, i-CSV emile kanye nethebula elixhunyiwe elivuselekayo akusona umphumela ofanayo, futhi ngayinye yehluleka esigabeni esihlukile. Ukwazi ukuthi iyiphi into onayo kunquma ukuthi isinyathelo esilandelayo ngesethimba lenethiwekhi, isethimba lobunikazi noma umnikazi wohlu. Indlela engezansi ilandela ukudluliswa kusuka kusiphequluli kuya esicelweni sika-Excel uqobo.

Ukukhipha kudlulisela ini ngempela

Kuhlu lwe-SharePoint lwendabuko, Khiphela ku-Excel kulandisa ifayela elincane lombhalo umzimba walo oyi-URL, bese i-Excel ifunda lelo fayela futhi ithumele isicelo sayo sedatha engemuva kwalo. Ifayela elandisiwe liyinkomba, hhayi uhlu. Ngakolunye uhlangothi, ukukhipha kwe-CSV kuqukethe imigqa uqobo futhi akunaso isixhumanisi sokuvuselela. Ithebula elisha elixhunyiwe lingafaka umbuzo ngqo encwadini yokusebenza, ngakho akukho lutho olufika kufolda yezokulanda.

Zonke izimo ezixhunyiwe zihamba ohlangothini olulodwa. Ukuvuselela kudonsa imigqa yamanje kusuka ohlwini kuyise encwadini yokusebenza, futhi ukuhlela ithebula akubuyiseli lutho emuva. Lokho kungalingani kubalulekile ekuxilongeni, ngoba incwadi yokusebenza evuleka nemigqa yesonto eledlule isivele yafakaza ukuthi ifayela likhona nokuthi isixhumanisi sagcinwa, kodwa ayisho lutho mayelana nokuthi ukuvuselela kuyasebenza yini namuhla.

Ngakho umbuzo wokuqala awuwona wokuthi kungani ukukhipha kwehlulekile, kodwa ukuthi iyiphi into umsebenzisi ayeyilindele. Impendulo inciphisa uphenyo lube ngenye yezinqubo ezintathu.

Izinqubo ezintathu, ubunikazi obuthathu obuhlukene

Ukulanda kusiphequluli kusebenzisa isikhathi sesiphequluli, namakhukhi aso, ukumiswa kweproksi kanye nesimo sokungena. I-Excel lapho ivula ifayela isebenzisa inqwaba ye-HTTP ye-Office, okuvamise ukulandela iproksi yezinketho ze-Inthanethi kumsebenzisi ngamunye esikhundleni sesilungiselelo se-WinHTTP somshini wonke, futhi eqinisekisa ngobunikazi be-Office umsebenzisi anabo. Ukuvuselela kwakamuva kusebenzisa kabusha isixhumanisi esigciniwe futhi kungase kuthathe izifakazelo ezigcinwe kusikhashana ku-Silawuli Sezifakazelo se-Windows esikhundleni sokubuza.

Lezo zimo ezintathu zingase zingavumelani emshinini owodwa, yingakho isiphequluli esivula uhlu kahle nokuvuselela kwe-Excel okubuyisela isicelo sokungena kuwumphumela ohambisanayo hhayi ukuphikisana. Umhubhe ushintsha umzila womshini kuzo zontathu, kodwa ifayela lokumiswa okuzenzakalelayo kweproksi lisengathumela izicelo ze-Office kwenye indawo.

Rekhoda ubunikazi obusetshenziswa esigabeni ngasinye ngaphambi kokushintsha noma yibuphi kubo. Ukulungiswa okusetshenziswe kusiphequluli akukwazi ukulungisa isicelo i-Excel esenzayo ngaphansi kwe-akhawunti ehlukile.

Funda ifayela lokudluliswa ngaphambi kokushintsha noma yini

Ifayela elandisiwe lingumbhalo ocacile futhi ngokuvamile lifushane, ngakho lifunde kuqala. Lisho ihhosti nendawo yokugcina i-Excel ezoyishaya, futhi leyohhosti iyona okufanele ixazululwe futhi iqinisekiswe kusuka emshinini womsebenzisi, hhayi ngempela ikheli elibonakala kubha yamakheli yesiphequluli.

Get-Content "$env:USERPROFILE\Downloads\query.iqy"
Resolve-DnsName team.example.net
netsh winhttp show proxy

Qhathanisa ihhosti efayeleni nesayithi umsebenzisi acabanga ukuthi ukhiphe kulo. Ukuqondiswa kabusha ngesikhathi sokukhipha, iqoqo lesayithi elidala noma uhlu olufudusiwe kungase kushiye inkomba egondile egameni elingasanikezi idatha, futhi iphutha elivela kulokho libonakala njengokwehluleka kwenethiwekhi. Uma igama lixazululeka futhi indawo yokugcina iphendula, abangeneleli abasele ukuhlolwa kobunikazi kanye nombuzo uqobo.

Ungashintshi igama lehhosti ngekheli le-IP ukuze lisebenze. Lokho kwephula ukuhlolwa kwegama lesitifiketi futhi kufihla inkinga yangempela ngemuva kwendlela yokweqa ezoze yehluleke ekunwetshweni kwesitifiketi okulandelayo.

Hlukanisa ukwehluleka kwegama, kokungena nokombuzo

Imiphumela emine ihlanganisa cishe yonke imibiko, futhi ngayinye inomnini ohlukile. Igama elingaxazululeki lingelika-DNS. Isixhumanisi esiphelelwa yisikhathi singelomzila noma iproksi. Isicelo sokungena noma u-401 singelobunikazi. Impendulo efikayo kodwa engakwazi ukuhlaziywa ingelombuzo noma ingelendawo yokugcina uhlu oluyidalulayo manje.

Umugqa wokugcina yiwo abantu abaxilonga kabi. Ukuvuselela okuqedayo futhi kubuyisele imigqa engalungile sekufakaze ukuthi zonke izingqimba zenethiwekhi nobunikazi ziyasebenza, futhi umbuzo osele ukuthi yikuphi ukubuka noma yisiphi isihlungi umbuzo oziphethe. Ukuthumela lelo thikithi esethimbeni lenethiwekhi kuwukuchitha usuku.

Gcina umbhalo oqondile wephutha kanye nesikhathi sokwehluleka kokuqala. Yikho okunquma ukuthi ukumugqa wamaphi wethebula, futhi yiwona kuphela ubufakazi umnikazi wohlu angasebenza phezu kwabo.

Phinda uhlole ukuvuselela ohlwini olufanayo

Lapho isigaba esihlulekile sesitholiwe, phinda umsebenzi ohlulekile hhayi oshibhile. Vuselela uhlu olufanayo kusuka endaweni ye-Excel ehlosiwe, nge-akhawunti elindelekile kanye nomzila wenethiwekhi ogunyaziwe, futhi qinisekisa ukuthi inani lemigqa noma inani elaziwayo elishintshile liyavuseleleka ngempela. Ukuvula incwadi yokusebenza egciniwe akufakazi lutho mayelana nesixhumanisi.

Melana nokulungiswa okubanzi: ukususa zonke izifakazelo ezigciniwe, ukusebenzisa i-Office ngamalungelo aphezulu noma ukukhubaza isici sokuphepha kungase kushintshe uphawu ngaphandle kokulungisa isigaba. Uma ukuhlolwa kobunikazi kuyizingqimba ehlulekile, cela umnikazi wohlu aqinisekise i-akhawunti kanye nokugeleza kokungena okusekelwayo esikhundleni sokuqagela kuklayenti.

Nikeza i-CSV kuphela lapho isithombe esinqanyuliwe sanelisa umsebenzi futhi lokho kukhipha kusekelwa endaweni. Ukushintsha ifomethi yokukhipha kushintsha ukuhamba komsebenzi futhi akuchazi ukuthi kungani umsebenzi oxhunyiwe wayeka ukusebenza.