Mukati
Basa rekuendesa data kubva kuspredishiti muPDF faira kuenda kuMicrosoft Excel sheet rinogara "rinonakidza". Kunyanya kana iwe usina inodhura yekuzivikanwa software seFineReader kana chimwe chinhu chakadaro. Kukopa kwakananga kazhinji hakutungamiri kune chero chinhu chakanaka, nekuti. mushure mekunamira iyo data yakakopwa pabepa, ivo vanogona "kunamatira pamwechete" mukoramu imwe. Saka vanozofanira kuparadzaniswa zvine mutsindo vachishandisa mudziyo Mavara nezvikamu kubva kune tab Data (Data - Chinyorwa kune Columns).
Uye zvechokwadi, kukopa kunogoneka chete kune iwo mafaera ePDF uko kune zvinyorwa zvinyorwa, kureva negwaro richangoongororwa kubva pabepa kuenda kuPDF, izvi hazvishande mumusimboti.
Asi hazvina kusuruvara, chaizvo 🙂
Kana iwe uine Hofisi 2013 kana 2016, saka mumaminetsi akati wandei, pasina mamwe mapurogiramu, zvinokwanisika kutamisa data kubva kuPDF kuenda kuMicrosoft Excel. Uye Shoko neSimba Mubvunzo zvichatibatsira mune izvi.
Semuyenzaniso, ngatitorei iyi mushumo wePDF neboka rezvinyorwa, mafomula nematafura kubva pawebhusaiti yeEconomic Commission yeEurope:
... uye edza kuiburitsa muExcel, taura tafura yekutanga:
Handeyi!
Danho 1. Vhura PDF muShoko
Nechimwe chikonzero, vashoma vanhu vanoziva, asi kubvira 2013 Microsoft Word yakadzidza kuvhura uye kuziva mafaera ePDF (kunyangwe akaongororwa, kureva, asina chinyorwa chinyorwa!). Izvi zvinoitwa nenzira yakajairika: vhura Shoko, tinya Faira - Vhura (Faira - Vhura) uye tsanangura iyo PDF fomati mune yekudonha-pasi rondedzero mukona yezasi yekurudyi yehwindo.
Wobva wasarudza iyo PDF faira yatinoda uye tinya Open (Vhura). Shoko rinotiudza kuti ichamhanya OCR pane iri gwaro kutumira mameseji:
Isu tinobvumirana uye mumasekonzi mashoma tichaona yedu PDF yakavhurwa kuti igadziriswe yatove muIzwi:
Ehe, dhizaini, masitayera, mafonti, misoro uye tsoka, nezvimwe zvichabhururuka zvishoma kubva pagwaro, asi izvi hazvina kukosha kwatiri - isu tinongoda data kubva pamatafura. Muchidimbu, panguva ino, zvave kutoedza kungokopa tafura kubva kugwaro rinozivikanwa muIzwi uye kungoisa muExcel. Dzimwe nguva inoshanda, asi kazhinji inotungamirira kumarudzi ose ekukanganiswa kwedata - somuenzaniso, nhamba dzinogona kushanduka kuva misi kana kuramba dzichinyora, sezvatiri, nokuti. PDF inoshandisa vasiri-kupatsanura:
Saka ngatirege kutema makona, asi ita kuti zvese zvinyanye kuomarara, asi zvakanaka.
Nhanho yechipiri: Sevha Gwaro seWebhu Peji
Kuti wozoisa iyo data yakagamuchirwa muExcel (kuburikidza nePower Query), gwaro redu muIzwi rinoda kuchengetwa muwebhu peji fomati - iyi fomati, mune iyi kesi, imhando yedhinominator pakati peIzwi neExcel.
Kuti uite izvi, enda kumenyu Faira - Save As (Faira - Sevha Se) kana kuti baya kiyi F12 pa keyboard uye pahwindo rinovhura, sarudza rudzi rwefaira Webhu peji mune imwe faira (Webhu peji - faira rimwechete):
Mushure mekuchengetedza, iwe unofanirwa kuwana faira ine mhtml yekuwedzera (kana iwe ukaona mafaera ekuwedzera muExplorer).
Nhanho 3. Kuisa faira kuExcel kuburikidza nePower Query
Iwe unogona kuvhura iyo yakagadzirwa MHTML faira muExcel zvakananga, asi tozowana, chekutanga, zvese zvirimo muPDF kamwechete, pamwe chete nemavara uye boka rematafura asina basa, uye, chechipiri, isu ticharasikirwa zvakare data nekuda kwekutadza. vapatsanura. Naizvozvo, isu tichaita iyo inopinza muExcel kuburikidza neiyo Power Query yekuwedzera-mukati. Iyi ndeye yemahara yekuwedzera-yekuwedzera iyo iwe yaunogona kurodha data kuExcel kubva kunenge chero kupi (mafaira, maforodha, dhatabhesi, ERP masisitimu) uye wozoshandura iyo yakagamuchirwa data munzira dzese dzinogoneka, ichipa iyo inodiwa chimiro.
Kana iwe uine Excel 2010-2013, saka unogona kudhawunirodha Power Query kubva kune yepamutemo Microsoft webhusaiti - mushure mekuisa iwe uchaona tebhu. Simba Query. Kana iwe uine Excel 2016 kana nyowani, saka haufanire kudhawunirodha chero chinhu - zvese zvinoshanda zvakatovakwa muExcel nekukasira uye iri pane iyo tab. Data (Zuva) muboka Dhaunirodha uye Shandura (Tora & Shandura).
Saka isu tinoenda kune iyo tab Data, kana kuti pane tab Simba Query uye sarudza timu Kuti uwane data or Gadzira Mubvunzo - Kubva Faili - Kubva kuXML. Kuita kuti mafaira eXML aonekwe kwete chete, shandura mafirita ari mugwaro rekudonhedza pasi pakona yekurudyi yehwindo kuti Mafaira ese (Mafaira ese) uye tsanangura yedu MHTML faira:
Ndapota cherechedza kuti kupinza hakuzopedzi zvinobudirira, nokuti. Power Query inotarisira XML kubva kwatiri, asi isu tine HTML fomati. Naizvozvo, pahwindo rinotevera rinoonekwa, iwe uchafanirwa kudzvanya-kurudyi pane faira risinganzwisisike kune Power Query uye tsanangura chimiro chayo:
Mushure meizvozvo, iyo faira ichanyatso zivikanwa uye isu tichaona rondedzero yematafura ese arimo:
Unogona kuona zviri mumatafura nekudzvanya bhatani rekuruboshwe regonzo muchena kumashure (kwete mushoko Tafura!) yemasero ari muData column.
Kana tafura yaidiwa ichitsanangurwa, tinya pashoko rakasvibira tafura - uye iwe "unowira" mune zviri mukati maro:
Zvinosara kuita nhanho shoma dzeku "comb" zvirimo, zvinoti:
- bvisa makoramu asina kufanira (tinya-kurudyi pane musoro wekoramu - Bvisa)
- chinja madotsi nemakoma (sarudza makoramu, tinya-kurudyi - Kutsiva tsika)
- bvisa zviratidzo zvakaenzana mumusoro (sarudza makoramu, tinya-kurudyi - Kutsiva tsika)
- bvisa mutsara wepamusoro (Home - Delete mitsetse - Bvisa mitsetse yepamusoro)
- bvisa mitsetse isina chinhu (Kumba - Delete mitsara - Delete mitsara isina chinhu)
- simudza mutsara wekutanga kumusoro wetafura (Musha - Shandisa mutsara wekutanga semisoro)
- kusefa data risingakoshi uchishandisa sefa
Kana tafura yaunzwa kune yakajairika fomu, inogona kuburutswa papepa nemurairo kuvhara uye kudhawunirodha (Vhara & Rodha) on huru tab. Uye isu tichawana runako rwakadaro rwatinogona kutoshanda narwo:
- Kushandura Column kuita Tafura ine Power Query
- Kupatsanura mavara anonamira kuita makoramu