activities
latest
false
Productivity Activities
Last updated Oct 23, 2024

Using Excel APIs

To use the Excel APIs, apply the following steps:
  1. Download the activity package.
  2. Create a Coded Workflow.
  3. Call the excel.UseExcelFile method to retrieve the handle of an Excel file.
    Note: By default, the excel.UseExcelFile method uses the Excel options from Project settings for the resulting handle. However, you can change the behavior by overriding the default options through the excel.ExcelProcessScope method.
  4. Use the handle to perform actions. With the Excel coded automation, you should be able to perform the same operations as with the Excel modern activities in a .xaml file.
    Note: You can use the IExcelProcess handle that is returned with UseExcelFile to better control the Excel application. For example, you can control how Excel is opened or closed on exit.
  5. For Workbook activities, use the excel.UseWorkBook method to retrieve the handle of an Excel file. The available activities are also implemented as extension methods on the ExcelOperations class.
    Note: The Excel activities are implemented in the Coded service as extension methods for handles. To check all the available extension methods, type ExcelOperations. and then Ctrl + Space.

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.