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
#2
what have you tried so far?
If you want someone to write this code for you, post in Jobs section and give information concerning compensation offered, and other particulars.
Reply
#3
(Dec-03-2018, 03:33 PM)Larz60+ Wrote: what have you tried so far?
If you want someone to write this code for you, post in Jobs section and give information concerning compensation offered, and other particulars.

I haven't tried this as i am unable to figure out how to achieve this. I am seeking information on approach+package info(if feasible) but not coding help.
Reply
#4
For packages:
I think Pandas is the one most often used today.
For others, see: https://pypi.org/search/?q=excel
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Cleaning a dataset: How to extract text between two patterns Palke 0 1,138 Mar-06-2023, 05:13 PM
Last Post: Palke
  Extracting tables and text above the table from a PDF to CSV DivAsh 3 2,389 Jan-18-2023, 07:39 AM
Last Post: perfringo
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,012 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 861 Dec-12-2022, 03:22 AM
Last Post: ill8
  Reading large crapy text file in anaconda to profile data syamatunuguntla 0 811 Nov-18-2022, 06:15 PM
Last Post: syamatunuguntla
  validate the existing value and change the series datahub 0 1,191 May-03-2022, 08:00 PM
Last Post: datahub
  Extracting Text standenman 5 2,204 Nov-01-2021, 10:49 PM
Last Post: Gribouillis
  How to recognize negative in a text? AlekseyPython 1 1,812 Oct-06-2021, 10:09 AM
Last Post: Larz60+
  Checking for a recognized text in a Dataframe KDE 0 1,518 Aug-31-2021, 11:19 PM
Last Post: KDE
  Creating more than one excel File at once malvarez1976 0 1,791 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