Excel_Reading__001

Help Studio
, ,
1

Hello Guys,

I have a excel with 5 sheet which are interlinked with formulas each other.

i need to one of the sheets and write it in the same excel.

But i couldn’t write the data to another sheet.

It is taking toomuch time and and shwing error like “unexpected error occurred”

And excel got currupted.

Is there any way to to do that

2

@Gokul_Murali

try with duplicate sheet activity

or copy paste range or use workbook activities

cheers

3

@Anil_G

still the same I couldn’t read a particular sheet and write into a new Sheet

4

Hi @Gokul_Murali ,
Could you please share file
what’s activity using and error?
regards,

5

@Gokul_Murali

What did you try…waht is the error… please explain to get the right support

cheers

6

Hi @Gokul_Murali

  1. Consider using the “Excel Application Scope” activity with the “Visible” property set to False to perform background automation. This can improve performance.
  2. Implement robust error handling in your automation workflow. Use try-catch blocks to capture errors and log relevant information to understand where the issue is occurring.
7

Guys The issue fixed

Requirement -

Excel containing 5 sheet and each sheet is linked with formulas.
I couldnt read and write data in a new sheet
it shows error like “An Unexpected Error Occurred”
After writing the data the entire format of the excel got changed

Solution -

I Used modern excel activity to read that particular excel and modern activity to write the excel

1 Like