MarketplaceStudioActivityExcel Column Width Activities

Create your first automation in just a few minutes.Try Studio Web

Excel Column Width Activities

Excel Column Width Activities

by Om Prakash Dubey

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

4.1k

back button
back button
carouselImage0
next button
next button

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:

  • All column autofit: Sets auto fit to the entire column in the provided Excel sheets.

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.

  • Column autofit: Sets auto fit to the provided column range in the Excel sheet.

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.

  • Set column width: Set a fixed width to specific columns.

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)

Publisher

Om Prakash Dubey

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.31

Updated

February 18, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings