From the course: Blue Prism: Excel Automation
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Write collection - Blue Prism Tutorial
From the course: Blue Prism: Excel Automation
Write collection
- [Narrator] Writing information in Excel workbooks can be performed in a few different ways. The approach you pick really depends on the amount of data you need to enter into the worksheet. If you need to enter a huge data set, it can be very time consuming, and you need to select the most effective approach for this type of process. If you sync the Excel VBO, you have a few options based on the data format. Write collection, copy and paste worksheet range, as well as import CSV. Write collection, as you can already guess, is used when the input information is in a collection format. This might not be the best option when it comes to huge sets of data. Copy and paste worksheet range, needs the source and the destination workbook. And the import CSV requires the information which needs to transfer to be in a CSV format. Also, Blue Prism recently introduced the usage of the object linking and embedded database, sometimes…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.