Python Forum
Validate Excel with text in text file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Validate Excel with text in text file
#1
Hello,

I am looking after ways to validate excel cell content which is mentioned in a text file.
Text file also contains predefined values in those cell address
Example
text file contains below
r1c1="Project_Name"

here, r1c1=Row 1 col =1 of excel sheet. It must contains "Project_Name" as content.

I assume this is going to be very large and thus, any formulae to achieve shall be thankful.
Please advise.

Thanks
Reply


Messages In This Thread
Validate Excel with text in text file - by Vinci141 - Dec-03-2018, 02:14 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Cleaning a dataset: How to extract text between two patterns Palke 0 1,156 Mar-06-2023, 05:13 PM
Last Post: Palke
  Extracting tables and text above the table from a PDF to CSV DivAsh 3 2,492 Jan-18-2023, 07:39 AM
Last Post: perfringo
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,049 Jan-09-2023, 08:14 PM
Last Post: PY_ALM
  Make unique id in vectorized way based on text data column with similarity scoring ill8 0 894 Dec-12-2022, 03:22 AM
Last Post: ill8
  Reading large crapy text file in anaconda to profile data syamatunuguntla 0 834 Nov-18-2022, 06:15 PM
Last Post: syamatunuguntla
  validate the existing value and change the series datahub 0 1,212 May-03-2022, 08:00 PM
Last Post: datahub
  Extracting Text standenman 5 2,275 Nov-01-2021, 10:49 PM
Last Post: Gribouillis
  How to recognize negative in a text? AlekseyPython 1 1,847 Oct-06-2021, 10:09 AM
Last Post: Larz60+
  Checking for a recognized text in a Dataframe KDE 0 1,545 Aug-31-2021, 11:19 PM
Last Post: KDE
  Creating more than one excel File at once malvarez1976 0 1,818 Dec-15-2020, 02:04 AM
Last Post: malvarez1976

Forum Jump:

User Panel Messages

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