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
  Extracting Text standenman 5 444 Nov-01-2021, 10:49 PM
Last Post: Gribouillis
  How to recognize negative in a text? AlekseyPython 1 436 Oct-06-2021, 10:09 AM
Last Post: Larz60+
  Checking for a recognized text in a Dataframe KDE 0 524 Aug-31-2021, 11:19 PM
Last Post: KDE
  Python - Merge existing cells of Excel file created with xlsxwriter manonB 0 1,236 Mar-10-2021, 02:17 PM
Last Post: manonB
  Creating more than one excel File at once malvarez1976 0 747 Dec-15-2020, 02:04 AM
Last Post: malvarez1976
  Most Compatible Text Editor to Handle Large Files? Robotguy 2 1,247 Aug-18-2020, 03:51 PM
Last Post: FortyTwo
  Filter rows by multiple text conditions in another data frame i.e contains strings an Pan 0 1,143 Jun-09-2020, 06:05 AM
Last Post: Pan
  Can't read text file with pandas zinho 6 7,432 May-24-2020, 06:13 AM
Last Post: azajali43
  Text pre-processing issue PythonSpeaker 0 953 Mar-23-2020, 08:42 PM
Last Post: PythonSpeaker
  Can python read Marathi text files and summarize them? mcp111 0 898 Mar-18-2020, 08:58 AM
Last Post: mcp111

Forum Jump:

User Panel Messages

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