ITSE 1359 – Program12 Page 1 of 2 General Points • Program12 can be completed using content from the following chapters: o Python @ ACC - Welcome! through File I/O & Modules o Textbook - Chapters 6 –...

1 answer below »
In PDF file.



ITSE 1359 – Program12 Page 1 of 2 General Points • Program12 can be completed using content from the following chapters: o Python @ ACC - Welcome! through File I/O & Modules o Textbook - Chapters 6 – 14 with emphasis on 12, 13, and 14 • You are encouraged to work with Google Spreadsheets. However, this optional since it requires the use of your Google account to enable the API. • Create a file named program12.py. • Do not repeat identical examples from the course material. Requirements (these are the requirements to identify by number): See the Resources link in Blackboard to download files required by Program12. 1. Output a header in the console: “This is Program12 - ” 2. Print “This program demonstrates using Python to perform web scraping and working with Excel spreadsheets.” 3. Ask the user to copy a U.S. street address to the clipboard. Programmatically open a web browser with Google maps pointing to the address supplied by the user. 4. Ask the user to enter the URL of a web page. Programmatically select the


elements on the page and display the text of each


. 5. Create a class named ExcelProcessing. Use that class and any other functions you may need to organize the operations of this program. Include the data and functions in the class to perform the requirements below. https://www.austincode.com/itse1359/ https://automatetheboringstuff.com/ ITSE 1359 – Program12 Page 2 of 2 6. Display the list of sheets in example.xlsx. 7. Inform the user of cells that can be read from example.xlsx and ask the user to enter a cell (e.g. B7). Display the value located in that cell (e.g. Strawberries). 8. Ask the user to enter a rectangular section from example.xlsx (e.g. A3:C7). Display the values in the cells of that rectangular section. 9. Print a statement explaining your experiences with Program12. Make this authentic (minimum of 2-3 sentences). TEST – TEST – TEST your application to ensure the requirements are met. • Use the list above and the common requirements as a checklist. • Not meeting all requirements = 0 points for the assignment.

Answered Same DayNov 25, 2021

Answer To: ITSE 1359 – Program12 Page 1 of 2 General Points • Program12 can be completed using content from the...

Vicky answered on Nov 27 2021
137 Votes
'''This is Program12 - Matthew'''
print("This program demonstrates using Python to perform web scra
ping and working with Excel spreadsheets.")
# command line or clipboard.
import webbrowser, sys, pyperclip
address = input('Enter an address: ')
pyperclip.copy(address)
webbrowser.open('https://www.google.com/maps/place/' + address)
import requests, bs4
url = input('Enter a url of webpage: ')
res = requests.get(url)
soup = bs4.BeautifulSoup(res.text, 'html.parser')
pElems = soup.select('p')
for pElem in pElems:
print(pElem.getText())
import openpyxl
from openpyxl.utils import...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here