**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.

Symphony - Excel, Read Range