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”