Hi All, You can pull the parameter from excel using shell script below is the code please check here i am using a google spreadsheet and fetch the particular field, you can fetch multiple fields also
#URL= https://docs.google.com/spreadsheets/d/e/2PACX-1vTSkSdNFjtRjZGzsf5NO3TJdaMeBNTYplU8EdN0iXUQXFMVIsdmf9N0g6X1eUYFpchxhE4/pub?output=txt #URL= https://docs.google.com/spreadsheets/d/e/2PACX-1vTSkSdNFjtRjwYt7wpjZGzsf5NO3TJYplU8EdN0iXUQXFMVIsdmf9N0g6X1eUYFpchxhE4/pub?output=txt RESULT=$(wget --no-check-certificate -q -O - $URL | sed '1 d' | cut -f7 ) echo ${RESULT} >/var/lib/jenkins/workspace/output/FrameWork.txt RESULT1=$(wget --no-check-certificate -q -O - ' https://docs.google.com/spreadsheets/d/e/2PACX-1vTn0s1SuFDDo6M2C1Ey_hrP9rxlb-Uap2ciD77GZdvjZeWzf_mk0fPrHgVa0W5EYM/pub?gid=1140914179&output=txt' | sed '1 d' | cut -f7 ) echo ${RESULT1} >/var/lib/jenkins/workspace/output/output.txt hope this will work for you Thanks B.M. Wadia On Thu, Jul 16, 2020 at 1:30 AM Slide <[email protected]> wrote: > Also, can you show how you would want something like this to work? > > On Wed, Jul 15, 2020 at 12:16 PM 'David Riemens' via Jenkins Users < > [email protected]> wrote: > >> Is XLS a requirement? >> >> If not too difficult you could go for a simpler format (INI ?) that you >> could parse using some relatively simple Groovy code ? >> >> >> >> >> >> >> >> *From: *Slide <[email protected]> >> *Sent: *Wednesday, July 1, 2020 21:56 >> *To: *Jenkins User Mailing List <[email protected]> >> *Subject: *Re: How to pull parameters from excel sheet and pass it to job >> >> >> >> I don't think there is a way to do this right now. >> https://plugins.jenkins.io/ui/search?query=excel >> >> >> >> You may need to do something in a shared library or something similar. >> >> >> >> On Wed, Jul 1, 2020 at 12:45 PM Devops-warrior <[email protected]> >> wrote: >> >> I have a job which will deploy web, app and DB servers into AWS cloud. As >> of now we are taking Ip's for each server from Network team and passing >> manually in build paremeters. Can someone help me? how to pull parameters >> from excel sheet and pass it on to jenkins job. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com >> <https://groups.google.com/d/msgid/jenkinsci-users/73b11319-7504-4539-9758-4f1100e79236o%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> >> >> >> -- >> >> Website: http://earl-of-code.com >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com >> <https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVeE48U53fp7k-%3D72GwjF6%3DTAHuijShuVaOdSirsiEEGMw%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jenkinsci-users/5f0f5621.1c69fb81.ee4cb.492fSMTPIN_ADDED_MISSING%40gmr-mx.google.com >> <https://groups.google.com/d/msgid/jenkinsci-users/5f0f5621.1c69fb81.ee4cb.492fSMTPIN_ADDED_MISSING%40gmr-mx.google.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > Website: http://earl-of-code.com > > -- > You received this message because you are subscribed to the Google Groups > "Jenkins Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVcafOG%2BdjeRf0b5b%2BPzPRVrZH_%2B2oA0niTmhbQE%2BYpiEg%40mail.gmail.com > <https://groups.google.com/d/msgid/jenkinsci-users/CAPiUgVcafOG%2BdjeRf0b5b%2BPzPRVrZH_%2B2oA0niTmhbQE%2BYpiEg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPEKM0puP6c7UdaXGbnYv7t0GSDtqXX%3D11kMWAiibHmiq8LfOg%40mail.gmail.com.
