# Reading Excel Value

**URL:** <https://community.jenkins.io/t/reading-excel-value/8123>\
**Category:** Ask a question\
**Created:** [June 22, 2023, 8:23am UTC](https://community.jenkins.io/t/reading-excel-value/8123 "2023-06-22T08:23:03Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![MarkEWaite](https://dub1.discourse-cdn.com/flex013/user_avatar/community.jenkins.io/markewaite/32/20_2.png) [@MarkEWaite](https://community.jenkins.io/u/MarkEWaite)\
**Post date:** [June 22, 2023, 11:58am UTC](https://community.jenkins.io/t/reading-excel-value/8123/2 "2023-06-22T11:58:47Z")

</div>

Good advice from @halkeye in an earlier post:

> [@How to use .jxl excel read write libary in Jenkins?](https://community.jenkins.io/t/how-to-use-jxl-excel-read-write-libary-in-jenkins/3753/2):
>
> I would recommend against having your pipeline do any complicated processing like that. Pipeline code gets run on the controller and then directs your agents to do things. If you want to stick with groovy, I would recommend writing a standalone groovy script, with @Grab annotations, that jenkins can call out to. That being said, I think you can use @Grab in shared libraries as well.

There are many solutions to read an Excel file. Jenkins jobs can call any of them using a `bat` step or a `powershell` step. Some examples from a quick google search include:

- Quora articles answering [“What is the best programming language for Excel?”](https://www.quora.com/What-is-the-best-programming-language-for-Excel)
- Microsoft article on [Programming with the C API in Excel](https://learn.microsoft.com/en-us/office/client-developer/excel/programming-with-the-c-api-in-excel)
- O’Reilly book [“Python for Excel”](https://www.amazon.com/Python-Excel-Environment-Automation-Analysis/dp/1492081000/ref=sr_1_1)
- Stackoverflow article [“How to open Excel workbook from powershell for automation”](https://stackoverflow.com/questions/37665118/how-to-open-excel-workbook-from-powershell-for-automation)

---

_[View the full topic](https://community.jenkins.io/t/reading-excel-value/8123)._
