Creating an Instagram bot with reading an excel file and posing on Instagram but some of words can not be read properly

0 votes
from instabot import Bot
import openpyxl
import smtplib

bot = Bot()
bot.login(username="xxx", password="xxx")

filepath = "C:/Users/Username/OneDrive/Desktop/excel/instagram2.xlsx"
wb = openpyxl.load_workbook(filepath)
sheet = wb.get_sheet_by_name("insta")
for i in range(2,7):
    bot_name = sheet.cell(row=i, column=1).value
    price = sheet.cell(row=i, column=3).value
    title = sheet.cell(row=i, column=4).value
    hashtag = sheet.cell(row=i, column=5).value
    url = sheet.cell(row=i, column=6).value
    description = str(title+"\n\n"+price+"\n\n"+hashtag+"\n\n"+url)
    img = "C:/Users/Username/OneDrive/Desktop/instagram/instagram.bot"+str(i)+".jpg"
    bot.upload_photo(img,caption=description)

For me, I made an Instagram bot. My posts' descriptions are in Excel. Only the URL can be recognized as a string of words rather than the actual URL when the software posts on Instagram. Therefore, you cannot enter the URL site when you click the "URL". How do I enable the application to identify it as a URL?

Sep 26, 2022 in Others by Kithuzzz
• 38,010 points
483 views

1 answer to this question.

0 votes

 The (account name) test1 100 euro #mountain #climbing #safe #nomountainnolife amazon.de 

I hope this makes some sense. 

answered Sep 29, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
0 answers
0 votes
0 answers

can the font type of an Edittext,Radio Button and CheckBox be changed in Android

TextView text = (TextView) layout.findViewById(R.id.text); text.setText(msg); Typeface font = ...READ MORE

Jun 22, 2022 in Others by nisha
• 2,210 points
318 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,420 points
641 views
0 votes
1 answer

Python - how to read contents of an excel file

xlwings is an excellent library to interact with ...READ MORE

answered Dec 15, 2022 in Others by narikkadan
• 63,420 points
292 views
0 votes
2 answers
+1 vote
2 answers

how can i count the items in a list?

Syntax :            list. count(value) Code: colors = ['red', 'green', ...READ MORE

answered Jul 7, 2019 in Python by Neha
• 330 points

edited Jul 8, 2019 by Kalgi 4,023 views
0 votes
1 answer
0 votes
1 answer

How to find out how many rows and columns to read from an Excel file with PHPExcel?

Solution: $file_name = htmlentities($_POST['file_name']); $sheet_name = htmlentities($_POST['sheet_name']); $number_of_columns = htmlentities($_POST['number_of_columns']); $number_of_rows ...READ MORE

answered Oct 23, 2022 in Others by narikkadan
• 63,420 points
6,642 views
0 votes
1 answer

Can an Excel xll function indicate that the return value should be displayed as a date and not a number?

To my knowledge, the only method to ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,420 points
490 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP