Contents
ʻO ka hana o ka hoʻoili ʻana i ka ʻikepili mai kahi pālahalaha ma kahi faila PDF i kahi pepa Microsoft Excel he "leʻaleʻa". ʻOi loa inā ʻaʻole ʻoe i loaʻa nā polokalamu ʻike makamae e like me FineReader a i ʻole kekahi mea like. ʻAʻole i alakaʻi ʻia ke kope pololei i kekahi mea maikaʻi, no ka mea. ma hope o ka hoʻopili ʻana i ka ʻikepili i kope ʻia ma ka pepa, e "pili pū" lākou i hoʻokahi kolamu. No laila pono lākou e hoʻokaʻawale me ka hoʻohana ʻana i kahi mea hana kikokiko ma nā kolamu mai ka papa 'Ikepili (ʻIkepili — kikokikona i nā kolamu).
A ʻoiaʻiʻo, hiki ke kope wale ʻia no kēlā mau faila PDF i loaʻa kahi papa kikokikona, ʻo ia hoʻi me kahi palapala i nānā ʻia mai ka pepa a i ka PDF, ʻaʻole e hana ma ke kumu.
Akā ʻaʻole ia he mea kaumaha, ʻoiaʻiʻo 🙂
Inā loaʻa iā ʻoe ka Office 2013 a i ʻole 2016, a laila i loko o ʻelua mau minuke, me ka ʻole o nā papahana hou, hiki ke hoʻololi i ka ʻikepili mai PDF a Microsoft Excel. A ʻo Word a me Power Query e kōkua iā mākou i kēia.
No ka laʻana, e lawe kāua i kēia hōʻike PDF me kahi pūʻulu o nā kikokikona, nā ʻōlelo a me nā papa mai ka pūnaewele o ka Commission Economic for Europe:
... a ho'āʻo e huki mai ia mea ma Excel, e ʻōlelo i ka papa mua:
E hele kāua!
KaʻAnuʻu Hana 1. Wehe PDF ma Word
No kekahi kumu, he kakaikahi ka poʻe i ʻike, akā mai ka makahiki 2013 ua aʻo ʻo Microsoft Word e wehe a ʻike i nā faila PDF (ʻo ia hoʻi nā mea i nānā ʻia, ʻo ia hoʻi, me ka ʻole o kahi papa kikokikona!). Hana ʻia kēia ma ke ʻano maʻamau: wehe i ka Word, kaomi Waihona – Wehe (Waila — Wehe) a e kuhikuhi i ka palapala PDF ma ka papa inoa hāʻule ma ka ʻaoʻao ʻākau o ka pukaaniani.
A laila koho i ka faila PDF a mākou e pono ai a kaomi Open (Wehe). Hōʻike ʻo Word iā mākou e holo ana ʻo OCR ma kēia palapala i ka kikokikona:
Ua ʻae mākou a i loko o kekahi mau kekona e ʻike mākou i kā mākou PDF wehe ʻia no ka hoʻoponopono ʻana ma Word:
ʻOiaʻiʻo, ʻo ka hoʻolālā, nā ʻano, nā font, nā poʻo a me nā wāwae, a me nā mea ʻē aʻe e lele hapa i ka palapala, akā ʻaʻole ia he mea nui iā mākou - pono mākou i ka ʻikepili mai nā papa. Ma ke kumu, i kēia manawa, ua hoʻowalewale ʻia e kope wale i ka papaʻaina mai ka palapala i ʻike ʻia i Word a hoʻopili wale iā ia i Excel. I kekahi manawa hana ia, akā ʻoi aku ka nui o ke alakaʻi ʻana i nā ʻano distortions ʻikepili - no ka laʻana, hiki i nā helu ke lilo i mau lā a i ʻole e noho kikokikona, e like me kā mākou hihia, no ka mea. Hoʻohana ʻo PDF i nā mea hoʻokaʻawale ʻole:
No laila ʻaʻole mākou e ʻoki i nā kihi, akā e hoʻolilo i nā mea āpau i mea paʻakikī, akā pololei.
KaʻAnuʻu Hana 2: E mālama i ka palapala ma ke ʻano he ʻaoʻao pūnaewele
No ka hoʻouka ʻana i ka ʻikepili i loaʻa i Excel (ma o Power Query), pono e mālama ʻia kā mākou palapala ma Word ma ka ʻaoʻao ʻaoʻao pūnaewele - ʻo kēia ʻano, ma kēia hihia, he ʻano denominator maʻamau ma waena o Word a me Excel.
No ka hana ʻana i kēia, hele i ka papa kuhikuhi Waihona - Mālama e like (Kōnae — Mālama iā ʻoe) a i ʻole kaomi i ke kī F12 ma ka papa keyboard a ma ka puka aniani e wehe ai, koho i ke ʻano faila ʻaoʻao pūnaewele i hoʻokahi faila (Pūnaewele — Hoʻokahi waihona):
Ma hope o ka mālama ʻana, pono ʻoe e kiʻi i kahi faila me ka mhtml extension (inā ʻike ʻoe i nā hoʻonui faila ma Explorer).
Ka Papa 3. Hoʻouka i ka faila i Excel ma o Power Query
Hiki iā ʻoe ke wehe pololei i ka faila MHTML i hana ʻia ma Excel, akā e loaʻa iā mākou, ʻo ka mea mua, nā mea āpau o ka PDF i ka manawa hoʻokahi, me nā kikokikona a me nā ʻāpana o nā papa pono ʻole, a, ʻo ka lua, e nalowale hou mākou i ka ʻikepili ma muli o ka hewa. nā mea hoʻokaʻawale. No laila, e hana mākou i ka hoʻokomo ʻana i Excel ma o ka Power Query add-in. He mea hoʻohui manuahi loa kēia e hiki ai iā ʻoe ke hoʻouka i ka ʻikepili i Excel mai kahi kokoke i nā kumu (faila, waihona, waihona, ʻōnaehana ERP) a laila hoʻololi i ka ʻikepili i loaʻa i nā ala āpau, e hāʻawi iā ia i ke ʻano i makemake ʻia.
Inā loaʻa iā ʻoe ka Excel 2010-2013, a laila hiki iā ʻoe ke hoʻoiho i ka Power Query mai ka punaewele Microsoft mana - ma hope o ka hoʻokomo ʻana e ʻike ʻoe i kahi pā. Nīnau Uila. Inā loaʻa iā ʻoe ka Excel 2016 a i ʻole ka mea hou, a laila ʻaʻole pono ʻoe e hoʻoiho i kekahi mea - ua kūkulu ʻia nā hana āpau i Excel ma ke ʻano maʻamau a aia ma ka pā. 'Ikepili (Lā) ma ka hui Hoʻoiho a hoʻololi (E kiʻi a hoʻololi).
No laila, hele mākou i ka pā 'Ikepili, a i ʻole ma ka pā Nīnau Uila a koho i kahi hui No ka loaʻa ʻana o ka ʻikepili or E hana i ka nīnau - mai ka faila - mai XML. No ka ʻike ʻole ʻana i nā faila XML wale nō, e hoʻololi i nā kānana ma ka papa inoa hāʻule i lalo ma ke kihi ʻākau haʻahaʻa o ka pukaaniani. Nā faila āpau (Nā waihona a pau) a e kuhikuhi i kā mākou faila MHTML:
E ʻoluʻolu, ʻaʻole e hoʻopau pono ka lawe ʻana mai, no ka mea. Manaʻo ʻo Power Query iā XML mai iā mākou, akā loaʻa iā mākou kahi ʻano HTML. No laila, ma ka puka aniani e kū mai ana, pono ʻoe e kaomi ʻākau i ka faila hiki ʻole ke hoʻomaopopo i ka Power Query a kuhikuhi i kona ʻano:
Ma hope o kēlā, e ʻike pololei ʻia ka faila a ʻike mākou i kahi papa inoa o nā papa āpau i loaʻa:
Hiki iā ʻoe ke ʻike i nā mea o nā papa ma ke kaomi ʻana i ka pihi ʻiole hema ma ke kāʻei keʻokeʻo (ʻaʻole ma ka huaʻōlelo Papa!) o nā cell i ke kolamu ʻIkepili.
Ke wehewehe ʻia ka papaʻaina i makemake ʻia, kaomi i ka huaʻōlelo ʻōmaʻomaʻo papaʻaina - a "hāʻule ʻoe" i loko o kāna mau mea:
Ke hoʻomau nei e hana i kekahi mau hana maʻalahi e "hui" i kāna mau mea, ʻo ia hoʻi:
- holoi i nā kolamu pono ʻole (kaomi ʻākau ma ke poʻo kolamu - wehe i)
- pani i nā kiko me nā koma (koho i nā kolamu, kaomi ʻākau – Hoʻololi i nā waiwai)
- wehe i nā hōʻailona like ma ke poʻo (koho i nā kolamu, kaomi ʻākau - Hoʻololi i nā waiwai)
- wehe i ka laina luna (Home - Holoi i nā laina - Holoi i nā laina kiʻekiʻe)
- wehe i nā laina hakahaka (Home – Holoi i nā laina – Holoi i nā laina hakahaka)
- hoʻokiʻekiʻe i ka lālani mua i ke poʻo papa (Home - E hoʻohana i ka laina mua ma ke ʻano he poʻo)
- kānana i nā ʻikepili pono ʻole me ka hoʻohana ʻana i kahi kānana
Ke lawe ʻia ka papaʻaina i kona ʻano maʻamau, hiki ke hoʻokuʻu ʻia ma luna o ka pepa me ke kauoha pani a hoʻoiho (Paʻa a hoʻouka) on o ka papa kuhikuhi pā. A e loaʻa iā mākou ka nani e hiki ai iā mākou ke hana:
- Ke hoʻololi ʻana i kahi kolamu i kahi pākaukau me ka nīnau mana
- Ka hoʻokaʻawale ʻana i nā kikokikona paʻa i nā kolamu