Python Forum
opepyxl not counting rows in spreadsheets?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
opepyxl not counting rows in spreadsheets?
#10
I was about to suggest you report the problem if you think you have found a bug, but found that this was discussed on number of occasions, e.g.:
https://bitbucket.org/openpyxl/openpyxl/...han-actual

See author's comments. It looks at sheet dimensions property and obviously styles, fonts, cell format, etc. also count, not only cell content

By the way, your latest example with empty sheet works exactly as excel would do in VBA, i.e. last row on empty sheet is 1.
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: opepyxl not counting rows in spreadsheets? - by buran - Mar-07-2020, 07:58 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Combining Spreadsheets Py3_14 4 655 Feb-07-2024, 04:58 PM
Last Post: deanhystad
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,653 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Merging spreadsheets with the same columns and extracting rows with matching entries johnbernard 3 10,731 Aug-19-2021, 03:08 PM
Last Post: johnbernard
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,151 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,262 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
Question How to make a 3D List of Excel Spreadsheets? chatguy 4 2,793 Jan-24-2021, 05:24 AM
Last Post: buran
  IDE with spreadsheets lewispgj 4 2,353 Mar-13-2020, 09:45 PM
Last Post: lewispgj

Forum Jump:

User Panel Messages

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