Adding new data row at the beginning of the table

Help
1

Hi,

befor Write CSV file I would like to add title (heading) of my table (in cell A1) - table should start from A2 against A1).
How I could do this?

1 Like
3

You can select Add Header Option in the Write CSV activity it will leave 1st Row

4

@Krzysztof

Use Merge cell activity and in properties panel in cell Text field give the heading you want to add,and in merge range give the range of cells.

This activity is present in BalReva.Excel.activities, download it.

Regards,
A Manohar

5

But I don’t want to leave 1st Row - I would like to add new 1st row as a title of the table.

6

1.Create your Datatable ex:dt_sample using Build datatable activity
2.use add data row activity and create a data row what ever you want to add as first row
3.Write dt_Sample in to your CSV without selecting header
4.Use Append CSV

1 Like
7

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