Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Symphony - Excel Read Range
by Sitel Group
3
Snippet
190
Summary
Summary
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
Code Language
Visual Basic
Technical
Version
1.0.0Updated
Jun 22, 2023Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Tags
application-scope
component
datatable
excel
file
microsoft-office
read
spreadsheet
studio
symphony
Application
Microsoft Excel
Support
UiPath Community Support
Similar Listings
