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 <slide.o....@gmail.com> 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 < > jenkinsci-users@googlegroups.com> 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 <slide.o....@gmail.com> >> *Sent: *Wednesday, July 1, 2020 21:56 >> *To: *Jenkins User Mailing List <jenkinsci-users@googlegroups.com> >> *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 <awscloud...@gmail.com> >> 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 jenkinsci-users+unsubscr...@googlegroups.com. >> 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 jenkinsci-users+unsubscr...@googlegroups.com. >> 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 jenkinsci-users+unsubscr...@googlegroups.com. >> 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 jenkinsci-users+unsubscr...@googlegroups.com. > 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 jenkinsci-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jenkinsci-users/CAPEKM0puP6c7UdaXGbnYv7t0GSDtqXX%3D11kMWAiibHmiq8LfOg%40mail.gmail.com.
