How to keep excel format after use filter datatable

image
I read an excel file then I use filter datatable, but when I write the filtered data, the preserve format are gone. Does anybody have solutions for this? Thank you so much

I mean when I wrote it to a new Excel file, it become like this
image

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

I got it, Thank you <3

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