Zamkatimu
Ntchito yosamutsa deta kuchokera pa spreadsheet mu fayilo ya PDF kupita ku Microsoft Excel sheet nthawi zonse imakhala "yosangalatsa". Makamaka ngati mulibe mapulogalamu odziwika okwera mtengo ngati FineReader kapena zina zotero. Kukopera mwachindunji nthawi zambiri sikumabweretsa zabwino, chifukwa. Pambuyo kumata zomwe zakopedwa pa pepalalo, "zimamatirana" kukhala gawo limodzi. Choncho, iwo ayenera kulekanitsidwa mosamala kwambiri pogwiritsa ntchito chida Zolemba ndi zigawo kuchokera ku tabu Deta (Deta - Zolemba ku Mizati).
Ndipo, ndithudi, kukopera ndi kotheka kokha kwa mafayilo a PDF omwe ali ndi zolemba zosanjikiza, mwachitsanzo ndi chikalata chomwe chasinthidwa kuchokera pa pepala kupita ku PDF, izi sizingagwire ntchito.
Koma sizomvetsa chisoni, kwenikweni 🙂
Ngati muli ndi Office 2013 kapena 2016, ndiye kuti mumphindi zingapo, popanda mapulogalamu owonjezera, ndizotheka kusamutsa deta kuchokera ku PDF kupita ku Microsoft Excel. Ndipo Kufunsa kwa Mawu ndi Mphamvu kudzatithandiza pa izi.
Mwachitsanzo, tiyeni titenge lipoti la PDF ili ndi zolemba zambiri, mafomula ndi matebulo ochokera patsamba la Economic Commission for Europe:
... ndipo yesani kuchotsa mu Excel, nenani tebulo loyamba:
Tiyeni tizipita!
Gawo 1. Tsegulani PDF mu Mawu
Pazifukwa zina, anthu ochepa amadziwa, koma kuyambira 2013 Microsoft Word yaphunzira kutsegula ndi kuzindikira mafayilo a PDF (ngakhale osakanizidwa, ndiye kuti, opanda zolemba!). Izi zimachitika mwanjira yokhazikika: tsegulani Mawu, dinani Fayilo - Open (Fayilo - Tsegulani) ndipo tchulani mtundu wa PDF pamndandanda wotsikira pansi pakona yakumanja kwa zenera.
Kenako sankhani fayilo ya PDF yomwe tikufuna ndikudina Open (Tsegulani). Mawu akutiuza kuti idzayendetsa OCR pachikalatachi kuti ilembe:
Tikuvomereza ndipo mumasekondi pang'ono tiwona PDF yathu itatsegulidwa kuti isinthidwe kale mu Mawu:
Zoonadi, mapangidwe, masitayelo, mafonti, mitu ndi ma footer, ndi zina zotero zidzawuluka pang'ono pa chikalatacho, koma izi sizofunikira kwa ife - timangofunika deta kuchokera kumatebulo. M'malo mwake, pakadali pano, ndikuyesa kale kungotengera tebulo kuchokera pachikalata chodziwika kukhala Mawu ndikuyiyika mu Excel. Nthawi zina zimagwira ntchito, koma nthawi zambiri zimabweretsa kusokoneza kwamtundu uliwonse - mwachitsanzo, manambala amatha kukhala masiku kapena kukhalabe malemba, monga momwe zilili ndi ife, chifukwa. PDF imagwiritsa ntchito osagawa:
Chifukwa chake tisadule ngodya, koma tipange zonse kukhala zovuta, koma kulondola.
Khwerero 2: Sungani Chikalatacho ngati Tsamba la Webusaiti
Kuti mukweze zomwe mwalandira mu Excel (kudzera mu Power Query), chikalata chathu mu Mawu chiyenera kusungidwa mumtundu watsamba lawebusayiti - mawonekedwe awa, pankhaniyi, ndi mtundu wamba wamba pakati pa Mawu ndi Excel.
Kuti muchite izi, pitani ku menyu Fayilo - Sungani Monga (Fayilo - Sungani Monga) kapena dinani batani F12 pa kiyibodi ndi pawindo lomwe limatsegula, sankhani mtundu wa fayilo Tsamba lawebusayiti mu fayilo imodzi (Webusaiti - Fayilo imodzi):
Mukasunga, muyenera kupeza fayilo yokhala ndi mhtml extension (ngati muwona zowonjezera mafayilo mu Explorer).
Gawo 3. Kukweza fayilo ku Excel kudzera mu Power Query
Mutha kutsegula fayilo ya MHTML yomwe idapangidwa ku Excel mwachindunji, koma kenako tipeza, choyamba, zonse zomwe zili mu PDF nthawi imodzi, pamodzi ndi zolemba ndi gulu la matebulo osafunikira, ndipo, chachiwiri, tidzatayanso deta chifukwa cholakwika. olekanitsa. Chifukwa chake, tidzalowetsa mu Excel kudzera mu Power Query add-in. Izi ndizowonjezera zaulere zomwe mutha kuyikamo data ku Excel kuchokera pafupifupi gwero lililonse (mafayilo, zikwatu, nkhokwe, machitidwe a ERP) ndikusintha zomwe mwalandira mwanjira iliyonse, ndikuzipatsa mawonekedwe omwe mukufuna.
Ngati muli ndi Excel 2010-2013, ndiye kuti mutha kutsitsa Power Query patsamba lovomerezeka la Microsoft - mukakhazikitsa mudzawona tabu. Kufunsa Mphamvu. Ngati muli ndi Excel 2016 kapena yatsopano, ndiye kuti simuyenera kutsitsa chilichonse - magwiridwe antchito onse adapangidwa kale mu Excel mwachisawawa ndipo ali pa tabu. Deta (Tsiku) pagulu Koperani ndi Sinthani (Pezani & Sintha).
Kenako timapita ku tabu Deta, kapena pa tabu Kufunsa Mphamvu ndikusankha gulu Kuti mupeze data or Pangani Mafunso - Kuchokera Fayilo - Kuchokera ku XML. Kuti muwonetsetse osati mafayilo a XML okha, sinthani zosefera pamndandanda wotsikira pansi pakona yakumanja kwa zenera kuti Mafayilo onse (Mafayilo onse) ndikufotokozerani fayilo yathu ya MHTML:
Chonde dziwani kuti kuitanitsa sikudzatha bwino, chifukwa. Power Query ikuyembekeza XML kuchokera kwa ife, koma tili ndi mtundu wa HTML. Chifukwa chake, pazenera lotsatira lomwe likuwoneka, muyenera dinani kumanja pa fayilo yosamvetsetseka ku Power Query ndikulongosola mawonekedwe ake:
Pambuyo pake, fayiloyo idzazindikirika bwino ndipo tiwona mndandanda wa matebulo onse omwe ali nawo:
Mutha kuwona zomwe zili m'matebulo podina batani lakumanzere chakumbuyo koyera (osati m'mawu akuti Table!) m'maselo omwe ali mugawo la Data.
Pamene tebulo lofunidwa likufotokozedwa, dinani pa mawu obiriwira Table - ndipo "mugwera" muzolemba zake:
Zimatsalira kuchita njira zingapo zosavuta "kupesa" zomwe zili mkati mwake, zomwe ndi:
- Chotsani zipilala zosafunikira (dinani kumanja pamutu wagawo - Chotsani)
- sinthani madontho ndi koma (sankhani mizati, dinani kumanja - Kusintha makhalidwe)
- chotsani zizindikiro zofanana pamutu (sankhani mizati, dinani kumanja - Kusintha makhalidwe)
- chotsani mzere wapamwamba (Kunyumba - Chotsani mizere - Chotsani mizere yapamwamba)
- chotsani mizere yopanda kanthu (Kunyumba - Chotsani mizere - Chotsani mizere yopanda kanthu)
- kwezani mzere woyamba pamutu wa tebulo (Kunyumba - Gwiritsani ntchito mzere woyamba ngati mitu)
- sefa deta yosafunikira pogwiritsa ntchito fyuluta
Pamene tebulo libweretsedwa mu mawonekedwe ake, likhoza kutulutsidwa pa pepala ndi lamulo kutseka ndikutsitsa (Tsekani & Kwezani) on waukulu tabu. Ndipo tidzapeza kukongola koteroko komwe tingathe kugwira ntchito kale:
- Kusintha Column kukhala Table yokhala ndi Power Query
- Kugawa mawu omata m'migawo