Uipath Marketplace
MarketplaceListingsSnippetSymphony - Excel Read Range

Create your first automation in just a few minutes.Try Studio Web

Symphony - Excel Read Range

Symphony - Excel Read Range

by Sitel Group

3

Snippet

Downloads

191

back button
back button
carouselImage0
next button
next button

Summary

Summary

Extract data from a singl​e sheet within a given Workbook, factoring in password protection if applicable.

Overview

Overview

Built to enterprise-level and industry-leading standards, this snippet utilizes the Excel Application Scope so that it can be run entirely in the background. 

It is 100% reusable with pre and post conditions to ensure safe and reliable operation, and can be configured to read in table headers or not, by setting the in_BoolAddHeader to true or false. A spreadsheet password can also be provided when applicable.

  • ​​**Pre-Condition:**​ Check for existence of the required Workbook, if not found, throw Application Exception.
  • Post-Condition: Checks if the output DataTable is initialised​.

Arguments:

  • ​in_BoolAddHeaders
  • ​out_DtExtractedData
  • ​​in_StrSheetName
  • in_StrWorkbookFileName
  • ​in_StrWorkbookFilePath
  • ​in_StrRange
  • in_StrWorkbookPassword (Optional)

Features

Features

This snippet removes the need for you to ever rebuild the reading of a spreadsheet again; it has been built with exception handling, reliability and 100% reusability in mind, meaning that all of the actions you may want to perform are possible. It will integrate seamlessly with any existing workflow. Simply invoke this component and provide any necessary arguments.

Additional Information

Additional Information

Dependencies

UiPath Studio 2021 or later. Microsoft Office - Excel

Code Language

Visual Basic

Publisher

Sitel Group

Visit publisher's page

Trusted Source

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.0

Updated

Jun 22, 2023

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings