Read Range Error in Excel

Help Studio
, ,
1

I am looping Excel files from a folder, but one Excel doesn’t have any kind of data in it. Bot stops there by showing exception in read range activity like - ‘Read Range Workbook: Object reference not set to an instance of an object.’.
How can i sort this issue?

2

@ajnaraya

Either use a try catch around

or first check by reading one cell if data is present and then read

cheers

3

Go with try catch or Excel Application Scope’s Read Range

4

Hello @ajnaraya , Usually if there is no data in the Excel file, Read range throws an error. To handle this Exception, Use Try catch Method. For more info refer to this thread.

1 Like
5

can we consider it a business rule exception or a system exception?

6

Hey @ajnaraya ,

If the excel file is empty then The read range workbook activity throws an nullReference Exception

So to handle this exception , please surround your read range activity using Try Catch activity
Wrap the Read Range workbook activity like below screenshot
image

Hope it helps you out

2 Likes
7

Hi, please use excel activities instead of workbook activity.

excel1
excel1697×412 10.7 KB

1 Like
8

@ajnaraya

Surround the Read range with try catch and supress the error in catch block as system exception.

1 Like
9

H! @ajnaraya

You can try with this way,
in catch you can keep log messages to display ‘Excel Sheet contains no data rows’

image
image878×353 34.3 KB

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.