Python Forum
find cell value with matching regular expression of a row in excel file
Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
find cell value with matching regular expression of a row in excel file
#2
Hi hruday,

If I understand correctly, you know the row number of the current row,
Quote:print (cell.row,cell.column)
 so can you not run the if test on the next row by using the row value of cell.row and adding a 1? so this would be "cell.row +1"

Or have I missed the point, let me  know.

Good Luck

Bass

"The good thing about standards is that you have so many to choose from" Andy S. Tanenbaum
Reply


Messages In This Thread
RE: find cell value with matching regular expression of a row in excel file - by Bass - Jul-05-2017, 11:29 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Regular expression help anilrajr 4 558 May-08-2024, 06:18 PM
Last Post: deanhystad
  Matching string from a file tester_V 5 655 Mar-05-2024, 05:46 AM
Last Post: Danishhafeez
  Python openyxl not updating Excel file MrBean12 1 532 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 609 Feb-07-2024, 12:24 PM
Last Post: Viento
  data validation with specific regular expression shaheen07 0 435 Jan-12-2024, 07:56 AM
Last Post: shaheen07
  Search Excel File with a list of values huzzug 4 1,446 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 1,044 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  FileNotFoundError: [WinError 2] The system cannot find the file specified NewBiee 2 1,806 Jul-31-2023, 11:42 AM
Last Post: deanhystad
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,256 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Cannot find py credentials file standenman 5 1,811 Feb-25-2023, 08:30 PM
Last Post: Jeff900

Forum Jump:

User Panel Messages

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