**YouTube** is an American [online video-sharing](https://en.wikipedia.org/wiki/Video_hosting_service "Video hosting service") [platform](https://en.wikipedia.org/wiki/Web_platform "Web platform") headquartered in [San Bruno, California](https://en.wikipedia.org/wiki/San_Bruno,_California "San Bruno, California")

cf3f59da-c081-4fab-99d2-f02e60e183b0.PNG

40eff6f7-ee0a-4897-a629-91d9ccb2195e.zip

Built to enterprise-level and industry-leading standards, this component utilises 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 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
Copyright (C) 2018 Symphony Ventures Ltd. This is the first version of this snippet released on UiPath Go!

Symphony - Excel, Read Range