3363838a-aca6-487c-9e59-3e2fd839ef60.jpg

System Analyst

a254ce57-b840-4e81-84d8-3383e84c4d6d.nupkg

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.

Excel column width adjustor as per requirements

5c1e5c2a-9f2e-4957-b921-47b44d2dc98c.PNG

59ec54b1-c1b0-4279-a90c-6cb3e0cbc505.PNG

25f985a3-9bc9-4f22-b4b8-240693583cf0.PNG

6432a1d6-4fdb-4337-a74e-730043e73f4a.PNG

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
1.0.31	September 25, 2019
This is the first version of Excel Column Width set activity

Excel Column Width Activities