Click here to Skip to main content
15,886,049 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am needing help to find and replace text in an excel file. I would like to loop through a list box or a text file to accomplish this. The text will not always be the same. The reason for this is because I am getting usernames from an OU in active directory. Then I would like to search for each user name in the list box to see if it is in the excel spreadsheet. If it is, then replace it with an empty value. So the end result will be an empty cell. There will be multiple entries for each user name. I already have the code to get the usernames, just need help doing a find and replace in excel using c#. I have a winform setup with a button and 2 listboxes. The one on the left will display the usernames, and I would like the one on the right to display the end result. ie: deleted -or- not found.
Posted
Comments
Rock (Multithreaded) 21-Feb-14 6:27am    
If you're talking about data communication between .Net and Excel Sheet.
Please check this link:
http://aruny408.blogspot.com/p/export.html
ZurdoDev 21-Feb-14 7:37am    
Are you asking someone to do all the work for you or do you have a specific question?
Miller Jake 21-Feb-14 12:06pm    
I would like to know how to do the find and replace

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900