Jan-28-2019, 10:10 PM
Greetings,
I would like to build a tool to open a .csv link on a webpage. I have written the following code and have identified that there is in fact a link to a csv file on the webpage. At this point I am not sure how to proceed. Speaking in pseudo code, I would probably like to define a variable for the csv file and open it. I would then like to run vba code to grab the desired information from the csv file (any ideas on best libraries with these types of tools, that is to run VB from a python mod)
I would like to build a tool to open a .csv link on a webpage. I have written the following code and have identified that there is in fact a link to a csv file on the webpage. At this point I am not sure how to proceed. Speaking in pseudo code, I would probably like to define a variable for the csv file and open it. I would then like to run vba code to grab the desired information from the csv file (any ideas on best libraries with these types of tools, that is to run VB from a python mod)
import requests page = requests.get("http://webpage") from bs4 import BeautifulSoup soup = BeautifulSoup(page.content, 'html.parser') #print (soup) for link in soup.find_all('a'): print(link.get('href'))