A consulting, implementation and managed services firm, passionate about the ‘Future of Work’.

We help enterprises leverage the latest Robotic Process Automation, Intelligent Automation and innovative resourcing solutions.

The Symphony team is an experienced group of practitioners known for being champions of innovation and the implementers of change. We are recognized and respected experts in the technologies and approaches that represent the ‘Future of Work’.

We are recognized as a leading automation service provider. Our extensive experience, process-first approach, and background in consulting and outsourcing services, allows us to create clear value and rapid ROI for our clients around the world.

d797799d-f55b-4ca4-9bd2-4c6301e27e44.jpg

439aca74-bd9a-4547-89fd-f21525dba87f.jpg

Head of UiPath

ed143b8e-a529-4089-83d5-57f72e112385.xaml

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)

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

Version	Release Date	Download Link
1.0.0	October 7, 2018
First Release

Symphony - Excel Read Range