Write data of a data table to specific columns on Excel file

Help Activities
, ,
1

Hi,

I am working on a project wherein I need to write the contents of my data table to specific columns on my Excel sheet.

The excel sheet has the following headers:
image

while my data table has the following headers:
image

Is there any way I can write the data to their respective places on Excel given that there are columns on the Excel file that have to be skipped. These columns are for formulas. Formulas are just overwritten when I tried to write the data table wherein I insert extra columns first to match the schema of the excel.

Thank you!

2

Add the missing columns then reorder to match Excel, then just use Write Range or Append Range.

3

@_pjflo

For each set of columns its better you use a filter datatable activity to match the columns and then use write range with cell number…because if not the values would be over written if formula are not inserted

Eg: you can use filter datatbe and have columns from ID to address and then use write range with cell number as E2

Same can be followed for other columns

Hope this helps

Cheers

1 Like
4

You Can use merge Data table the values for the req columns will be filled…
if you want to remove the empty columns you can use filter data table

5

Thanks for your response! I’ve tried this one, however, the formulas are being overwritten.

6

Thanks for the idea! I would definitely try this one.

1 Like
7

That’s a completely different issue. Search the forums to learn how to deal with formulas.

1 Like
8

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