/Library-Tools

[WIP] A UiPath tools library.

Primary LanguageC#MIT LicenseMIT

Library-Tools

This project is a UiPath tools library.

Language

C#

Contents

  1. File_ReadExcelToTable
  2. File_ReadWorkbookToTable

File_ReadExcelToTable

This workflow reads a worksheet in a Microsoft Excel document by using the Excel activities and returns a data table.

Arguments
  1. String in_FilePath - The file path to the Microsoft Excel document.
  2. String in_Worksheet - The worksheet name.
  3. Boolean in_WorksheetHasHeaders - If the worrksheet has a header row.
  4. String in_WorksheetRange
  5. DataTable out_Dt_Data

File_ReadWorkbookToTable

Type Argument Annotation
String in_FilePath The file path to the Microsoft Excel document.
String in_Worksheet The worksheet name.
Boolean in_WorksheetHasHeaders If the worrksheet has a header row.
String in_WorksheetRange The range of the worksheet. The entire sheet will be read if the worksheet range is blank.
DataTable out_Dt_Data The data table containing the worksheet data.