Object reference not set to an instance of an objec.....read ranget

Hi,

Based on my experience we would get this on workbook read range if we try with empty sheets. Could you confirm whether we are using workbook read range for this requirement.

If you are using workbook read range. For work around could you use excel application scope and provide input your excel and use read range inside your excel application scope and try.

And also I could see below thread resembles your issue. Please review. Thanks.