txheem
Lub luag haujlwm ntawm kev xa cov ntaub ntawv los ntawm daim ntawv nthuav qhia hauv PDF rau hauv Microsoft Excel daim ntawv yog ib txwm "kev lom zem". Tshwj xeeb tshaj yog tias koj tsis muaj cov software paub zoo li FineReader lossis qee yam zoo li ntawd. Kev luam ncaj qha feem ntau tsis ua rau muaj dab tsi zoo, vim. Tom qab muab cov ntaub ntawv theej rau hauv daim ntawv, lawv feem ntau yuav "kos ua ke" rau hauv ib kem. Yog li ntawd lawv yuav tsum tau mob siab rau sib cais siv lub cuab yeej Cov ntawv nyeem los ntawm kab los ntawm tab Cov ntaub ntawv (Cov ntaub ntawv - Cov ntawv nyeem rau kab).
Thiab tau kawg, kev luam tawm tsuas yog ua tau rau cov ntaub ntawv PDF uas muaj cov ntawv sau, piv txwv li nrog cov ntaub ntawv uas nyuam qhuav luam tawm los ntawm ntawv mus rau PDF, qhov no yuav tsis ua haujlwm hauv txoj cai.
Tab sis nws tsis tu siab, tiag tiag 🙂
Yog tias koj muaj Office 2013 lossis 2016, tom qab ntawd hauv ob peb feeb, tsis muaj cov haujlwm ntxiv, nws muaj peev xwm hloov cov ntaub ntawv los ntawm PDF rau Microsoft Excel. Thiab Lo Lus thiab Lub Hwj Chim Query yuav pab peb hauv qhov no.
Piv txwv li, cia peb nqa daim ntawv tshaj tawm PDF no nrog cov ntawv nyeem, cov qauv thiab cov lus los ntawm lub vev xaib ntawm Economic Commission rau Tebchaws Europe:
... thiab sim rub tawm hauv Excel, hais thawj lub rooj:
Peb mus!
Kauj ruam 1. Qhib PDF hauv Lo Lus
Rau qee qhov laj thawj, ob peb tus neeg paub, tab sis txij li xyoo 2013 Microsoft Word tau kawm qhib thiab paub txog cov ntaub ntawv PDF (txawm tias cov scanned, uas yog, tsis muaj txheej ntawv!). Qhov no yog ua tiav raws li tus txheej txheem tag nrho: qhib Lo Lus, nyem Cov ntaub ntawv – Qhib (Cov ntaub ntawv - Qhib) thiab qhia meej hom PDF hauv daim ntawv teev npe hauv qab sab xis ntawm lub qhov rais.
Tom qab ntawd xaiv cov ntaub ntawv PDF peb xav tau thiab nyem Qhib (Qhib). Lo lus qhia peb tias nws yuav khiav OCR ntawm daim ntawv no mus rau ntawv:
Peb pom zoo thiab nyob rau hauv ob peb feeb peb yuav pom peb PDF qhib rau kho twb nyob rau hauv Word:
Tau kawg, tus tsim, qauv, fonts, headers thiab footers, thiab lwm yam yuav ya tawm ntawm daim ntawv, tab sis qhov no tsis tseem ceeb rau peb - peb tsuas yog xav tau cov ntaub ntawv los ntawm cov ntxhuav. Hauv txoj ntsiab cai, nyob rau theem no, nws twb ntxias kom luam lub rooj los ntawm cov ntawv lees paub rau hauv Lo Lus thiab tsuas yog muab tso rau hauv Excel. Qee lub sij hawm nws ua haujlwm, tab sis ntau zaus nws ua rau txhua yam kev hloov pauv ntawm cov ntaub ntawv - piv txwv li, cov lej tuaj yeem hloov mus rau hnub lossis nyob twj ywm ntawv, zoo li hauv peb rooj plaub, vim tias. PDF siv cov tsis sib cais:
Yog li cia peb tsis txhob txiav cov fab, tab sis ua kom txhua yam nyuaj me ntsis, tab sis yog.
Kauj ruam 2: Txuag cov ntaub ntawv raws li ib tug Web Page
Tom qab ntawd thauj cov ntaub ntawv tau txais mus rau hauv Excel (ntawm Power Query), peb cov ntaub ntawv hauv Lo Lus yuav tsum tau txais kev cawmdim hauv nplooj ntawv nplooj ntawv - hom ntawv no yog, qhov no, ib hom sib txawv ntawm Lo Lus thiab Excel.
Txhawm rau ua qhov no, mus rau cov ntawv qhia zaub mov Cov ntaub ntawv – Txuag li (Cov ntaub ntawv - Txuag li) los yog nias tus yuam sij F12 ntawm cov keyboard thiab hauv qhov rais uas qhib, xaiv hom ntaub ntawv Cov nplooj ntawv web hauv ib cov ntaub ntawv (Webpage — Ib cov ntaub ntawv):
Tom qab txuag, koj yuav tsum tau txais cov ntaub ntawv nrog mhtml txuas ntxiv (yog tias koj pom cov ntaub ntawv txuas ntxiv hauv Explorer).
Theem 3. Uploading cov ntaub ntawv rau Excel ntawm Power Query
Koj tuaj yeem qhib cov ntaub ntawv tsim MHTML hauv Excel ncaj qha, tab sis tom qab ntawd peb yuav tau txais, thawj zaug, tag nrho cov ntsiab lus ntawm PDF ib zaug, ua ke nrog cov ntawv thiab ib pawg ntawm cov lus tsis tsim nyog, thiab, thib ob, peb yuav rov poob cov ntaub ntawv vim qhov tsis raug. cais. Yog li ntawd, peb yuav ua qhov ntshuam rau hauv Excel los ntawm Power Query add-in. Qhov no yog ib qho ntxiv pub dawb uas koj tuaj yeem xa cov ntaub ntawv rau Excel los ntawm yuav luag txhua qhov chaw (cov ntaub ntawv, folders, databases, ERP systems) thiab tom qab ntawd hloov cov ntaub ntawv tau txais hauv txhua txoj hauv kev, muab cov duab xav tau.
Yog tias koj muaj Excel 2010-2013, tom qab ntawd koj tuaj yeem rub tawm Lub Zog Query los ntawm Microsoft lub vev xaib official - tom qab kev teeb tsa koj yuav pom tab Lub Zog Lus Nug. Yog tias koj muaj Excel 2016 lossis tshiab dua, tom qab ntawd koj tsis tas yuav rub tawm dab tsi - tag nrho cov haujlwm tau ua tiav rau hauv Excel los ntawm lub neej ntawd thiab nyob ntawm tab Cov ntaub ntawv (Hnub) hauv pab pawg Download tau thiab Hloov (Tau & Hloov).
Yog li peb mus rau lub tab Cov ntaub ntawv, los yog tab Lub Zog Lus Nug thiab xaiv ib pab neeg Kom tau txais cov ntaub ntawv or Tsim Cov Lus Nug - Los Ntawm Cov Ntaub Ntawv - Los Ntawm XML. Txhawm rau ua kom pom tsis yog cov ntaub ntawv XML nkaus xwb, hloov cov ntxaij lim dej hauv daim ntawv teev npe hauv qab sab xis ntawm lub qhov rais mus rau Txhua cov ntaub ntawv (Txhua cov ntaub ntawv) thiab qhia peb cov ntaub ntawv MHTML:
Thov nco ntsoov tias cov ntshuam yuav tsis ua kom tiav, vim. Power Query cia siab tias XML los ntawm peb, tab sis peb yeej muaj hom HTML. Yog li ntawd, nyob rau hauv lub qhov rais tom ntej uas tshwm sim, koj yuav tsum tau right-click rau cov ntaub ntawv incomprehensible rau lub hwj chim Query thiab qhia meej nws hom:
Tom qab ntawd, cov ntaub ntawv yuav raug lees paub thiab peb yuav pom cov npe ntawm txhua lub rooj uas nws muaj:
Koj tuaj yeem saib cov ntsiab lus ntawm cov ntxhuav los ntawm nias lub pob laug nas nyob rau hauv keeb kwm yav dhau dawb (tsis yog nyob rau hauv lo lus Table!) ntawm cov hlwb hauv cov ntaub ntawv kem.
Thaum lub rooj xav tau txhais, nyem rau ntawm lo lus ntsuab rooj - thiab koj "poob dhau" rau hauv nws cov ntsiab lus:
Nws tseem yuav ua ob peb kauj ruam yooj yim rau "comb" nws cov ntsiab lus, uas yog:
- rho tawm cov kab uas tsis tsim nyog (txoj cai-nias rau ntawm kab ntawv header - tshem tawm)
- hloov cov dots nrog commas (xaiv kab, right-click - Hloov cov nqi)
- tshem tawm cov paib sib npaug hauv lub header (xaiv kab, right-click - Hloov cov nqi)
- tshem tawm cov kab saum toj kawg nkaus (Tsev - Rho tawm kab - Tshem cov kab saum toj kawg nkaus)
- tshem tawm cov kab dawb paug (Lub Tsev - Rho tawm kab - Rho tawm cov kab khoob)
- tsa thawj kab mus rau lub rooj header (Tsev - Siv thawj kab ua kab lus)
- lim tawm cov ntaub ntawv tsis tsim nyog siv lub lim
Thaum lub rooj raug coj mus rau nws daim ntawv ib txwm, nws tuaj yeem rub tawm mus rau hauv daim ntawv nrog cov lus txib kaw thiab download tau (Kaw & Load) on lub ntsiab tab. Thiab peb yuav tau txais kev zoo nkauj zoo li no uas peb tuaj yeem ua haujlwm tau:
- Hloov cov kab rau ib lub rooj nrog lub zog Query
- Sib faib cov ntawv nplaum rau hauv kab