Add empty row and columns to Datatable

Help Studio
, ,
3

@hansen_Lobo,

Here is possible approach.

Full Solution:

This image depicts a sequence of activities in an automation workflow, starting with reading an Excel file, manipulating data, and writing the results to a specified worksheet. (Captioned by AI)
This image depicts a sequence of activities in an automation workflow, starting with reading an Excel file, manipulating data, and writing the results to a specified worksheet. (Captioned by AI)519×1283 59.5 KB

The image shows a workflow in UiPath where a data column is added to a DataTable, an "Invoke Method" activity is used to set the ordinal position of the column, and the parameters and properties are configured for this method. (Captioned by AI)
The image shows a workflow in UiPath where a data column is added to a DataTable, an "Invoke Method" activity is used to set the ordinal position of the column, and the parameters and properties are configured for this method. (Captioned by AI)1227×743 78.3 KB

Property Target Object value:
dtOutput.Columns(dtOutput.ColumnCount-1)

Output:

The image displays a comparison between two data tables, "dtInput" and "dtOutput," with "dtOutput" containing an additional "New Column" circled in green. (Captioned by AI)
The image displays a comparison between two data tables, "dtInput" and "dtOutput," with "dtOutput" containing an additional "New Column" circled in green. (Captioned by AI)712×369 21 KB

Input File:

This image shows an Excel spreadsheet with two rows of data, including columns for Number, Locale, ID, Date, and multiple areas all marked as "UK". (Captioned by AI)
This image shows an Excel spreadsheet with two rows of data, including columns for Number, Locale, ID, Date, and multiple areas all marked as "UK". (Captioned by AI)1915×799 50.8 KB

Output sheet:
Green highlighted new Column and Row

The image shows an Excel spreadsheet with columns labeled "Area5" to "Area22" and "New Column," containing repeated "UK" entries in some cells, with certain column headers and the new column highlighted in green. (Captioned by AI)
The image shows an Excel spreadsheet with columns labeled "Area5" to "Area22" and "New Column," containing repeated "UK" entries in some cells, with certain column headers and the new column highlighted in green. (Captioned by AI)1724×749 64.4 KB

Could not share the xaml but you should be able to recreate it quickly. Feel free to let me know if any issue.

3 Likes