A developer needs to create a process that performs the following:
1. Scrapes a table of common English-Spanish translations
2. Writes the table to an Excel file
3. Emails that Excel file as an attachment
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?
- Excel Write Range activity can only be used when Excel is installed.
Workbook Write Range activity can be faster by writing the data directly to the file. - Excel Write Range activity only works in the foreground, visible to the user. Workbook Write Range activity only works in the background.
- Excel Write Range activity will create the file in the WorkbookPath property if it does not exist. Workbook Write Range activity can only be used when Excel is installed.
- Excel Write Range activity only works in the background.
Workbook Write Range activity will create the file in the WorkbookPath property if it does not exist.
Reveal Solution Next Question