Web Scraping and Excel Automation with Python

#Daily Star News Site Scraping Program
#import all the required libraries
#create a blank work book
#we want scraping to be store in an excel file
#get the current date
#crete a new sheet
#use iteration to store data
#save the workbook
#Script Written By : Ayan Upadhaya, contact: ayanU881@gmail.com

import requests

import openpyxl

from bs4 import BeautifulSoup as bs

from datetime import datetime

"""WEB SCRAPING"""
base_link="https://www.thedailystar.net/"
response=requests.get(base_link).content
soup=bs(response,"html.parser")
data=soup.find_all('div',class_="list-content")



"""EXCEL AUTOMATION"""

wb=openpyxl.Workbook()

current=datetime.date(datetime.now())

wb.create_sheet(index=1,title=str(current))

sheet=wb[str(current)]

sheet['A1']="Title"
sheet['B1']="URL"

i=2
for collections in data:
    title=collections.h5.text
    url=collections.h5.a.get('href')
    sheet['A'+str(i)]=title
    sheet['B'+str(i)]=base_link+url

    i+=1

wb.save('star.xlsx')

print("Success!")