Okuqukethwe
Umsebenzi wokudlulisa idatha kusuka kuspredishithi efayelini le-PDF kuya eshidini le-Microsoft Excel uhlale “umnandi”. Ikakhulukazi uma ungenayo isofthiwe yokuqashelwa ebiza kakhulu njengeFineReader noma into enjalo. Ukukopisha okuqondile ngokuvamile akuholeli kunoma yini enhle, ngoba. ngemva kokunamathisela idatha ekopishiwe eshidini, cishe "zizonamathelana" zibe ikholomu eyodwa. Ngakho-ke kuyodingeka bahlukaniswe ngokucophelela kusetshenziswa ithuluzi Umbhalo ngamakholomu kusuka kuthebhu Idatha (Idatha — Umbhalo Kumakholomu).
Futhi-ke, ukukopisha kungenzeka kuphela kulawo mafayela e-PDF lapho kukhona ungqimba lombhalo, okungukuthi ngombhalo osanda kuskenwa kusuka ephepheni kuya ku-PDF, lokhu ngeke kusebenze ngokomgomo.
Kodwa akubuhlungu kangako, ngempela 🙂
Uma une-Office 2013 noma i-2016, ngemva kwemizuzu embalwa, ngaphandle kwezinhlelo ezengeziwe, kungenzeka ukudlulisa idatha isuka ku-PDF iye ku-Microsoft Excel. Futhi Umbuzo weZwi namandla uzosisiza kulokhu.
Isibonelo, ake sithathe lo mbiko we-PDF nenqwaba yombhalo, amafomula namathebula avela kuwebhusayithi yeKhomishini Yezomnotho YaseYurophu:
… bese uzama ukuyikhipha ku-Excel, usho ithebula lokuqala:
Asambe!
Isinyathelo 1. Vula i-PDF ku-Word
Ngesizathu esithile, bambalwa abantu abaziyo, kodwa kusukela ngo-2013 iMicrosoft Word ifunde ukuvula nokubona amafayela e-PDF (ngisho nalawo askeniwe, okungukuthi, ngaphandle koqweqwe lombhalo!). Lokhu kwenziwa ngendlela ejwayelekile ngokuphelele: vula i-Word, chofoza Ifayela – Vula (Ifayela — Vula) futhi ucacise ifomethi ye-PDF ohlwini lokudonsela phansi ekhoneni elingezansi kwesokudla sewindi.
Bese ukhetha ifayela le-PDF esilidingayo bese uchofoza Vula (Vula). IZwi lisitshela ukuthi izosebenzisa i-OCR kulo mbhalo ukuze ibhale umbhalo:
Siyavuma futhi emizuzwaneni embalwa sizobona i-PDF yethu ivuliwe ukuze ihlelwe kakade nge-Word:
Yebo, idizayini, izitayela, amafonti, izihloko nonyaweni, njll. kuzophuma kancane kudokhumenti, kodwa lokhu akubalulekile kithi - sidinga kuphela idatha evela kumathebula. Empeleni, kulesi sigaba, sekuyalinga ukumane ukopishe ithebula lisuka embhalweni owaziwayo liye ku-Word bese uvele ulinamathisele ku-Excel. Ngezinye izikhathi kuyasebenza, kodwa kaningi kuholela kuzo zonke izinhlobo zokuhlanekezelwa kwedatha - isibonelo, izinombolo zingashintsha zibe izinsuku noma zihlale umbhalo, njengakithi, ngoba. I-PDF isebenzisa izihlukanisi:
Ngakho-ke masinganqamuli amakhona, kodwa senze konke kube nzima nakakhulu, kodwa kulungile.
Isinyathelo sesi-2: Londoloza Idokhumenti Njengekhasi Lewebhu
Ukuze bese ulayisha idatha etholiwe ku-Excel (nge-Power Query), idokhumenti yethu ku-Word idinga ukugcinwa ngefomethi yekhasi lewebhu - le fomethi, kulokhu, iwuhlobo lwe-denominator evamile phakathi kwe-Word ne-Excel.
Ukuze wenze lokhu, yiya kumenyu Ifayela – Gcina Njenge (Ifayela — Londoloza Njenge) noma cindezela inkinobho F12 kukhibhodi nasefasiteleni elivulayo, khetha uhlobo lwefayela Ikhasi lewebhu kufayela elilodwa (Ikhasi lewebhu - Ifayela elilodwa):
Ngemva kokulondoloza, kufanele uthole ifayela elinesandiso se-mhtml (uma ubona izandiso zefayela ku-Explorer).
Isigaba 3. Ilayisha ifayela ku-Excel ngokusebenzisa Umbuzo Wamandla
Ungakwazi ukuvula ifayela le-MHTML elidaliwe ku-Excel ngokuqondile, kodwa-ke sizothola, okokuqala, konke okuqukethwe kwe-PDF ngesikhathi esisodwa, kanye nombhalo kanye nenqwaba yamatafula angadingekile, futhi, okwesibili, sizophinde silahlekelwe idatha ngenxa yokungalungile. abahlukanisi. Ngakho-ke, sizokwenza ukungenisa ku-Excel ngokusebenzisa isengezo Sombuzo Wamandla. Lesi isengezo samahhala ongalayisha ngaso idatha ku-Excel kusuka cishe kunoma yimuphi umthombo (amafayela, amafolda, isizindalwazi, izinhlelo ze-ERP) bese uguqula idatha etholiwe ngayo yonke indlela, uyinikeze umumo oyifunayo.
Uma une-Excel 2010-2013, ungalanda Umbuzo Wamandla kuwebhusayithi esemthethweni ye-Microsoft - ngemuva kokufaka uzobona ithebhu. Umbuzo Wamandla. Uma une-Excel 2016 noma entsha, awudingi ukulanda lutho - konke ukusebenza sekuvele kwakhiwe ku-Excel ngokuzenzakalelayo futhi kutholakala kuthebhu. Idatha (Usuku) eqenjini Landa futhi Uguqule (Thola futhi Uguqule).
Ngakho siya noma kuthebhu Idatha, noma kuthebhu Umbuzo Wamandla bese ukhetha iqembu Ukuze uthole idatha or Dala Umbuzo - Kusuka kufayela - Kusuka ku-XML. Ukuze wenze amafayela e-XML angabonakali kuphela, shintsha izihlungi ohlwini lokudonsela phansi ekhoneni elingezansi kwesokudla sewindi ukuze Wonke amafayela (Wonke amafayela) futhi ucacise ifayela lethu le-MHTML:
Sicela uqaphele ukuthi ukungenisa ngeke kuqedele ngempumelelo, ngoba. Umbuzo Wamandla ulindele i-XML kithi, kodwa empeleni sinefomethi ye-HTML. Ngakho-ke, efasiteleni elilandelayo elivelayo, uzodinga ukuchofoza kwesokudla efayeleni elingaqondakali ku-Power Query futhi ucacise ifomethi yalo:
Ngemuva kwalokho, ifayela lizokwaziwa kahle futhi sizobona uhlu lwawo wonke amathebula eliwaqukethe:
Ungakwazi ukubuka okuqukethwe kwamathebula ngokuchofoza inkinobho yegundane engakwesokunxele ngemuva (hhayi egameni elithi Ithebula!) lamaseli kukholomu Yedatha.
Lapho ithebula olifunayo lichazwa, chofoza igama eliluhlaza Ithebula - futhi "uwela" kokuqukethwe kwayo:
Kusele ukwenza izinyathelo ezimbalwa ezilula “ukukama” ekuqukethe, okuyilezi:
- susa amakholomu angadingekile (chofoza kwesokudla kusihloko sekholomu - Susa)
- shintsha amachashazi ngokhefana (khetha amakholomu, chofoza kwesokudla - Ukushintsha amanani)
- susa izimpawu ezilinganayo kunhlokweni (khetha amakholomu, chofoza kwesokudla - Ukushintsha amanani)
- susa umugqa ophezulu (Ikhaya - Susa imigqa - Susa imigqa ephezulu)
- susa imigqa engenalutho (Ikhaya - Susa imigqa - Susa imigqa engenalutho)
- phakamisa umugqa wokuqala kunhlokweni yethebula (Ikhaya - Sebenzisa umugqa wokuqala njengezihloko)
- hlunga idatha engadingekile usebenzisa isihlungi
Lapho ithebula ilethwa esimweni salo esivamile, lingalayishwa eshidini ngomyalo vala futhi ulande (Vala futhi ulayishe) on The main ithebhu. Futhi sizothola ubuhle obunjalo esingase sisebenze ngabo:
- Ukuguqula Ikholomu ibe Ithebula Elinombuzo Wamandla
- Ukuhlukanisa umbhalo onamathelayo ube amakholomu