Retaining datatable format (header color etc)

Help Studio
, ,
1

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?

Thanks!

AA

2

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

3

@krzysztof.szwed

Thanks for your response I appreciate it!

4

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.
excelSession.worksheet.Range(“B1”,“B1”).Interior.Color.

5

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