Excel sheet as a build parameter to Jenkins

[chenna keshav]

Hi Guys,

I would like to know that is there any way that we could pass Excel sheet as a build parameter to Jenkins standalone project..

Thanks,
Keshav

[Ivan Fernandez Calvo]

I do not think that you can pass an excel file to a build to use it as parameters, but the readCSV step can read CSV files generated with Excel see https://jenkins.io/doc/pipeline/steps/pipeline-utility-steps/#readcsv-read-content-from-a-csv-file-in-the-workspace so you can pass a CSV file and use it to export environment variables to use them on your build, I've made something similar recently but with properties files this is the code

```

          def config = readProperties(file: 'my-porperties.properties')

          config.each { k, v ->

              env."${k}" = v

          }

```