Indlela yokuguqula i-PDF iye kwi-Excel: Iindlela ezisebenzayo ngokwenene

Unedatha evaleleke kwi-PDF kwaye uyayifuna kwi-Excel. Mhlawumbi yingxelo yezemali, i-invoyisi, okanye itheyibhile yedatha yemveliso. Ingxaki? I-PDF azenzelwanga ukuhlelwa—zenzelwe ukuba zikhangeleke ngokufanayo kuyo yonke indawo.

Nantsi indlela yokufumana loo datha kwispredshiti onokusebenza kuyo.

Kutheni uGuqulo lwe-PDF lusiya kwi-Excel lunobuqhophololo

I-PDF kunye neespredshiti ze-Excel zisebenza ngeenjongo ezahluke ngokupheleleyo. I-PDF igcina uyilo olubonakalayo—ngokusisiseko lushicilelo lwedijithali. I-Excel iququzelela idatha ibe yimiqolo neekholamu zokubala kunye nohlalutyo.

Umngeni? I-PDF ayinazo iinkcukacha zesakhiwo njengeetheyibhile ze-HTML. Akukho zi-tag ze-<table>, <tr>, okanye <td> ezixelela isoftware apho imiqolo neekholamu ziqala kwaye ziphele khona. Isiguquli kufuneka siqashele ngokusekelwe kwindawo ebonakalayo.

Oku kungahambelani kusisiseko kuko okwenza ukuba uguqulo olungqalileyo luhlale luvelisa iziphumo ezimdaka: iikholamu ziyadityaniswa, amanani aphela engumbhalo, kwaye nefomathi iyaphazamiseka.

Indlela yoku-1: UkuNgenisa okuSuka ngaphakathi kwe-Microsoft Excel

Ukuba une-Excel 2019 okanye kamva (kubandakanywa i-Microsoft 365), ungangenisa idatha ye-PDF ngokungqalileyo usebenzisa i-Power Query.

Indlela yokwenza

1. Vula i-Excel kwaye uye kwi-Data → Get Data → From File → From PDF
2. Khetha ifayile yakho ye-PDF
3. I-Power Query ibonisa iitheyibhile ezikhoyo—khetha leyo uyifunayo
4. Cofa u-Transform Data ukuze ucoce okungenisileyo, okanye u-Load ukuze uyise ngqo kwispredshiti yakho

Izinto ezintle nezimbi

Isebenza kakuhle kwi: PDF ezicocekileyo, ezicwangciswe kakuhle ezineetheyibhile ezilula

Inengxaki kwi: Uyilo oluntsonkothileyo, iiseli ezidityanisiweyo, iitheyibhile zamaphepha amaninzi

Qaphela: Olu phawu alufumaneki kwiinguqulelo ze-Mac ze-Excel.

Indlela yesi-2: Adobe Acrobat

I-Adobe Acrobat (inguqulelo ehlawulelwayo, hayi i-Reader kuphela) inokukhupha i-PDF iye kwifomathi ye-Excel ngokungqalileyo.

Indlela yokwenza

1. Vula i-PDF yakho kwi-Acrobat
2. Yiya kwi-File → Export To → Spreadsheet → Microsoft Excel Workbook
3. Khetha indawo oza kuyigcina kuyo

I-Adobe ikwabonelela ngesiguquli se-intanethi sasimahla esisetyenziswa ngomlinganiselo.

Izinto ezintle nezimbi

Isebenza kakuhle kwi: PDF ezenziwe ngezixhobo ze-Adobe, amaxwebhu oqobo (hayi askeniweyo)

Inengxaki kwi: Amaxwebhu askeniweyo, ifomathi entsonkothileyo

Indlela yesi-3: Iziguquli ze-Intanethi

Izixhobo ezininzi zasimahla ze-intanethi ziguqula i-PDF iye kwi-Excel ngaphandle kokufuna ufakelo lwesoftware.

Iinketho ezidumileyo

Isixhobo	Eyona ilungele	Imida
Smallpdf	Uguqulo olukhawulezayo	Imida yemihla ngemihla kwinqanaba lasimahla
iLovePDF	Ukusebenza ngezixa ezininzi	Imida yobungakanani befayile
PDF2Go	Iitheyibhile ezilula	Isenokuba nengxaki koyilo oluntsonkothileyo

