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.

Built to enterprise-level and industry-leading standards, this component utilises the Excel Application Scope so that&nbsp;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

Symphony - Excel, Read Range

Help

How To