How to Append a Value/Range (from variable) Under a Specific Header in Excel?

Help Studio
, ,
1

Hi All

Here is what I am trying to do:

  • I have a variable value in UiPath ‘strName’
  • I need to paste/append this under a specific column name in an excel sheet ‘column’ name (already have column name)

Any ideas on how to do this?

I think I need to build a datatable and input ‘strName’

I cannot find any info on how to append under a given column header name in excel

Any ideas would be greatly appreciated!

2

@Cameron_Pirrie

If you want to write multiple cell values then you can use data table to write the specific data under a specific column. Please find the below workflow for ref

Example.zip (9.9 KB)

If you want to write in a single cell under a specific column then use can use write cell activity

3

Thanks!

This looks good but I have 2 questions:

  • How to add my Variable into the data table?
  • How to append the data in excel under a column using the ‘column header name’ (not the cell value)?
4

@Cameron_Pirrie can you try Text to column activity to achieve this requirement.

5

did you tried with add data row ?

6

@Cameron_Pirrie

  • You can use Add Data Row activity to add data to the data table
  • Using look up range activity you can find the in which cell the specific header name present. Below that header you can write the data

Please find attached workflow for ref

Example.zip (10.3 KB)