Reading Excel Value

[kalai]

Can Jenkins read an excel file with .xls/.xlsx format? If so how can we achieve it?

[MarkEWaite (Mark Waite)]

Good advice from @halkeye in an earlier post:

How to use .jxl excel read write libary in Jenkins?

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?”
• Microsoft article on Programming with the C API in Excel
• O’Reilly book “Python for Excel”
• Stackoverflow article “How to open Excel workbook from powershell for automation”

[poddingue (Bruno Verachten)]

I would definitely go with a Java process on the agent thanks to a library like Apache POI (which I used to use quite extensively for a big project years ago).