Kokani mwachangu deta kuchokera pafayilo ya PDF, ikani mu pepala la Excel, ndikuwonjezera zokolola zanu.
Ngati muli ndi data mu PDF, monga chikalata chanu chaku banki kapena data ina yazachuma, ndipo mukufuna kuilowetsa mufayilo ya Excel, simuyenera kuyang'ana mapulogalamu ena aliwonse. Mutha kugwiritsa ntchito PDF Data Connector, yomwe ndi chida chopangidwa mu Microsoft Excel.
Mutha kulowetsa mosavuta matebulo ndi/kapena zomwe zasungidwa mufayilo ya PDF kukhala pepala la Excel pogwiritsa ntchito izi. Komanso, mutha kusinthanso deta musanayitumize ku Excel pogwiritsa ntchito Power Query Editor yomwe ilinso gawo la chida ichi. Chidachi chimapezeka kwa ogwiritsa ntchito a Microsoft 365 okha.
Kokani deta kuchokera ku PDF kupita ku pepala la Excel
Kulowetsa deta mu pepala la Excel ndi njira yowongoka kwambiri. Chofunikira chokha ndikuti pepala la Excel lisungidwe pa voliyumu yanu yachiwiri.
Kuti mulowetse deta kuchokera ku fayilo ya PDF, choyamba, tsegulani Microsoft Excel. Pitani ku menyu yoyambira ndikulemba Excelkuchita kusaka. Kenako dinani Microsoft Excel kuti mutsegule pulogalamuyi.
Kenako, alemba pa "Chopanda Ntchito Buku" njira kupitiriza.
Kenako, dinani tabu ya Data kuchokera pa riboni menyu ndiyeno dinani pa Pezani Data kuti mupitilize. Kenako, yang'anani pachosankha Chochokera ku Fayilo ndiyeno dinani Kuchokera pa Fayilo ya PDF kuchokera pa submenu. Izi zidzatsegula zenera lapadera lofufuzira mafayilo pazenera lanu.
Kenako, pezani ndikusankha fayilo yomwe mukufuna kuyitanitsa kuchokerako ndikudina. Kenako dinani "Open" batani kutsegula deta. Izi zidzatsegula zenera lapadera pazenera lanu.
Tsopano, kuchokera pazenera la Navigator, zigawo zonse zosankhidwa (matebulo kapena masamba) za PDF ziziwonekera kumanzere chakumanzere. Mutha kusankha gawo linalake podina kapena kugwiritsa ntchito njira yosakira. Kuwoneratu kudzatsegulidwa pagawo lakumanja. Mukhozanso kusankha tsamba lonse. Mukasankhidwa, dinani batani la Katundu kuti mulowetse deta mwachindunji ku Excel, kapena dinani batani la Convert Data kuti mupitilize.
Ngati mwadina batani la Convert Data mu sitepe yapitayi, deta idzawonetsedwa pawindo lapadera mumtundu wosinthika. Ngati mukusintha tebulo, mutha kuwonjezera/kusintha ndime ndi dzina la mzere ndi data ya tebulo. Mutha kugwiritsanso ntchito zida zosiyanasiyana zoperekedwa mu riboni menyu kuti musinthe zomwe mukufuna.
Pambuyo posintha zofunikira pazambiri, dinani "Tsegulani ndi Katundu" kuti mulowetse mu Excel sheet.
Zomwe zatsitsidwa, mudzatha kuziwona papepala la Excel.
Ndi zimenezotu guys. Nthawi ina mukafuna kugwira ntchito ndi data yosungidwa mumtundu wa PDF, mutha kuyitanitsa mwachangu ku Excel osasokoneza zokolola.
