
perlmagix
Novice
Mar 17, 2016, 11:52 PM
Post #1 of 2
(12873 views)
|
csv-passingparameter-print-output-value-from-specific-column-and-row
|
|
|
Extracting specific excel cell values with usage of passing parameters Point1: Specific rows have to be picked up based on the entered passing parameters. Point2: extract values from specific column from the picked rows based on entered passing parameters. Attached excel file "Book1.csv" can be used for detailed understanding. In CSV file, header consists of following columns apple bus cat deer egg frog If the entered passing parameters are "red" and "cat1", row 2 from the csv should be picked up and the output should be displayed as "deer1", ""frog1" If the entered passing parameters are "red" and "cat2", row 2 from the csv should be picked up and the output should be displayed as "deer23", ""frog434"
|