Yes, i can convert the Excel sheet to a delimited text file.
If you have a sample bat i can work with, that would be great. Thanks!
Search found 2 matches
- 17 Mar 2021 10:16
- Forum: DOS Batch Forum
- Topic: Command query on excel file
- Replies: 5
- Views: 5681
- 16 Mar 2021 20:51
- Forum: DOS Batch Forum
- Topic: Command query on excel file
- Replies: 5
- Views: 5681
Command query on excel file
Hi. I have a sample excel sheet with 3 (or more) columns below: cat1 kitty black cat2 furry yellow cat3 missy black dog1 baxter white dog2 ellon red fish1 gold yellow fish2 fin red I need a command/script/batch file that queries from a certain column (say 1st column), then displays the result from s...