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?
#5
I have checked and recheked the operation, and I stand by what I wrote. There is no possibility of error. I have 3 windows open in my screen: the 2 excel files, and the Pyscripter window. I created the first excel file, and saved it. Then saved it 'save as' with a new name that differs from the first one just in one character. Then I perform the 2 delete operations in parallel in both files and save both files. Then I run the script in both files. What I have now in my screen is 2 visually identical files with a different row count in python. I also saved the wrong file 3 more times just for if this could force to empty a memory caché; to no avail.No mistake possible.
The only correction I make is the excel version I have: 2016, not 2006.
Thanks for your interest.
Reply


Messages In This Thread
RE: opepyxl not counting rows in spreadsheets? - by jjartus - Mar-06-2020, 05:49 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Combining Spreadsheets Py3_14 4 658 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,785 Aug-19-2021, 03:08 PM
Last Post: johnbernard
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,152 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,289 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
Question How to make a 3D List of Excel Spreadsheets? chatguy 4 2,794 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