need to help to search specific keywords in excel file specific column and printout matched lines

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
gotowebs
Posts: 2
Joined: 18 Dec 2017 07:34

need to help to search specific keywords in excel file specific column and printout matched lines

#1 Post by gotowebs » 18 Dec 2017 07:40

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

Squashman
Expert
Posts: 4486
Joined: 23 Dec 2011 13:59

Re: need to help to search specific keywords in excel file specific column and printout matched lines

#2 Post by Squashman » 18 Dec 2017 08:50

You can do this with a Vbscript or Powershell. Batch Files cannot read or write Excel files.

ShadowThief
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

#3 Post by ShadowThief » 18 Dec 2017 22:00

What kind of Excel file?

CSV? XLS? XLSX? Something else entirely?

gotowebs
Posts: 2
Joined: 18 Dec 2017 07:34

Re: need to help to search specific keywords in excel file specific column and printout matched lines

#4 Post by gotowebs » 18 Dec 2017 22:09

Hi the file is in format .xlsx. can someone help me with this please

Post Reply