Tsala idatha ngokukhawuleza kwifayile yePDF, uyilayishe kwiphepha le-Excel, kwaye wandise imveliso yakho.
Ukuba unayo nayiphi na idatha kwiPDF, efana nesiteyitimenti sakho sebhanki okanye enye idatha yezemali, kwaye ufuna ukuyingenisa kwifayile ye-Excel, akukho mfuneko yokuba ujonge naluphi na usetyenziso lomntu wesithathu. Unokusebenzisa i-PDF Data Connector, esisixhobo esakhiwe kuMicrosoft Excel.
Ungangenisa ngokulula iitafile kunye/okanye idatha egcinwe kwifayile yePDF kwi-Excel sheet usebenzisa eli nqaku. Ngaphezu koko, ungaphinda uhlele idatha ngaphambi kokuyingenisa kwi-excel usebenzisa i-Power Query Editor ekwayinxalenye yesi sixhobo. Isixhobo sifumaneka kuphela kubasebenzisi beMicrosoft 365.
Tsala idatha kwiPDF uye kwi-Excel sheet
Ukungenisa idatha kwiphepha le-Excel yinkqubo ecacileyo kakhulu. Imfuneko kuphela kukuba i-Excel sheet igcinwe kwivolumu yakho yesibini.
Ukungenisa idatha kwifayile yePDF, kuqala, vula iMicrosoft Excel. Yiya kwimenyu yokuqalisa kwaye uchwetheze Excelukwenza uphendlo. Emva koko ucofe kuMicrosoft Excel ukuze uvule usetyenziso.
Emva koko, nqakraza kwi "incwadi yokusebenzela engenanto" ukhetho ukuqhubeka.
Okulandelayo, cofa kwithebhu yeDatha kwimenyu yeribhoni kwaye emva koko ucofe ku Fumana iDatha ukhetho lokuqhubeka. Okulandelayo, hambisa ngaphezulu kwiFayile ukhetho kwaye emva koko ucofe kwiFayile yePDF ukhetho olusuka kwimenu engaphantsi. Oku kuya kuvula ifestile yokuhlola ifayile eyahlukileyo kwiscreen sakho.
Okulandelayo, khangela kwaye ukhethe ifayile onqwenela ukungenisa idatha kuyo ngokucofa kuyo. Emva koko nqakraza iqhosha elithi "Vula" ukulayisha idatha. Oku kuya kuvula ifestile eyahlukileyo kwisikrini sakho.
Ngoku, kwiscreen seNavigator, onke amacandelo akhethiweyo (iitafile okanye amaphepha) ePDF aya kuvela kwicala lasekhohlo. Unokukhetha icandelo elithile ngokucofa kuyo okanye usebenzisa ukhetho lokukhangela. Imboniso iya kuvula kwipheyini ekunene. Ungakhetha lonke iphepha ngokunjalo. Nje ukuba ukhethiwe, cofa iqhosha elithi Layisha ukungenisa idatha ngqo kwi-Excel, okanye ucofe iqhosha leConvert Data ukuze uqhubeke.
Ukuba ucofe i Guqula iqhosha leDatha kwinyathelo langaphambili, idatha iya kuboniswa kwifestile eyahlukileyo kwifomathi ehlelekayo. Ukuba uguqula itafile, unokongeza/uhlele ikholamu kunye negama lomqolo kunye nedatha yetafile. Unokusebenzisa izixhobo ezahlukeneyo ezinikezelweyo kwimenyu yeribhoni ukuze ulawule idatha ngokweemfuno zakho.
Emva kokwenza uhlengahlengiso olufunekayo kwidatha, nqakraza kwidatha ethi "Vala kwaye uLayishe" ukuyingenisa kwiphepha le-Excel.
Nje ukuba idatha ilayishiwe, uya kukwazi ukuyijonga kwiphepha le-Excel.
Nantso ke guys. Ngexesha elizayo xa ufuna ukusebenza ngedatha egcinwe kwifomathi yePDF, ungayingenisa ngokukhawuleza kwi-excel ngaphandle kokubeka esichengeni imveliso.
