+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Validate Excel with text in text file (/thread-14495.html)
Validate Excel with text in text file - Vinci141 - Dec-03-2018
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
RE: Validate Excel with text in text file - Larz60+ - Dec-03-2018
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.
RE: Validate Excel with text in text file - Vinci141 - Dec-03-2018
(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.
RE: Validate Excel with text in text file - Larz60+ - Dec-03-2018
For packages:
I think Pandas is the one most often used today.
For others, see: https://pypi.org/search/?q=excel