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 sheet.zip (18.6 KB)
Regards,
Krishna
1 Like
@ROBERT_RUSSELL_MONSA
BTW,
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 
Happy Automation 
Best Regards
Er Pratik Wavhal 
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.