Python Forum
Project, Reading Data from a spreadsheet. Error message!!
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Project, Reading Data from a spreadsheet. Error message!!
#2
Depreciation warning is clear
instead of sheet=wb.get_sheet_by_name('Population by Census Tract') use sheet=wb['Population by Census Tract']

Looking at the file name it's a census data, so I guess great number of rows/records. You print writing results... and Done after writing each row, so I would expect some long output.
Note that it doesn't make to open and close the file for every row. Also it's better to use with context manager when open the file and thus no need to close it.

Once again - I would advise you to find more up to date/better book to follow
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
RE: Project, Reading Data from a spreadsheet. Error message!! - by buran - Sep-27-2019, 10:44 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading an ASCII text file and parsing data... oradba4u 2 267 Jun-08-2024, 12:41 AM
Last Post: oradba4u
  Is it possible to extract 1 or 2 bits of data from MS project files? cubangt 8 1,395 Feb-16-2024, 12:02 AM
Last Post: deanhystad
  Returning Column and Row Data From Spreadsheet knight2000 0 535 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Editing spreadsheet/csv BSDevo 6 1,226 Sep-01-2023, 05:47 PM
Last Post: BSDevo
  Error message about iid from RandomizedSearchCV Visiting 2 1,193 Aug-17-2023, 07:53 PM
Last Post: Visiting
  xlwings error when reading a workbook Mishal0488 1 1,279 Aug-01-2023, 02:05 AM
Last Post: deanhystad
  Another Error message. the_jl_zone 2 1,087 Mar-06-2023, 10:23 PM
Last Post: the_jl_zone
  Looking to automate updating a spreadsheet with image from email cubangt 2 1,105 Feb-14-2023, 03:43 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 959 Jan-24-2023, 02:48 PM
Last Post: demdej
  Reading All The RAW Data Inside a PDF NBAComputerMan 4 1,539 Nov-30-2022, 10:54 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020