Why does Read Range of Modern Excel Activity not throw exception if target sheet not exist?

Help Activities
, ,
1

Hi All,

just wondering why behavior Excel between Classic and Modern are different.
for an example of Read Range

  • Classic
    if target sheet not exist in the excel file, it will throw exception the sheet “xxxx” does not exist

  • Modern
    if target sheet not exist in the excel file, it will create a new sheet and read range empty table.

if you see both behavior, the output of classic will make me found the root cause the issue quicker than Modern from why the datatable return empty.

I really appreciate if someone could explain to me why modern do difference action from Classic.

thank you,
Indra

2

@irahmat

In use excel file activity you have a create new if not exists field…toggle that to false and it would not create

Cheers

3

doesn’t matter the target sheet will be created or not but why there is no exception. please understand my point.

thanks,

1 Like
4

@irahmat

Got you…agreed

cheers

1 Like
5

@irahmat

May be its a bug…be ause one thing I observed is even if you toggle create sheet it still creates the sheet in excel which might be causing the issue

Cheers