To overwrite Excel Sheet range

[Polite123]

Hi Team,

Need help for below topic.

I have three different tables.They are supposed to be part of the same sheet.

So I tried using Excel range at three different positions.I have used the correct range.

When I run it for the first time,it runs fine.

But when I run it for the second time below issue pops up despite Overwrite Sheet(Drop) option selected

Encountered existing data beyond specified range.

[ShankerV]

Hi @Polite123 

This might be due to the Configuration on Output tool related to Max Records Per file.

Please do the modification to overcome the issue.

Many thanks

Shanker V

[binuacs · Accepted solution]

@Polite123 Try to increase the range and try again.

[ShankerV]

Hi @Polite123 

If the error still pertains, please share the snipshot of your settings. 

Will be useful for investigating further as we can use Block Until Done tool also.

Many thanks

Shanker V

[Polite123]

Hi @ShankerV , @binuacs,

Thanks for quick reply.

I have not set max records per file...Also tried increasing the range but to now avail.

Block until done is also tried.

[binuacs]

@Polite123 would you be able to provide some sample data and expected output?

[Polite123]

Hi @binuacs ,

I managed to solve it by increasing the range to 9999.

Thank you so much for your help.

[binuacs]

@Polite123 Good to know that you are able to fix the issue!!

[SkyDe]

Hello,

Do you know why I'm having issues with a .xls file? I have done an overwrite and preserver formatting for .xlsx and it has worked, but I can not get it to work for .xls, please see the attached screen shots.