Create your first automation in just a few minutes.Try Studio Web →
by Om Prakash Dubey
0
Activity
4.1k
Summary
Summary
Excel column width adjustor as per requirements
Overview
Overview
This activity has been built to adjust Excel column width.
The following activities are available:
Input:
A. ExcelPath: Full path of the Excel file.
B. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.
Input:
A. ExcelPath: Full path of the Excel.
B. ColumnRange: Enter the column range that needs the width to be set as autofit.
e.g. – “A1:A1” , “A1:C1”
C. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.
Input:
A. ExcelPath: Full path of the Excel.
B. ColumnName: Add the column name separated by commas.
C. SheetName: Add the sheet name separated by commas. If left blank it will consider all the sheets available in the Excel.
D. Width: Width of the column.
Features
Features
These activities will help to automate Excel where you need to set column width as manual or auto fit in report generation.
Additional Information
Additional Information
Dependencies
Microsoft.Office.Interop.Excel
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.31Updated
February 18, 2020Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Support
UiPath Community Support
Resources