I am wiritng a Python script using Excel COM APIs. I wanted to search for a string in a excell cell ,once found I want to return the cell index(like A2 or B3). what is the API I have to use for this..
Thx, Jose
-
Please have a look at win32com library. It's pretty useful in such cases.– Chirag BansalCommented Feb 13, 2023 at 10:03
Add a comment
|
1 Answer
If you deal with open XML documents in Excel you may consider using the Open XML SDK for such tasks, see Welcome to the Open XML SDK 2.5 for Office for more information. You can try to search for any Python packages that provides the same functionality. See Extracting Data from Excel Files for more information.
Also you may consider automating Excel from Python. Read more about that in the Read only Excel Cells with values python win32com thread which also provides a sample code for that.
answered Feb 13, 2023 at 13:24
