Question regarding DataTables

Help Something Else
3

@karsten_delfino

  1. Add Excel Application Scope:
  • Drag and drop the Excel Application Scope activity.
  • Set the WorkbookPath to your Excel file path.
  1. Write the DataTable to Excel:
  • Inside the Excel Application Scope, drag and drop the Write Range activity.
  • Set the SheetName to the desired sheet (e.g., “Sheet1”).
  • Set the StartingCell to the starting cell where you want to write (e.g., “A2”).
  • Set the DataTable to dt_Extracted.
  • Set AddHeaders to False if your DataTable does not include headers
    check the workflow
    Main.xaml (6.9 KB)
    New Microsoft Excel Worksheet.xlsx (7.5 KB)
1 Like