Which statement is true about the Write Range activity?

The statement that the Write Range activity overwrites old data if the range is not specified is accurate. When using the Write Range activity in RPA tools, such as UiPath, the activity writes data to a specified range in an Excel workbook. If no range is defined, the Write Range activity typically defaults to the beginning of the worksheet, which means it will overwrite any existing data in that area. This behavior is crucial for developers to understand since failing to specify a range can result in unintentional data loss.

In contrast, the other statements lack correctness. The Write Range activity can indeed create new files if the file specified does not already exist. It doesn't inherently append data to existing records unless explicitly directed to do so. Lastly, it is not limited to writing in open workbooks; it can interact with closed workbooks as well, depending on the implementation in the automation process. Understanding this behavior of the Write Range activity is essential for effectively managing data in RPA scenarios.