How to keep excel format after use filter datatable

Hello Hoai_Nguy_n_Xuan,

Firstly, warm wishes and welcome to the UiPath community.

When you write to a new excel file, the default format gets applied as per the template defined. that is the reason you see the bold centered headings and fonts are changed.

If you want to retain the same format, you can create a new excel with header defining the font formats you need, save it as a template and start writing the result of filter to that file.
Alternatively, you can also pragmatically inject formats at the time of writing your results by using Invoke VBA activity. This method injects VBA on every run.

Hope this helps.

  • Sri
2 Likes