Python Forum

Full Version: Validate Excel with text in text file
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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.
(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.
For packages:
I think Pandas is the one most often used today.
For others, see: https://pypi.org/search/?q=excel