Write headers at once

Help Activities
, , ,
1

Is there an easy way that I can write column headers in a cell range at once without having to use a “Write Cell” activity for each column ?.

I know there is the Write Range activity but it only works with DataTables as a value.

Any recommendations in this regard?

2

Hi,

Although it might not be very good solution, the following step will work.

  1. Open xlsx file using Excel Application Scope.

  2. Store header data which is separated by chr(9) in clipboard using Set To Clipboard.

  3. Select cell which header starts from using Select Range.

  4. Send hotkey Ctrl+v to the worksheet (or specific cell if possible).

img20210813-2
img20210813-2459×607 12.6 KB

If we have header information as array or list. String.Join is useful in this case.

Regards,