Sign In
Create your first automation in just a few minutes.Try Studio Web →
Symphony - Excel, Write Range
by Sitel Group
4
Snippet
115
Summary
Summary
Write data to a single sheet within a given Workbook, factoring in password protection and overwriting any existing data.
Overview
Overview
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 write table headers or not, by setting the in_BoolAddHeaders argument to true or false. A spreadsheet password can also be provided when applicable.
Pre-Condition: Input arguments are not null or not initialised
Post-Condition: Workbook written to exists.
Arguments:
in_BoolAddHeaders
in_DtToWrite
in_StrSheetName
in_StrWorkbookFileName
in_StrWorkbookFilePath
in_StrStartingCellReference
in_StrWorkbookPassword (Optional)
Features
Features
This component removes the need for you to ever rebuild the writing 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 and it will integrate seamlessly with any existing workflow. Simply invoke this component and provide any necessary arguments
Additional Information
Additional Information
Dependencies
UiPath Studio 2018.1.2 or later. Microsoft Office - Excel
Code Language
Visual Basic
Technical
Version
1.0.0Updated
September 8, 2021Works with
Studio: 18.1.2 - 22.10
Certification
Silver Certified
Application
Support
UiPath Community Support
Similar Listings
