HI
I am a newbie and looking if someone can help me with the following
I have a excel file with 10 columns from A to J. I need to search the column J for specific keywords ("gold", "buffer", "overflow" etc) and if the keyword matches then output the entire row from excel file. Kindly help
Best
need to help to search specific keywords in excel file specific column and printout matched lines
Moderator: DosItHelp
Re: need to help to search specific keywords in excel file specific column and printout matched lines
You can do this with a Vbscript or Powershell. Batch Files cannot read or write Excel files.
-
- Expert
- Posts: 1166
- Joined: 06 Sep 2013 21:28
- Location: Virginia, United States
Re: need to help to search specific keywords in excel file specific column and printout matched lines
What kind of Excel file?
CSV? XLS? XLSX? Something else entirely?
CSV? XLS? XLSX? Something else entirely?
Re: need to help to search specific keywords in excel file specific column and printout matched lines
Hi the file is in format .xlsx. can someone help me with this please