Capture chrome console logs and network when i run my test suite and validate downloaded excel sheet

Is the URL of your target web app publicly accessible via Internet? Or is it a private one?

If it is a private one, it would be difficult to provide you any sample code satisfactory for you. All I can show to you is this: How to make Katalon Test Case listen to Javascript console.log() from Chrome