Ecxel automation

Hi i need to read data from diffrent files and write data to another sheet. For that i am reading one file from folder and reading the data where I need to write and writing using range for first time it’s working properly but for second run data table where I need to write data is throwing error “could not read range” Can anyone help

Hi @nanda_kishore

Welcome to Community!

Is it possible to share the screenshot of your workflow?


Hi! @nanda_kishore

Why it is happening because you’re writing the data in to the columns and rows which is already data filled. try to change the sheet range. or you can change the sheet name.


Sounds like you’re using a read range instead of a write range. Also, make sure you don’t have the Excel file open when the automation is trying to read or write it.