Retaining datatable format (header color etc)

Hi UiPath,

Is it possible to retain the header colors of an excel file?

let say I have DT1 and DT1 have multiple headers with colosr. I want to save it in a datatable variable retaining its color.

will that be possible?



No, datatable variable doesn’t store that information. You would have to design a workaround for that.


Thanks for your response I appreciate it!

You can use additional Package UiPath.Team.Excel.Extensions.Activities. Included Excel Extension Scope returns an ExcelSession object, that can be used to retrieve cell color.
Following method will return color decimal code.

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