Ukuqwalaselwa kwefihlo

Xa usebenzisa iziguquli ze-intanethi, ifayile yakho iyaphakanyiswa kwiiseva zabo. Ngceda uqwalasele idatha yezemali ebuthathaka, cinga ngeendlela ezingekho kwi-intanethi okanye izixhobo ezisebenza iifayile kwibhrawuza yakho.

Indlela yesi-4: Khuphela kwaye Uncamathisele (Ngesandla)

Maxa wambi eyona ndlela ilula iyasebenza—ngakumbi kwiidatha ezincinci.

Indlela yokwenza

1. Vula i-PDF kwaye ukhethe itheyibhile ngemawusi yakho
2. Khuphela (Ctrl+C okanye Cmd+C)
3. Ncamathisela kwi-Excel (Ctrl+V okanye Cmd+V)
4. Sebenzisa u-Data → Text to Columns ukulungisa iingxaki zefomathi

Xa oku kusebenza

Le ndlela ilungele iitheyibhile ezilula, ezinephepha elinye apho ufuna kuphela isicatshulwa esikhawulezayo. Lindela ukuchitha ixesha ucocha iziphumo.

Iingxaki eziXhaphakileyo kunye nendlela yokuZilungisa

Amanani angeniswe njengombhalo

I-Excel isenokuphatha amanani akho njengemitya yombhalo, nto leyo ephazamisa ukubala.

Isisombululo: Khetha ikholamu, yiya kwi-Data → Text to Columns, cofa u-Finish. Okanye phinda-phinda iiseli ngo-1 ukuze unyanzele uguqulo.

Iikholamu ezidityanisiweyo

Idatha esuka kwiikholamu ezininzi iphela ikwiseli enye.

Isisombululo: Sebenzisa u-Text to Columns kunye nesahluli (isithuba, ikoma, okanye ububanzi obusisigxina) ukwahlula idatha.

Idatha engekhoyo

Ezinye iziqulatho aziveli kuguqulo.

Isisombululo: Zama isixhobo esahlukileyo soguqulo—ngasinye siphatha uyilo ngendlela eyahlukileyo. Kwi-PDF askeniweyo, udinga amandla e-OCR (optical character recognition).

Ifomathi elahlekileyo

Imibala, iifonti, kunye nemida yeeseli iyanyamalala.

Isisombululo: Uninzi lweziguquli lujolise kwidatha, hayi kwifomathi ebonakalayo. Kuya kufuneka uphinde ufake ifomathi ngesandla kwi-Excel.

Iingcebiso zeZiphumo eziNgcono zoGuqulo

Sebenzisa i-PDF zoqobo xa kunokwenzeka

I-PDF ezenziwe ngokwedijithali (ukusuka kwi-Word, Excel, okanye isoftware yocwangciso-mali) ziguquka ngcono kakhulu kunamaxwebhu ephepha askeniweyo. Ukuba unokhetho, cela iinguqulelo zedijithali.

Jonga amandla e-OCR

Ukuba i-PDF yakho ngumfanekiso askeniweyo, udinga isiguquli esine-OCR. Khangela olu phawu ngokukodwa—Smallpdf kunye ne-Adobe Acrobat zombini ziyalubonelela.

Soloko uqinisekisa isiphumo

Akukho siguquli sigqibeleleyo. Emva koguqulo:

• Jonga ukuba imiqolo neekholamu ziyahambelana na nezoqobo
• Qinisekisa amanani ambalwa ngokuchasene nemvelaphi
• Khangela idatha edityanisiweyo okanye engekhoyo

Oku kuthatha umzuzu kwaye konga iiyure zokulungisa iingxaki kamva.

Qwalasela uhlobo loXwebhu

Iindidi ezahlukeneyo ze-PDF zidinga iindlela ezahlukeneyo:

