Can Jenkins read an excel file with .xls/.xlsx format? If so how can we achieve it?
Good advice from @halkeye in an earlier post:
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”
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).