Write datatable to Excel destination field format

Help Studio
, ,
1

This image shows a "Write DataTable to Excel" activity from an automation tool, indicating that the "dt_RoUBalance" DataTable is set to be written to an unspecified destination in append mode, with a red error icon. (Captioned by AI)
This image shows a "Write DataTable to Excel" activity from an automation tool, indicating that the "dt_RoUBalance" DataTable is set to be written to an unspecified destination in append mode, with a red error icon. (Captioned by AI)592×245 8.38 KB

How to set destination value ,
I want to write the output data, which is 150 rows fetched in a datatable, and from the datatable to an excel file.
What is the correct format to use in destination field?

2

Hi @automated ,

Here’s an example for you. If you give an actual path to Excel, then you’ll get direct options to select the target. If you use a variable for the Excel path, then you need to know how to specify the destination.

image
image948×731 27.1 KB

3

Thank you, @sudster, for the solution. It is working fine.