Forum Discussion
jchemis
Mar 11, 2023Copper Contributor
unable to disable/delete embedded Web Query links in excel - screen shots added
I have created a worksheet using "web select" to input data from financial statements online. This is supposed to save me time and effort of manually typing in and proofreading thousands of lines o...
jchemis
Mar 12, 2023Copper Contributor
Hmmm. that sounds like it should simplify my life!
does that apply to my situation?
....I am trying to pull down YEARS of data from financial institutions which currently only offer PDF downloads for data older than 18 months (useless to me, since i need transactional data in excel format, CSV might work, or a reliable method of PDF to ANY format without EXTENSIVE rework to format properly)
peiyezhu
Mar 12, 2023Bronze Contributor
I have no idea your case in detail.
if you want to parse PDF file,there are many api service available.
adobe pdf api
c# aspire
https://developer.adobe.com/document-services/apis/pdf-services/
and online pdf to excel
https://smallpdf.com/pdf-to-excel
pdf to text
http://e.anyoupin.cn/bsbm/stu60/a83/spire/upload_pdf.html
if you want to parse PDF file,there are many api service available.
adobe pdf api
c# aspire
https://developer.adobe.com/document-services/apis/pdf-services/
and online pdf to excel
https://smallpdf.com/pdf-to-excel
pdf to text
http://e.anyoupin.cn/bsbm/stu60/a83/spire/upload_pdf.html
- peiyezhuMar 13, 2023Bronze Contributorapi is a interface or software package by which support program language (e.g c# php java) can automate your work.
- jchemisMar 12, 2023Copper Contributor
I cannot find a method to accurately parse data via the VERY expensive Acrobat PDF software (with CRAP support) I already own..... thank you for your input.
I'm not sure what is API, but looking into that...
not sure why I am investing so heavily in Acrobat, when I can't already "online pdf to excel", but looking into that.
I will try the other option (pdf to text) you offered...Maybe I am over-invested in Acrobat?
THANK YOU!