About Auto Fit Range

Help Studio
1

Hii
I want To Use Auto Fit Range In Classic.
Is there Any Method Or Activity - To Use Auto Fit Range in Classic Design

2
  1. Use Excel Application Scope: Drag an “Excel Application Scope” activity to your workflow and provide the path to the Excel file.
  2. Read Data and Determine Column Widths: Read the data you want to write into the Excel sheet using a “Read Range” activity. You can then analyze the data to determine the maximum width needed for each column.
  3. Set Column Widths: Using the “Invoke VBA” activity, you can run a VBA macro within Excel to set the column widths based on the determined maximum widths.
  4. Invoke VBA Macro in UiPath: Use the “Invoke VBA” activity in UiPath to execute the VBA macro you’ve created. Provide the macro code within the activity’s properties.

Remember that this approach requires some familiarity with Excel VBA and UiPath’s activities. Be sure to test this solution on sample data to ensure it meets your requirements.

Hope it helps

3

Hi @Prakash_Patnala ,
You can use invoke VBA

4

Hi @Prakash_Patnala

Please find below xaml for your reference

BlankProcess8.zip (159.1 KB)

I hope it helps!!