Add empty row and columns to Datatable

Hello everyone,
I have an excel sheet, i have read the excel sheet and saved to DT

I want to add a empty data row - in the beginning of the DT.

I also want to add empty column between column U and V

Thank you

@hansen_Lobo

  1. Use add data column activity and then How to Change the Ordinal of DataColumn
  2. for row use invoke code again https://www.youtube.com/watch?v=A-ZWCvUgUVU

cheers

@hansen_Lobo,

Here is possible approach.

Full Solution:

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

Output:

Input File:

Output sheet:
Green highlighted new Column and Row

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.