Uhlobo loXwebhu	Eyona Ndlela iNgcono
Iingxelo zebhanki	Iziguquli zezemali ezikhethekileyo
I-invoyisi	I-Adobe Acrobat okanye izixhobo ze-intanethi
Iingxelo zedatha	I-Power Query (Excel eyakhelwe ngaphakathi)
Amaxwebhu askeniweyo	Izixhobo ezinamandla e-OCR

Xa uGuqulo lungonele

Maxa wambi akukho siguquli sinokukhupha idatha yakho ngendlela ecocekileyo. Oku kudla ngokwenzeka kwi:

• Maxwebhu ayilwe kakhulu anoyilo oluntsonkothileyo
• I-PDF enedatha enwenwela kwiikholamu ezininzi ngendlela engaguqukiyo
• Amaxwebhu askeniweyo anomgangatho womfanekiso ombi
• Iifayile ezikhuselweyo ngephasiwedi (susa ukhuseleko kuqala)

Kwezi meko, ukufaka ngesandla okanye isoftware ekhethekileyo eyenzelwe uhlobo loxwebhu lwakho isenokuba kuphela kwendlela ethembekileyo.

Imibuzo Ebuzwa rhoqo

Ngaba ndingaguqula i-PDF ekhuselweyo ngephasiwedi iye kwi-Excel?

Kuya kufuneka ususe ukhuseleko lwephasiwedi kuqala. Ukuba uyayazi iphasiwedi, vula i-PDF kwisijongi esinje nge-Adobe Reader, shicilela kwi-PDF ngaphandle kokukhusela, emva koko uguqule. Ukuba awunayo iphasiwedi, nxibelelana naye nabani na owenze uxwebhu.

Kutheni amanani am ebonakala njengombhalo kwi-Excel?

I-PDF ayahluli phakathi kwamanani nembhalo—onke angabalinganiswa nje kwiphepha. Xa i-Excel ingenisa le datha, isenokukhetha ifomathi yombhalo. Sebenzisa u-Data → Text to Columns okanye uphinda-phinde ngo-1 ukuze uguqule.

Yeyiphi indlela enika iziphumo ezichane kakhulu?

Kuxhomekeke kuxwebhu lwakho. Kwi-PDF zoqobo ezineetheyibhile ezilula, i-Power Query ye-Excel ihlala isebenza kakuhle. Kumaxwebhu antsonkothileyo, i-Adobe Acrobat okanye iziguquli ezikhethekileyo zikholisa ukwenza ngcono. Ekuphela kwendlela yokwazi kukuzama ifayile yakho.

Ngaba ndingaguqula i-PDF ezininzi ngaxeshanye?

Ewe, kodwa iindlela ziyahluka. Ezinye izixhobo ze-intanethi njenge-iLovePDF zixhasa uguqulo lwezixa ezininzi. I-Power Query inokungenisa iifayile ezininzi ngolungiselelo oluthile. Ukusebenza rhoqo ngezixa ezininzi, isoftware ye-desktop njenge-Adobe Acrobat Pro yeyona isebenza kakuhle.

Ngaba ikhona indlela yokuzenzekelisa uguqulo lwe-PDF iye kwi-Excel?

Uqhagamshelwano lwe-Power Query lunokuhlaziyeka ngokuzenzekelayo xa i-PDF yemvelaphi ihlaziywa. Ukuzenzekelisa okuphucukileyo, izixhobo zokucwangcisa ezifana ne-Python ene-library ezifana ne-Tabula okanye i-Camelot zinokusebenza i-PDF ngokwenkqubo.

Isishwankathelo

Ukuguqula i-PDF iye kwi-Excel akusoloko kulula, kodwa unazo iinketho:

• Excel Power Query kwiitheyibhile ezilula, ezicwangciswe kakuhle
• Adobe Acrobat kwiziphumo ezithembekileyo kwi-PDF zoqobo
• Iziguquli ze-intanethi kwiimfuno ezikhawulezayo, zamaxesha athile
• Khuphela-uncamathisele ngesandla kwizicatshulwa ezincinci, ezilula

Isitshixo kukutshatisa indlela yakho nohlobo loxwebhu lwakho—kwaye soloko uqinisekisa iziphumo phambi kokuba uthembele kwidatha eguquliweyo.