Forum Discussion
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...
https://techcommunity.microsoft.com/t5/excel/cell-has-a-list-wrapped-in-html-split-list-into-2-separated-by/td-p/3763726
Do you want to clean data after having downloaded datas from web like above case?
Do you want to clean data after having downloaded datas from web like above case?
Thanks for your reply, I am not sure how to respond to your question because I doin't understand what you are asking. But I am NOT downloading - I am using Micorsoft's Edge tool "Web Select" via a copy&paste type of method.
Web Select - first copy into Word - then copy and paste to Excel appears to not include hidden code, until copy and paste to Excel proves the formulas and conditional formatting do not work properly due to the hidden/embedded code (Web Query).
do you want to fetch data directly from the website rather than "Web Select" via a copy (like below) & paste?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)- 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