Exam UiARD All QuestionsBrowse all questions from this exam
Question 19

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?

    Correct Answer: A

    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-related activities typically require the Excel application to be installed on the machine where the process is running, allowing interaction with Excel-specific features. Conversely, Workbook activities interact directly with the file system, bypassing the overhead of launching the Excel application, thus potentially offering improved performance.

Discussion
MirjalolOption: A

Answer is A

SandeepjnvOption: A

It is A

robert_lovaszOption: A

what is this baloney again "create the file in the WorkbookPath property" how do you create a file in a property? :)

Aryan12345Option: A

Correct Answer ia A.

sakanank

Correct