A developer needs to create a process that writes the table to an Excel file. While creating this process, the developer notices that two activities with the same name can write the scraped DataTable to Excel.
What are the differences between the Workbook and Excel Write Range activities?
The Excel Write Range activity must be used within an Excel Application Scope activity, ensuring that Excel is running and in use for the operations performed by the activity. This activity specifically interacts with Excel files by leveraging the Excel application. On the other hand, the Workbook Write Range activity is more generic and can be used with Excel files without needing the Excel application to be open or even installed. It accesses the file directly, requiring the file to be closed before modifying it.
Compatibility: The "Workbook Write Range" activity is compatible with both Excel and OpenOffice spreadsheets, while the "Excel Write Range" activity is specifically designed for Excel files. File handling: The "Workbook Write Range" activity creates a new file if the specified file path does not exist, while the "Excel Write Range" activity throws an exception if the specified file path does not exist. If the file already exists, both activities overwrite the existing file.
Hi, The "Workbook Write Range" and "Excel Write Range" activity creates a new file if the specified file path does not exist.If the file already exists, both activities overwrite the existing file.
B because... well others are not true
It is B
Answer is B