Contents
Ayyukan canja wurin bayanai daga maƙunsar rubutu a cikin fayil ɗin PDF zuwa takardar Microsoft Excel koyaushe shine "fun". Musamman idan ba ku da software mai tsada kamar FineReader ko wani abu makamancin haka. Kwafi kai tsaye yawanci baya haifar da wani abu mai kyau, saboda. bayan manna bayanan da aka kwafi akan takardar, da alama za su “manne tare” cikin shafi ɗaya. Don haka dole ne a raba su cikin wahala ta hanyar amfani da kayan aiki Rubutu ta ginshiƙai daga tab data (Bayanai - Rubutu zuwa ginshiƙai).
Kuma ba shakka, yin kwafi yana yiwuwa kawai ga waɗancan fayilolin PDF inda akwai rubutun rubutu, watau tare da takaddun da aka riga aka bincika daga takarda zuwa PDF, wannan ba zai yi aiki bisa manufa ba.
Amma ba abin bakin ciki ba ne, da gaske 🙂
Idan kana da Office 2013 ko 2016, to, a cikin 'yan mintuna kaɗan, ba tare da ƙarin shirye-shirye ba, yana yiwuwa don canja wurin bayanai daga PDF zuwa Microsoft Excel. Kuma Tambayar Magana da Ƙarfi za su taimake mu a cikin wannan.
Misali, bari mu dauki wannan rahoton PDF tare da tarin rubutu, dabaru da teburi daga gidan yanar gizon Hukumar Tattalin Arziki na Turai:
… kuma gwada fitar da shi a cikin Excel, faɗi tebur na farko:
Bari mu tafi!
Mataki 1. Bude PDF a cikin Kalma
Don wasu dalilai, mutane kaɗan ne suka sani, amma tun 2013 Microsoft Word ya koyi buɗewa da gane fayilolin PDF (har ma waɗanda aka bincika, wato, ba tare da rubutun rubutu ba!). Ana yin wannan ta hanyar daidaitacciyar hanya: buɗe Word, danna Fayil - Buɗe (Fayil - Buɗe) kuma saka tsarin PDF a cikin jerin zaɓuka a cikin ƙananan kusurwar dama na taga.
Sannan zaɓi fayil ɗin PDF da muke buƙata kuma danna Bude (Buɗe). Word yana gaya mana cewa zai gudanar da OCR akan wannan takarda zuwa rubutu:
Mun yarda kuma a cikin ƴan daƙiƙa kaɗan za mu ga PDF a buɗe don gyara riga a cikin Word:
Tabbas, zane, salo, fonts, headers da footers, da dai sauransu za su tashi daga daftarin aiki, amma wannan ba shi da mahimmanci a gare mu - kawai muna buƙatar bayanai daga tebur. A ka'ida, a wannan matakin, ya riga ya zama jaraba don kawai kwafin tebur daga takaddun da aka sani zuwa Kalma kuma kawai manna shi cikin Excel. Wani lokaci yana aiki, amma sau da yawa yana haifar da kowane nau'i na ɓarna bayanai - alal misali, lambobi na iya juya zuwa kwanan wata ko zama rubutu, kamar yadda a cikin yanayinmu, saboda. PDF yana amfani da masu rarrabawa:
Don haka kada mu yanke sasanninta, amma sanya komai ya zama ɗan rikitarwa, amma daidai.
Mataki 2: Ajiye Takardun azaman Shafin Yanar Gizo
Don loda bayanan da aka karɓa a cikin Excel (ta hanyar Query Power), takaddun mu a cikin Kalma yana buƙatar adanawa a cikin tsarin gidan yanar gizon - wannan tsari shine, a wannan yanayin, nau'in ma'ana gama gari tsakanin Kalma da Excel.
Don yin wannan, je zuwa menu Fayil - Ajiye azaman (Fayil - Ajiye As) ko danna maɓallin F12 a kan madannai kuma a cikin taga da ke buɗewa, zaɓi nau'in fayil ɗin Shafin yanar gizo a cikin fayil ɗaya (Shafin Yanar Gizo - Fayil ɗaya):
Bayan adanawa, ya kamata ku sami fayil tare da tsawo na mhtml (idan kun ga kari na fayil a cikin Explorer).
Mataki na 3. Loda fayil ɗin zuwa Excel ta hanyar Query Query
Kuna iya buɗe fayil ɗin MHTML da aka ƙirƙira a cikin Excel kai tsaye, amma sannan za mu sami, da farko, duk abubuwan da ke cikin PDF a lokaci ɗaya, tare da rubutu da ɗimbin tebur ɗin da ba dole ba, kuma, na biyu, za mu sake rasa bayanai saboda kuskure. masu rabuwa. Saboda haka, za mu yi shigo da zuwa cikin Excel ta hanyar ƙara-in Query Query. Wannan ƙari ne gaba ɗaya kyauta wanda zaku iya loda bayanai zuwa Excel daga kusan kowane tushe (fayil, manyan fayiloli, bayanai, tsarin ERP) sannan ku canza bayanan da aka karɓa ta kowace hanya mai yuwuwa, kuna ba shi siffar da ake so.
Idan kuna da Excel 2010-2013, to zaku iya saukar da Query Query daga gidan yanar gizon Microsoft na hukuma - bayan shigarwa zaku ga shafin. Tambayar .arfi. Idan kuna da Excel 2016 ko sabo, to ba kwa buƙatar saukar da komai - duk ayyukan an riga an gina su cikin Excel ta tsohuwa kuma suna kan shafin. data (Kwanan wata) cikin rukuni Sauke kuma Juya (Samu & Canza).
Don haka mu je ko dai zuwa shafin data, ko a kan tab Tambayar .arfi kuma zaɓi ƙungiya Don samun bayanai or Ƙirƙiri Tambaya - Daga Fayil - Daga XML. Don ganin ba fayilolin XML kawai ba, canza masu tacewa a cikin jerin zaɓuka a cikin ƙananan kusurwar dama na taga zuwa. Duk fayiloli (Duk fayiloli) kuma saka fayil ɗin MHTML ɗin mu:
Lura cewa shigo da kaya ba zai yi nasara ba, saboda. Tambayar Wuta tana tsammanin XML daga gare mu, amma a zahiri muna da tsarin HTML. Don haka, a cikin taga na gaba da ya bayyana, kuna buƙatar danna-dama akan fayil ɗin da ba a iya fahimtar Query Query kuma saka tsarinsa:
Bayan haka, za a gane fayil ɗin daidai kuma za mu ga jerin duk allunan da ya ƙunshi:
Kuna iya duba abubuwan da ke cikin tebur ɗin ta danna maɓallin linzamin kwamfuta na hagu a cikin farin bango (ba a cikin kalmar Tebu ba!) Na sel a cikin ginshiƙi na bayanai.
Lokacin da aka bayyana teburin da ake so, danna kan koren kalmar Table - kuma kun "fadi" cikin abinda ke ciki:
Ya rage don yin ƴan matakai masu sauƙi don “ tsefe” abinda ke cikinsa, wato:
- share ginshiƙan da ba dole ba (danna dama akan taken shafi - cire)
- maye gurbin dige-dige da waƙafi (zaɓa ginshiƙai, danna dama- Maye gurbin dabi'u)
- cire daidai alamun a cikin taken (zaɓa ginshiƙai, danna-dama - Maye gurbin dabi'u)
- cire layin saman (Gida – Share layi – Share manyan layukan)
- cire m Lines (Gida - Share layuka - Share layukan wofi)
- ɗaga layin farko zuwa kan teburin tebur (Gida – Yi amfani da layin farko azaman kanun labarai)
- tace bayanan da ba dole ba ta amfani da tacewa
Lokacin da aka kawo tebur zuwa tsarin sa na yau da kullun, ana iya sauke shi a kan takardar tare da umarni rufe da saukewa (Rufe & Loda) on babban tab. Kuma za mu sami irin wannan kyakkyawa wanda za mu iya yin aiki da shi:
- Canza Shagon zuwa Tebur tare da Tambayar Wuta
- Rarraba rubutun m zuwa ginshiƙai