I would like Pandas to create a new sheet in an existing workbook every time the script is ran.
Below is the data that is being written
Is there a way to do this?
df = pd.DataFrame(zip(house_name,description_details,house_price,specs,ratings,cancellation_policy,urls),columns=['Property Name','Description','Price','Specifications','Ratings','Cancellation Policy','Link'])
df.to_excel(**File Path**)