Error in adding new sheet in an Excel file

How to solve this kind of error in adding new sheet in an Excel file?

Input.xlsx (7.8 KB) Main.xaml (4.8 KB)

Error Message: “Read Range: Object reference not set to an instance of an object.”


I hope your requirement is to add a new sheet to an excel.
Please find the workflow I’ve attached. Please make sure you’ve installed ‘BalaReva.Excel.Activities’ from the package manager brfore running the workflow.
Add new (18.6 KB)


1 Like

Your workflow is also fine. I tried it, and i got the output.

1 Like


Instead of using any activities you can just mention the new sheet name while writing the data to that particular sheet within the Write Range Activity. Automatically it adds the new sheet to the Excel.

Just try it Hope this helps you.
Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

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