Append formatted data to existing excel file

tanja90

Hi all,

I have excel file which was created and updated with data manually for years. This report needs to be automated but new output data should append to existing excel file, plus formatting has changed. 

So, here I have more problems, but the point would be:

1) Is there any way how to achieve output like on image?

2) if colors ignored,  is it possible to append data without any formatting?

Thank you

AppendTableToExistingExcel.png

echuong1

Both are possible. You'd need to reformat the data in designer to match the format of the "end" output table. For the output, you'd choose "append to existing sheet" to append the records. If you'd like to keep the formatting, check the box to preserve formatting.